| Purchase schedule cumulativesPurchase schedule cumulatives (CUMs) are used for these purposes: - Keep track of a schedule's total ordered and received
quantities
- Calculate overdeliveries and underdeliveries for push schedules
- Inform the supplier on the received quantity
Cumulatives In Procurement, these CUMs are supported: When a purchase schedule is released, LN inserts records in the
previously mentioned sessions in this order: - A shipped cumulative record is inserted/updated when 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 when a receipt is made in Warehousing. The
actually received quantity is inserted.
- A required cumulative record is inserted/updated when a receipt
is confirmed in Warehousing. The total required quantity for the schedule line(s) is
inserted.
- An invoiced cumulative record is inserted when 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 when the transaction
takes place. Cumulative models In the CUM Model field of the Purchase Schedule Parameters (tdpur0100m500) session, you can specify how the
communicated cumulatives are used in company. These CUM models are available: Receipt based CUM model In receipt based schedules, the supplier's position is taken
into account. 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.
Consequently, all ordered quantities are communicated to the supplier, after
which the supplier subtracts the shipped quantity from the ordered quantity.
For more information on how the supplier handles underdeliveries and
overdeliveries, refer to Adjusting sales schedules.
Example Schedule Number 10000001 Requirement
date | Position no. | Ordered Qty. | Received Qty. | Requirement type | Price |
---|
11/01 | 10 | 5 pieces | 0
pieces | Firm | 10 | 12/01 | 20 | 5 pieces | 0 pieces | Firm | 10 | 13/01 | 30 | 5 pieces | 0
pieces | Firm | 10 |
If, on 10 January, a receipt is confirmed of seven pieces
(receipt 0001, packing slip 001), this data is updated: The purchase schedule lines are selected in the sequence of
oldest unfulfilled requirement of the type Firm.
Consequently, first receipts are booked on the requirement of 11 January, then
on the requirement of 12 January , etc. 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 : although seven pieces are delivered, five
pieces can be received on this line.
- 12 January: although the ordered quantity is five pieces,
only two pieces of the actually received quantity are assigned to this line
(five pieces are assigned to the schedule line of 11 January, which is older).
This means that this line is only partially delivered.
The purchase schedule lines are updated in the Purchase Schedule Lines (tdpur3111m000) session: Requirement
date | Position no. | Ordered Qty. | Received Qty. | Requirement type | Price |
---|
11/01 | 10 | 5 pieces | 5
pieces | Firm | 10 | 12/01 | 20 | 5 pieces | 2 pieces | Firm | 10 | 13/01 | 30 | 5 pieces | 0
pieces | Firm | 10 |
The receipt details are updated in the Purchase Schedule - Receipts (tdpur3115m200) session: Position no. | Receipt no. | Packing slip no. | Received Qty. | Approved Qty | Rejected Qty |
---|
10 | RCP0001 | PS001 | 5
pieces | 0 | 0 | 20 | RCP0001 | PS001 | 2 pieces | 0 | 0 |
Planned inventory transactions are updated in Warehousing: Position no. | Receipt date | Quantity |
---|
10 | 11/01 | 0
pieces | 20 | 12/01 | 3 pieces | 30 | 13/01 | 5
pieces |
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 | 7 | 7 |
The required cumulatives are updated in the Required Cumulatives (tdpur3130m000) session: Planned
requirement date | Required quantity | Required CUM |
---|
11/01 | 5 | 5 | 12/01 | 5 | 10 |
| |