Skip to main content
Skip table of contents

Bringing consistency and uniformity across EUV/AUV windows

Content was last updated in 06.23.10-00

Revision History

  Version No.

  Reference No.

  Changes

  06.23.10-00

  R2-21016

Now Include/Exclude Purchase option in EUV&AUV availability.

  06.23.08-00

  R2-20807

Ensuring consistency and uniformity between EUV/AUV windows

 

In R2, the availability/Unpalatability of Items added to Orders are bound by the dates these Order start and end on.

So, it might be possible that despite having sufficient inventory, availability of a specific item for an Order is impacted since one starts on the day another Order ends.

Let's begin with a situation where we have 4 orders and none of them overlap. Here, if there is a case of Items not being available on a specific date, it would strictly be a 'Stock' count issue.

 

Examples of Orders with 'No' Overlapping Start/End Dates

Sites: San Francisco.
Stock: SKU-0179 (16)

Scenario#

Order Site

Line Shipping Site

Order ID

Order Type

Item Status

Opening Stock @ Site

Order Quantity

Order line Prep-Return Date

Result

 

 

 

 

 

 

 

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

 

Orders with Overlapping Start/End Dates

Item ID: SKU-0179 >>> Residual Stock @ Site

16

16

8

8

8

8

8

8

8

8

8

8

8

1

1

1

1

1

8

-2

-2

-2

-2

-2

8

8

8

8

8

8

8

There will be mismatch between the actual quantity available and the displayed count.

San Francisco

San Francisco

Ord-111

Rental

Reserved

16

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Ord-129

Sale

Reserved

16

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Otd-137

Rental

Reserved

16

7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Ord-144

Rental

Not-available

16

10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now let's modify the Order dates and see how does this impact the overall situation.

This time two of the Orders become "Not Available" as the required inventory is not available on a specific date.

Examples of Orders with Overlapping Start/End Dates

Sites: San Francisco.
Stock: SKU-0179 (30)

Scenario#

Order Site

Line Shipping Site

Order ID

Order Type

Item Status

Opening Stock @ Site

Order Quantity

Order line Prep-Return Date

Result

 

 

 

 

 

 

 

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

 

Orders with Overlapping Start/End Dates

Item ID: SKU-0179 >>> Residual Stock @ Site

16

16

8

8

8

8

8

8

8

8

8

8

-7

1

1

1

1

-9

-9

-9

-2

-2

-2

-2

-2

-2

-2

-2

-2

-2

-2

There will be mismatch between the actual quantity available and the displayed count.

San Francisco

San Francisco

Ord-111

Rental

Reserved

16

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Ord-129

Sale

Reserved

16

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Otd-137

Rental

Not-available

16

7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Ord-144

Rental

Not-available

16

10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now from above situation, let's start considering the 'Time Stamp' as well in the Order-of-preference of Order fulfillment.

Since, while considering the 'Time Stamp' when Order date is same, Orders are processed on a 'First-come First Serve' basis, shown below is situation of 3 Orders whose Ending / Starting date falls on 13th July.

As you can see, the Order 'Ord-137' which earlier could not get processed, now can go out successfully, as after considering the time-factor, enough inventory would be available at the time, when it is needed.

Exploring Order# Ord-111, Ord-129, and Ord-137 within a 24 Hour Windows for 13th July

Sites: San Francisco.
Stock: SKU-0179 (30)

Scenario#

Order Site

Line Shipping Site

Order ID

Order Type

Item Status

Opening Stock @ Site

Order Quantity

Order line Prep-Return Date

Result

 

 

 

 

 

 

 

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

 

Order's End-time Considered

Item ID: SKU-0179 >>> Residual Stock @ Site

8

8

8

8

8

8

8

8

8

16

16

16

16

16

16

16

8

8

8

1

1

1

1

1

There will be No Mismatch. As considering the 'Time Factor' will resolve the conflict.

San Francisco

San Francisco

Ord-111

Rental

Reserved

21

8

Order ends @ 09:00 AM on 13th July

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Ord-129

Sale

Reserved

21

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sale Order happens @ 05:00 PM

San Francisco

San Francisco

Otd-137

Rental

Reserved

21

7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Order begins @ 8:00 PM

In the chart below, we are considering Orders: 'Ord 137' and 'Ord-144' whose ending and Starting date coincides on 20th July.

Since earlier the time-factor was not considered, Ord-144 remained unprocessed, as a transcending effect of Ord-137 being unprocessed.

Now, let's consider the time factor and see how this changes the situation for these two Orders.

Exploring Order# Ord-111, Ord-129, and Ord-137 within a 24 Hour Windows for 20th July

Sites: San Francisco.
Stock: SKU-0179 (30)

Scenario#

Order Site

Line Shipping Site

Order ID

Order Type

Item Status

Opening Stock @ Site

Order Quantity

Order line Prep-Return Date

Result

 

 

 

 

 

 

 

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

 

Order's End-time Considered

Item ID: SKU-0179 >>> Residual Stock @ Site

1

1

1

1

1

1

8

8

8

8

8

8

8

8

-2

-2

-2

-2-

-2

-2

-2

-2

-2

-2

There will be No Mismatch. As considering the 'Time Factor' will resolve the conflict.

San Francisco

San Francisco

Ord-137

Rental

Reserved

21

8

Order ends @ 06:00 AM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Otd-144

Rental

Not-available

21

10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Rental Order Starts @ 3:00 PM

The Order (Ord-137) which started on 8 PM on 13th July is ending at 6 AM on 20th July. And thus at 3PM, when Ord-144 has to commence, enough inventory is still not available, so it remains unprocessed.

So, let's attempt to resolve the item unavailability by introducing a Transfer-in Order or a Purchase Order on 20th.

Here also, we will attempt at two different scenarios.

Transfer-in Order (Inventory incoming on 20th July at 9 AM) with 5 Units of SKU-0179

Exploring Order# Ord-111, Ord-129, and Ord-137 within a 24 Hour Windows for 20th July

Sites: San Francisco.
Stock: SKU-0179 (30)

Scenario#

Order Site

Line Shipping Site

Order ID

Order Type

Item Status

Opening Stock @ Site

Order Quantity

Order line Prep-Return Date

Result

 

 

 

 

 

 

 

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

 

Order's End-time Considered

Item ID: SKU-0179 >>> Residual Stock @ Site

1

1

1

1

1

1

8

8

13

13

13

13

13

13

3

3

3

3

3

3

3

3

3

3

There will be No Mismatch. As considering the 'Time Factor' will resolve the conflict.

San Francisco

San Francisco

Ord-137

Rental

Reserved

21

8

Order ends @ 06:00 AM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Transfer-in Order from New York

Trf-018

Transfer

Received-In

X

5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Otd-144

Rental

Reserved

21

10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Rental Order Starts @ 3:00 PM

A checkbox in the EUV and AUV Windows, allows you to select whether to Include/Exclude 'Purchase Orders' in the calculating Item availability.

Purchase Order (Inventory incoming on 20th July at 3 PM) with 5 Units of SKU-0179

Exploring Order# Ord-111, Ord-129, and Ord-137 within a 24 Hour Windows for 20th July

Sites: San Francisco.
Stock: SKU-0179 (30)

Scenario#

Order Site

Line Shipping Site

Order ID

Order Type

Item Status

Opening Stock @ Site

Order Quantity

Order line Prep-Return Date

Result

 

 

 

 

 

 

 

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

 

Order's End-time Considered

Item ID: SKU-0179 >>> Residual Stock @ Site

1

1

1

1

1

1

8

8

8

8

8

8

8

8

13

3

3

3

3

3

3

3

3

3

There will be No Mismatch. As considering the 'Time Factor' will resolve the conflict.

San Francisco

San Francisco

Ord-137

Rental

Reserved

21

8

Order ends @ 06:00 AM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Purchase Order at San Francisco

Pur-101

Purchase

Received-In

X

5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Otd-144

Rental

Not-available

21

10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Rental Order Ord-144 Starts @ 3:00 PM

 

As you can see in the above Gantt Chart, though at 3:00 PM, the stock is at 13 units, sufficient enough to process Ord-144, the Order is still tagged as Not-available.

This is because, it is not yet deciphered whether the Purchased stock on 5 units came in first, or the Outgoing stock for Ord-144 was meant to be shipped first.

But, since the 'Minutes' portion of time-stamp is also considered, system will apply the logic appropriately and accordingly process the Order.

Just for the depiction purpose, shown below is a break-up of time between 3:00 PM and 4:00 PM.

Exploring Order# Ord-111, Ord-129, and Ord-137 within a 24 Hour Windows for 20th July

Sites: San Francisco.
Stock: SKU-0179 (30)

Scenario#

Order Site

Line Shipping Site

Order ID

Order Type

Item Status

Opening Stock @ Site

Order Quantity

Order line Prep-Return Date

Result

 

 

 

 

 

 

 

 

15:00

15:05

15:10

15:15

15:20

15:25

15:30

15:35

15:40

15:45

15:50

15:55

16:00

 

Order's End-time Considered

Item ID: SKU-0179 >>> Residual Stock @ Site

8

8

8

13

13

13

13

3

3

3

3

3

3

There will be No Mismatch. As considering the 'Time Factor' will resolve the conflict.

Purchase Order at San Francisco

Pur-101

Purchase

Received-In

X

5

 

 

 

Pur-101

 

 

 

 

 

 

 

 

 

San Francisco

San Francisco

Otd-144

Rental

Reserved

21

10

 

 

 

 

 

 

 

Rental Order Ord-144 Starts @ 3:35 PM

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.