Consolidating schedule lines 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 Delivery Lines (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.

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 happen with the unexpected creation of planned warehouse orders.

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 Delivery Lines (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 Delivery Lines (tdsls3220m000) and Consolidate Planned Delivery Lines (Pick-up Sheets) (tdsls3220m100) sessions to specify consolidations options after schedule approval.

You can specify these consolidation options: