To synchronize CUMs based on cumulative modelIf 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:
Note
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:
Step 2. To create new cumulative records LN creates a new:
For the new CUM records, the following applies:
To reset the shipped CUM For a new shipped CUM record, LN decreases the following quantities with the reset quantity:
If already shipped CUM records exist with transaction dates later than the Cumulative Reset Date, LN copies these records with the following adjustments:
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:
Example 1 - To reset the cumulatives for an Order Based CUM model
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:
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:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||