| # Consolidating schedule lines on planned warehouse orders If planned warehouse orders are used, you can consolidate sales schedule lines by quantity and/or by date. Consolidation by quantity means that multiple schedule lines are combined into one planned warehouse order. The planned warehouse order's ordered quantity is a grouped quantity and the same planned warehouse order is linked to various schedule lines. Consolidation by date means that shipments for scheduled items are consolidated into pre-defined delivery moments on planned warehouse orders. Master data In the Sales Contract Line Logistic Data (tdsls3102m000) session, these consolidation fields must be specified: Delivery Pattern If this field is specified, LN automatically consolidates sales schedule lines by quantity and/or by date. Allow Consolidation of References Determines whether or not referenced schedule lines can be consolidated by quantity for the same Shipment Reference. Ignore Additional Information during Consolidation Determines whether or not schedule lines with different contents in their additional information fields can be consolidated. Consolidating requirements by quantity Consolidation by quantity enables you to combine multiple schedule lines of a specific sales schedule into one planned warehouse order. In the Sales Schedule Planned Warehouse Orders (tdsls3520m000) session, schedule lines are combined in the same planned warehouse order if the sales schedule line fields are the same, except for these fields, which can differ: Dates Quantities Reference Customer Schedule Number Packaging Reference A Packaging Reference B Additional Field, provided the Ignore Additional Information during Consolidation check box is selected If schedule lines differ in, for example, price information or sales unit, they cannot be consolidated. In this case, multiple planned warehouse orders can be created for the same shipment reference. Note Referenced schedule lines can be consolidated into one planned warehouse order only if they have the same shipment reference. If the Schedule Line Text check box is selected for a sales schedule line, this schedule line can never be consolidated by quantity. These are applicable for consolidation by quantity: Information from the first schedule line linked to the planned warehouse order is taken as the basis for consolidation. This means that information from other schedule lines can be lost. If consolidation results change over time because of new information on incoming schedule revisions, unexpected underdelivery or overdelivery situations can arise with unexpected planned warehouse order creation. Example For schedule SCH0001, the first revision contains the following data:
Schedule line | Ordered Quantity | Delivery Point
--- | --- | ---
10 | 15 | 001
20 | 35 | 001
Schedule lines 10 and 20 are consolidated into one planned warehouse order (SCH0001) with an ordered quantity of 50. The second schedule revision contains the following data:
Schedule line | Ordered Quantity | Delivery Point
--- | --- | ---
10 | 17 | 001
20 | 37 | 002
Because of the changed delivery point, these schedule lines can no longer be consolidated by quantity into one planned warehouse order. Dependent on the (planned) warehouse order's status, the following are applicable: Update allowed The quantity of the existing planned warehouse order for delivery point 001 is reduced and set to 17. The quantity of the first planned warehouse order link is reduced and its revision is updated and the second planned warehouse order link is deleted. A second planned warehouse order and a link is created for the second schedule line. Update not allowed The first planned warehouse order for delivery point 001 is processed in Warehousing. The quantity of the first new schedule line for delivery point 001 is ignored; only the revision on the planned warehouse order link is updated. For the second schedule line, a new planned warehouse order and planned warehouse order link are created. The end result is an overdelivery. Note LN always gives a warning message if new schedule revisions or updates lead to unexpected (over)deliveries. This enables you to manually intervene in the shipment process, if desired. Consolidating requirements by date Consolidation by date enables you to change the delivery moments for scheduled items into fixed delivery moments on planned warehouse orders. During sales schedule approval, the following dates in the Sales Schedule Planned Warehouse Orders (tdsls3520m000) session can be changed into one of the delivery moments defined in the pattern: Shipment Based Requirement Start Date Receipt Based Planned Receipt Date As a result, planned warehouse orders have dates that are in accordance with the desired delivery moments as specified in the Delivery Pattern field of the Sales Contract Line Logistic Data (tdsls3102m000) session. Manual consolidation options Although automatic consolidation of schedule lines drastically reduces the number of planned warehouse orders, you may still consider the number of planned warehouse orders too high. To further reduce or to control the number of planned warehouse orders, you can manually specify consolidation options during or after schedule approval. For existing or new planned warehouse orders, you can consolidate schedule line requirements for a specific requirement start date, including past requirements, into one planned warehouse order. You can use the Approve Sales Schedules (tdsls3211m000) and Approve Pick-up Sheets (tdsls3211m200) sessions to specify consolidations options during approval. You can use the Consolidate Planned Warehouse Orders (tdsls3220m000) and Consolidate Planned Warehouse Orders (Pick-up Sheets) (tdsls3220m100) sessions to specify consolidations options after schedule approval. You can specify these consolidation options:
Ignore Delivery Pattern | -
Move Past Requirements | New Requirement Start Date
Move Nonpattern Requirements | New Requirement Start Date
Combine Planned Warehouse Orders | New Requirement Start Date
Original Requirement Start Date From | Original Requirement Start Date To
Example Delivery pattern: ship on Wednesday 7 November, 11.00 am Today: 1 November
Schedule line | Quantity | Start date | Requirement
--- | --- | --- | ---
1 | 3 | Wednesday 31 October, 7.00 am | past
2 | 5 | Monday 5 November, 7.00 am | nonpattern
3 | 2 | Wednesday 7 November, 11.00 am | pattern
Depending on your settings, one planned warehouse order can be created with a quantity of 10 for, for example, Monday 5 November, 11.00 am. Related topics Planned warehouse orders |