Resetting purchase schedule cumulatives

Over time, a purchase schedule's cumulatives (CUMS) can be incremented to very high values. To decrease these values, you can reset the CUMs in the Reset Cumulatives (tdpur3230m000) and Reset Cumulatives by Contract Total Line (tdpur3230m100) sessions. Although this reset is usually performed at the end of the year, the CUMs cannot be reset exactly when the year is changing. This means that 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.

Resetting is carried out based on the following cumulative (CUM) models, which you can define in the Model for CUMs field of the Purchase Contract Parameters (tdpur0100m300):

  • Order based CUM model
  • Receipt based CUM model
Conditions for successfully resetting the cumulatives:
  • Suppliers and customers must use the same CUM reset date when resetting the cumulatives in the Reset Cumulatives (tdpur3230m000), Reset Cumulatives by Contract Total Line (tdpur3230m100), and Reset Cumulatives (tdsls3230m000) sessions.
  • 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. Purchase release lines with the Created, or Scheduled status are automatically reset.
  • Suppliers must not update incoming releases or manually create new releases, because resetting can then result in wrong quantities.
To calculate the reset quantity

To reset the existing CUM values, the reset quantity is determined and subtracted from the existing CUMs. In the Shipped Cumulatives (tdpur3131m000), Received Cumulatives (tdpur3132m000), Required Cumulatives (tdpur3130m000), and the Invoiced Cumulatives (tdpur3133m000) sessions, a reset record is added and the CUMs are reduced by the reset quantity. Furthermore, the FAB/RAW Authorizations (tdpur3534m000) session is reset and the release lines that are generated, but not yet sent, are reset.

Based on the CUM model, the reset quantity is calculated as follows:

  • Order Based CUM model
    Reset Quantity = last required quantity that is communicated on a release date that is prior to the new reset date. This quantity is retrieved from the Required CUM field of the FAB/RAW Authorizations (tdpur3534m000) session.
  • Receipt Based CUM model
    Reset Quantity = last received quantity that is communicated on a release date that is prior to the new reset date. This quantity is retrieved from the Received CUM field of the FAB/RAW Authorizations (tdpur3534m000) session.
Example 1 - Order Based CUM model
  • Reset date = start week 3
  • The schedule lines are generated before the reset takes place
  • Schedule line 2 is released in week 3
  • Schedule line 3 is released in week 5
WeekLine 1Required CUM before resetLine 2Required CUM before resetLine 3Required CUM before resetRequired 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 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 - Receipt Based CUM model

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

WeekReceived quantityReceived 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