To synchronize CUMs based on cumulative model

If both customers and suppliers use LN to communicate schedule requirements, cumulatives are synchronized based on an order based or receipt based cumulative model, which you can define in the CUM Model used field of the Items - Sales Business Partner (tdisa0510m000) and/or the Sales Contract Line Logistic Data (tdsls3102m000) session.

For more information on how to use these models, refer to Adjusting sales schedules.

Note

If the sales schedule is based on a sales contract with a linked terms and conditions agreement and if, in the Schedule Terms and Conditions (tctrm1131m000) session, the Synchronize Cums check box is selected, cumulatives are synchronized and reset based on the cumulative data received from the external component. For more information, refer to To synchronize CUMs based on external component data.

To reset cumulatives

Over time, the cumulatives can be incremented to very high values. To reduce these values, you can reset the cumulatives in the Reset Cumulatives (tdsls3230m000) session. Although this reset is usually performed at the end of the year, the CUMs cannot be reset exactly when the year is changing. As a result, updates can be stored in the cumulative sessions after the reset date. By calculating a reset quantity, these values are also included in the reset process.

To reset the cumulatives successfully, the following conditions must be fulfilled:

  • Suppliers and customers must use the same CUM reset date when resetting the cumulatives in the Reset Cumulatives (tdsls3230m000) session and the Reset Cumulatives (tdpur3230m000) session.
  • Resetting can only take place when the releases sent by the customer, are received and approved by the supplier. If not, suppliers cannot approve releases that are processed after the reset date, because the reset dates are different.
  • Suppliers must not update incoming releases or manually create new releases, because resetting can then result in wrong quantities.
Note
  • You cannot reset the sales schedule cumulatives for the sales schedule if a reconciliation record exists with the Dispute status and a Transaction Date before the CUM reset date. You can view sales schedule reconciliation records in the Sales Schedule Reconciliation (tdsls3131m000) session.
  • The cumulatives as stored in the Sales Schedules (tdsls3111m000) session for a specific sales schedule revision, are never updated during the reset process. They are kept as history information.
To calculate the reset quantity
Step 1. To determine a reset quantity

If you reset cumulatives in the Reset Cumulatives (tdsls3230m000) session, LN first determines the reset quantity. LN retrieves the reset quantity from the last CUM record prior to the CUM Reset Date that you specified in the Reset Cumulatives (tdsls3230m000) session. Which quantity is the reset quantity depends on the CUM Model used.

If the CUM Model used is:

  • Order Based, the Prior Required CUM is the reset quantity.
  • Receipt Based, the Received CUM is the reset quantity.
Step 2. To create new cumulative records

LN creates a new:

  • Shipped CUM record in the Shipped CUM (tdsls3532m000) session.
  • Invoiced CUM record in the Invoiced CUM (tdsls3533m000) session.

For the new CUM records, the following applies:

  • The Cumulative Reset Date is equal to the CUM Reset Date that you specified in the Reset Cumulatives (tdsls3230m000) session.
  • The Status is Reset.
To reset the shipped CUM

For a new shipped CUM record, LN decreases the following quantities with the reset quantity:

  • Cumulative Shipped Quantity.
  • Received CUM.

If already shipped CUM records exist with transaction dates later than the Cumulative Reset Date, LN copies these records with the following adjustments:

  • The Cumulative Shipped Quantity and Received CUM are also decreased with the reset quantity.
  • The old Cumulative Reset Date is replaced with the new Cumulative Reset Date.
To reset the invoiced CUM

In case of a new invoiced CUM record, LN decreases the Cumulative Invoiced Quantity with the reset quantity.

If already invoiced CUM records exist with invoice dates later than the Cumulative Reset Date, LN copies these records with the following adjustments:

  • The Cumulative Invoiced Quantity is also decreased with the reset quantity.
  • The old Cumulative Reset Date is replaced with the new Cumulative Reset Date.
Example 1 - To reset the cumulatives for an Order Based CUM model
  • Reset date = start week 3
  • The schedule lines are generated before the reset takes place
  • Schedule line 2 is received in week 3
  • Schedule line 3 is received in week 5
WeekLine 1Prior required CUM before resetLine 2Prior required CUM before resetLine 3Prior required CUM before resetPrior required CUM after reset
12020-20-2020
22040-40-4040
32060545-455
42080550-5010
520100555207030
6201205511057535
7--511558040
8--512058545
9----59050
10----59555

 

TOTALSCUM line 1CUM line 2CUM line 3CUMs after reset
Start CUM0405010

 

The reset date starts in week 3. Because of the Order Based CUM model, resetting is carried out based on the prior required cumulatives. At the end of week 2, the reset quantity is 40. As a result, all CUMs are updated by -40 from the CUM reset date (week 3) on.

Example 2 - To reset the cumulatives for a Receipt Based CUM model

Take the same data from the previous example, but also take into consideration the following data:

WeekReceived qty.Received CUM before resetReceived CUM after reset
1101010
2253535
3205520
4-5520
556025

 

The reset date starts in week 3. Because of the Receipt Based CUM model, resetting is done based on the received cumulatives. At the end of week 2, the reset quantity is 35. As a result, all CUMs are updated by -35 from the CUM reset date (week 3) on.

The totals from example 1 would then arrive at:

TOTALSCUM line 1CUM line 2CUM line 3CUMs after reset
Start CUM0405015