| Purchase schedule cumulatives |  |
| If you use purchase schedules, cumulatives (CUMs) are used to: Keep track of a schedule's total ordered quantity. Keep track of a schedule's total received quantity. Calculate overdeliveries and underdeliveries for push schedules. Inform the supplier on the received quantity. Cumulatives In Purchase Control, the following CUMs are supported: Shipped cumulatives, which can be viewed in the Shipped Cumulatives (tdpur3131m000) session. Received cumulatives, which can be viewed in the Received Cumulatives (tdpur3132m000) session. Required cumulatives, which can be viewed in the Required Cumulatives (tdpur3130m000) session. Invoiced cumulatives, which can be viewed in the Invoiced Cumulatives (tdpur3133m000) session. If a purchase schedule is released, ERP LN inserts records in the previously mentioned sessions in the following order: A shipped cumulative record is inserted/updated as soon as an advance shipment notice is received from the supplier. The shipped quantity communicated by the supplier is inserted. A received cumulative record is inserted/updated as soon as a receipt is made in Warehousing. The actually received quantity is inserted. A required cumulative record is inserted/updated as soon as a receipt is confirmed in Warehousing. The total required quantity for the schedule line(s) is inserted. An invoiced cumulative record is inserted as soon as an invoice is approved in Financials. In general, cumulatives are calculated and updated based on schedule number, CUM reset date, and transaction date, which can be the shipment date, receipt date, planned requirement date, or invoice date. The schedule number and the transaction date are determined at the moment the transaction takes place. Note You can reset the cumulatives in the Reset Cumulatives (tdpur3230m000) session. Cumulative models Two cumulative models exist based on which the communicated cumulatives are used in a logistic company. In the Model for CUMs field of the Purchase Contract Parameters (tdpur0100m300) session, you can select one of the following models: Receipt based CUM model In receipt based schedules, the supplier's position is taken into account. As a result, in case of an underdelivery, schedule lines with a planned requirement date that falls before the next schedule issue date are inserted as immediate requirements in the Purchase Release Line - Details (tdpur3522m000) session. Furthermore, the total received CUM is communicated to the supplier. Order based CUM model Order based schedules are independent of the supplier's position. In case of an overdelivery or underdelivery, suppliers are responsible for calculating their position in relation to the demand. As a result, all ordered quantities are communicated to the supplier, after which the supplier subtracts the shipped quantity from the ordered quantity. To have more information on how the supplier handles underdeliveries and overdeliveries, refer to Sales schedule adjustment. Note For push schedules, goods are usually received against a blanket warehouse order and the purchase release usually contains clustered schedule lines. In case of a receipt of goods, the goods are distributed over the schedule lines with the oldest unfulfilled requirement of the type Immediate or Firm. For more information, refer to To cluster purchase schedule lines. Example Schedule Number 10000001
Requirement date | Position no. | Ordered Qty. | Delivered Qty. | Requirement type | Price
--- | --- | --- | --- | --- | ---
11/01/2001 | 10 | 5 pieces | 0 pieces | firm | 10
12/01/2001 | 20 | 5 pieces | 0 pieces | firm | 10
13/01/2001 | 30 | 5 pieces | 0 pieces | firm | 10
Step 1. Select purchase schedule lines The purchase schedule lines are selected in the sequence of oldest unfulfilled requirement of the type Firm. This means that first receipts are booked on the requirement of 11 January 2001, then on the requirement of 12 January 2001, and so on. Receipts can be booked on schedule lines for a maximum of the ordered quantity. In our example, a receipt of seven pieces is booked as follows: 11 January 2001: although seven pieces are delivered, five pieces can be received on this line. 12 January 2001: although the ordered quantity is five pieces, only two pieces of the actually delivered quantity are assigned to this line (five pieces are assigned to the schedule line of 11 January 2001, which is older). This means that this line is only partially delivered. Step 2. Update purchase schedule lines The purchase schedule lines are updated in the Purchase Schedule - Lines (tdpur3111m000) session.
Requirement date | Position no. | Ordered Qty. | Delivered Qty. | Requirement type | Price
--- | --- | --- | --- | --- | ---
11/01/2001 | 10 | 5 pieces | 5 pieces | firm | 10
12/01/2001 | 20 | 5 pieces | 2 pieces | firm | 10
13/01/2001 | 30 | 5 pieces | 0 pieces | firm | 10
Step 3. Insert receipt details The receipt details are updated in the Purchase Schedule - Receipts (tdpur3115m200) session.
Position no. | Receipt no. | Packing slip no. | Delivered Qty. | Approved Qty | Rejected Qty
--- | --- | --- | --- | --- | ---
10 | RCP0001 | PS001 | 5 pieces | 0 | 0
20 | RCP0001 | PS001 | 2 pieces | 0 | 0
Step 4. Update planned inventory transactions Planned inventory transactions are updated in Warehousing.
Position no. | Delivery date | Quantity
--- | --- | ---
10 | 11/01/2001 | 0 pieces
20 | 12/01/2001 | 3 pieces
30 | 13/01/2001 | 5 pieces
Step 5. Update received cumulatives The received cumulatives are updated in the Received Cumulatives (tdpur3132m000) session.
Receipt no. | Packing slip no. | Transaction date | Received quantity | Received CUM
--- | --- | --- | --- | ---
RCP0001 | PS001 | 10/1/2001 | 7 | 7
Step 6. Update required cumulatives The required cumulatives are updated in the Required Cumulatives (tdpur3130m000) session.
Planned requirement date | Required quantity | Required CUM
--- | --- | ---
11/01/2001 | 5 | 5
12/01/2001 | 5 | 10
Related topics To reset purchase schedule cumulatives Purchase schedule receipts Blanket warehousing orders To reset purchase schedule cumulatives Planned inventory transactions |