Skip to main content
Skip table of contents

Extending the Original Return dates

Content was last updated in 06.22.02-00

Revision History

  Version No.

  Reference No.

  Changes

  06.22.01-00

  R2-18459

View affected orders when returned date on some existing order is extended.

View Affected Orders - Due to Modification of Return Dates

You can now view how changes in the start/end dates of any rental order, can affect other rental or transfer order, not just in the same site but at other sites as well.

This conflict arises when the Order dates are changed, it alters the availability of the items, since the required quantity is no longer available on the expected dates; the shortfall subsequently restricts other order from being fulfilled..

The same information can be viewed under Affected Orders, in Accounts module.

Pre-requisites

  1. Create four sites: San Jose, London, Berlin, and Auckland.

  2. Create stock [SKU-TEST-01] at each of the sites as: San Jose (11), London(4), Berlin(3), and Auckland(1). See

  3. Create orders at each of the sites as per details given in the following table

  4. Process these Orders to Out, Filled, or Overdue status.

This clause ensures that the items are actually out from the Site's inventory, and only the residual stock at the site is considered for any subsequent Order created or any existing Order modified. These Orders are termed as Inflicting Orders.

Linguistically speaking, they are the source/reason of the shortfall trouble, and are imposing (making the impact happen) the shortfall on other Orders.

 

Table 2.0 Initially Created Scenarios

Initial Situation:

No return dates are changed

Order Site

Order Type

Order Qty

Order line Prep-Return Dates

Result(s)

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

Remaining Qty @ Site >>>

11

5

5

5

5

9

5

3

3

3

3

3

3

0

0

0

6

6

6

6

7

7

7

7

7

7

7

7

Since there is NO short-fall of quantity at any site on any given day, all the Rental Orders and Transfer Orders get processed without any hindrance.

San Jose

Rental

6

 

ORD-121

 

 

 

 

 

 

 

 

 

 

 

 

 

Rental

3

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-122

 

 

 

 

 

 

 

 

 

Transfer

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TRF-London

 

 

 

 

 

 

Transfer

2

 

 

 

 

 

 

 

TRF-Berlin

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Remaining Qty @ Site >>>

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

6

2

2

2

2

0

0

0

London

Rental

4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-221

 

Transfer

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TRF-Auckland

Remaining Qty @ Site >>>

3

3

0

0

0

3

3

5

5

5

3

3

0

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

Berlin

Rental

3

 

 

ORD-331

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Rental

2

 

 

 

 

 

 

 

 

 

 

ORD-332

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Transfer

3

 

 

 

 

 

 

 

 

 

 

 

 

TRF-Auckland

 

 

 

 

 

 

 

 

 

 

 

 

 

Remaining Qty @ Site >>>

1

1

1

1

1

1

1

1

1

1

1

1

4

4

4

4

4

0

0

0

4

4

4

2

2

4

4

6

Auckland

Rental

4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-441

 

 

 

 

 

 

 

 

 

Rental

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-442

 

 

Sample Workflow

  1. Change the begin/return dates for rental orders as follows.

Table 3.0: Sample Order Information

Order Site

Order#

Original End Date

Modified End Date

San Jose

ORD-121

16th

24th

 

ORD-122

20th

24th

Berlin

ORD-331

5th

15th

 

ORD-332

13th

15th

You can change the dates of the Orders at a site, using any of the following access points.

  1. Order > Dates Tab > Edit Dates

  2. Order > Actions > Change Dates > All Lines/ Selected Lines

  3. Order (Double click) > Line Edit Dates

  4. Order Search > Order Dates Edit

    1. Single Order

    2. Multiple Order

Also, ensure that 'View Affected Orders' checkbox is selected in the window where you had change the return date for the Order.

  1. Changing the above dates, disrupts the availability of the items at the four sites, since the required quantity is no longer available on the expected dates.

  2. The 'Extension Duration' of the Order has been depicted as              in the table below.

  3. The 'Impacted Order' due to short-fall in quantity has been depicted as Red Block in the table below.

  4. The 'Numbers in Negative' (in Remaining Qty @ Site row) refer to the shortfall quantity.

Table 4.0 Scenarios after dates are modified

Return dates are changed

Order Site

Order Type

Order Qty

 

Order line Prep-Return Dates (Modified)

 

Result(s)

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

Remaining Qty @ Site >>>

11

5

5

5

5

9

5

3

3

3

3

3

3

0

0

0

0

0

0

0

-2

-2

  • 2

0

9

9

9

9

Due to changed return dates of some order, many other related orders from the same sites (and even other sites) could not be fulfilled. This subsequently transitions into affected orders in other sites as well

San Jose

Rental

6

 

ORD-121

 

 

 

 

 

 

Rental

3

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-122

 

 

 

 

 

 

Transfer

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TRF-London

 

 

 

 

 

 

Transfer

2

 

 

 

 

 

 

 

TRF-Berlin

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Remaining Qty @ Site >>>

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

0

-2

-2

-2

-2

London

Rental

4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-221

 

Transfer

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TRF-Auckland

Remaining Qty @ Site >>>

3

3

0

0

0

0

0

0

0

0

-2

-2

-2

-5

-5

2

2

2

2

2

2

2

2

2

2

2

2

2

Berlin

Rental

3

 

 

ORD-331

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Rental

2

 

 

 

 

 

 

 

 

 

 

ORD-332

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Transfer

3

 

 

 

 

 

 

 

 

 

 

 

 

TRF-Auckland

 

 

 

 

 

 

 

 

 

 

 

 

 

Remaining Qty @ Site >>>

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

-3

-3

-3

1

1

1

-1

-1

-1

1

1

Auckland

Rental

4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-441

 

 

 

 

 

 

 

 

 

Rental

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ORD-442

 

 

 

  1. If 'View Affected Orders' checkbox is selected, then when you attempt to perform the change dates, system gives you the following prompt.

Figure 3.0 Prompt-1 conforming 'View Affected Orders'

Upon confirmation, the following prompt is shown,

Figure 4.0 Prompt-2 conforming 'View Affected Orders'

Upon further confirmation, the Affected Order(s) window are shown (Only if there are 1 or more orders which gets affected, this window is displayed).

Figure 5.0  List of 'Affected Orders' when 'Return Date' for ORD-121 is modified

Figure 6.0  List of 'Affected Orders' when 'Return Date' for ORD-331 is modified

  1. This feature lists only those Affected Orders for which the status is - Reserved, Hold, or T-Reserved.

This clause ensures that the items considered in Affected Orders are going to be consumed and system expects them to be available in the inventory.

Subsequently, when the required quantity is not available, it considered as a shortfall, and list them out as Affected Orders.

  1. In case of E-Pool Orders, the site that is considered for checking conflict is Ship and Return site of the Inflicting line.

  2. In case of Orders impacted due to an inflicting transfer order, the system considers a lock-in period of 15-days, from the first instance of transfer order.

 For Example:

Let's consider, an Order from Site A to Site B cannot be processed (assumed as cancelled) because an Order at Site A is not getting returned on its original schedule.

Thus subsequently, at Site B, an order cannot be processed, due to unavailability of required stock quantity.

In such situation, system will consider ONLY those orders as 'Impacted/Affected Orders' whose ship date falls within 15 days counting from the ship date of first Impacted/Affected order at site B.

  1. You can expand-collapse the line, to show any 2nd level inflicting order.

For Example:

Using the scenario from previous example, both the Transfer order (Site A) and the Return order (Site A) will be deemed as inflicting orders.

Both of these Orders will appear in an expand/collapse section (in the inflicting Order column) under impacted Orders for Site B. See Figure 5.0 and Figure 6.0

JavaScript errors detected

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

If this problem persists, please contact our support.