To synchronize CUMs based on external component data

If an external component communicates schedule requirements to LN and you want the cumulatives to be synchronized and reset based on the cumulative data received from the external component, select the Synchronize Cums check box in the Schedule Terms and Conditions (tctrm1131m000) session.

Note

If the Synchronize Cums check box is cleared, cumulatives are updated based on an order based or receipt based cumulative model, as defined in the CUM Model used field of the Sales Contract Line Logistic Data (tdsls3102m000) session. For more information, refer to To synchronize CUMs based on cumulative model.

To compare and synchronize cumulative data

If you have agreed to synchronize CUMs, the external component provides the Cumulative Shipped Quantity and Last Shipment when sending a new sales release line in the Sales Release Lines (tdsls3508m000) session. When the sales release is processed into a sales schedule (revision), your shipped cumulatives are compared and synchronized with the shipped cumulatives received from the external component.

Based on the following fields, the cumulative data is compared:

  • Cumulative Shipped Quantity
  • Last Shipment
  • Schedule
Note
  • If more than one shipped cumulative record is found with the same shipment number, the shipped CUM record with the latest Transaction Date is used for comparison.
  • If no shipped cumulative record can be found for the sales release line’s Last Shipment, LN warns that the cumulatives will not be synchronized, but that you can continue processing the sales release.
To synchronize shipped cumulatives

After a shipped cumulative record is found, the following can be applicable:

  • The sales release line's Cumulative Shipped Quantity is equal to your Cumulative Shipped Quantity. Therefore, the shipped cumulative record is set to Matched in the Shipped CUM (tdsls3532m000) session. All preceding records with the Created status are updated to Matched (no feedback).
  • The sales release line's Cumulative Shipped Quantity is higher or lower than your Cumulative Shipped Quantity. Therefore, your shipped CUM is adjusted with a correction value to equal the external component's shipped CUM. This shipped cumulative record receives the Synchronize status. All preceding records with the Created status are updated to Matched.
Example
Sales Release Lines (tdsls3508m000)Shipped CUM (tdsls3532m000)
Shipped CUMScheduleShipmentShipped CUMScheduleShipmentTransaction dateStatusShipped quantityNew shipped CUM
-DJ0001-10DJ0001XXX-11 AprilMatched1010
20DJ0001YYY-215DJ0001YYY-21 MayMatched515
-DJ0001--DJ0001YYY-2Current dateSynchronize520
-DJ0001-25DJ0001ZZZ-31 JuneCreated1030
-DJ0001-50DJ0001VVV-41 JulyCreated2555

 

For the cumulative record with the Synchronize status, the following is applicable:

  • Correction value = Sales Release Lines (tdsls3508m000) session's shipped CUM – Shipped CUM (tdsls3532m000) session's shipped CUM.
  • Shipped quantity = correction value.
  • New shipped CUM = old shipped CUM + correction value.
To reset cumulatives

After a shipped cumulative record is found, the Customer CUMs Reset Date from the Sales Release Lines (tdsls3508m000) session can differ from the Cumulative Reset Date in the Shipped CUM (tdsls3532m000) session.

The following can be applicable:

  • The sales release line's Customer CUMs Reset Date is earlier than your Cumulative Reset Date. LN warns that the cumulatives will not be reset, but that you can continue processing the sales release.
  • The sales release line's Customer CUMs Reset Date is later than your Cumulative Reset Date.

    In this case, sales schedule cumulatives are reset in the following sessions:

    • Shipped CUM (tdsls3532m000)
    • Invoiced CUM (tdsls3533m000)
    • FAB/RAW Authorizations (tdsls3134m000)
    These cumulative records receive the Reset status.
Note

Based on the Transaction Date in the Shipped CUM (tdsls3532m000) session, LN determines the applicable invoiced cumulative record and authorization record.

To calculate the reset quantity

Before cumulatives can be reset, a reset quantity must be calculated.

This quantity is calculated as follows:

Cumulative Shipped Quantity from Shipped CUM (tdsls3532m000) - Cumulative Shipped Quantity from Sales Release Lines (tdsls3508m000)
Example
Sales Release Lines (tdsls3508m000)
ScheduleYYYYY1
Last ShipmentXXXXX1
Shipped CUM80
Customer Reset Date10/10/10

 

The current cumulatives are as follows:

Shipped CUM (tdsls3532m000)Invoiced CUM (tdsls3533m000)FAB/RAW Authorizations (tdsls3134m000)
ScheduleYYYYY1ScheduleYYYYY1ScheduleYYYYY1
Last ShipmentXXXXX1--FAB Authorization100
Shipped CUM100Invoiced CUM100RAW Authorization100
Customer Reset Date9/10/10Customer Reset Date9/10/10Customer Reset Date9/10/10
Transaction Date15/11/10Transaction Date15/11/10Release Date15/11/10

 

After processing the sales release, the new cumulatives are as follows:

Shipped CUM (tdsls3532m000)Invoiced CUM (tdsls3533m000)FAB/RAW Authorizations (tdsls3134m000)
ScheduleYYYYY1ScheduleYYYYY1ScheduleYYYYY1
Last Shipment-----
Shipped Quantity-20Invoiced Quantity-20FAB Authorization80
Shipped CUM80Invoiced CUM80RAW Authorization80
Customer Reset Date10/10/10Customer Reset Date10/10/10Customer Reset Date10/10/10
Transaction Date0Transaction Date0Transaction Date0
StatusResetStatusReset--

 

Note

You cannot manually reset cumulatives in the Reset Cumulatives (tdsls3230m000) session.