Purchase schedule cumulatives

Purchase schedule cumulatives (CUMs) are used to do the following:

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 Approvvigionamento, these CUMs are supported:

Shipped cumulatives, which can be viewed in the Quantità cumulative spedite (tdpur3131m000) session.
Received cumulatives, which can be viewed in the Quantità cumulative ricevute (tdpur3132m000) session.
Required cumulatives, which can be viewed in the Quantità cumulative richieste (tdpur3130m000) session.
Invoiced cumulatives, which can be viewed in the Quantità cumulative fatturate (tdpur3133m000) session.

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 Magazzino. The actually received quantity is inserted.
A required cumulative record is inserted/updated when a receipt is confirmed in Magazzino. The total required quantity for the schedule line(s) is inserted.
An invoiced cumulative record is inserted when an invoice is approved in Contabilità.

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.

Nota

You can reset the cumulatives in the Reimpostazione quantità cumulative (tdpur3230m000) and Reimpostazione quantità cumulative per Riga totale contratto (tdpur3230m100) sessions.

Cumulative models

In the Modello CUM field of the Parametri programma acquisti (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 Riga rilascio acquisti - Dettagli (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 Rettifica dei programmi vendite.

Nota

For push schedules, goods are usually received against a blanket warehouse order and the purchase release usually contains clustered schedule lines. Received goods are distributed across the schedule lines with the oldest unfulfilled requirement of the type immediate or firm. Per ulteriori informazioni, consultare Clustering purchase schedule lines.

Esempio

Schedule Number 10000001

Requirement date	Position no.	Ordered Qty.	Requirement type	Price
11/01	10	5 pieces	Effettivo	10
12/01	20	5 pieces	Effettivo	10
13/01	30	5 pieces	Effettivo	10

Istruzione 1. Select purchase schedule lines

The purchase schedule lines are selected in the sequence of oldest unfulfilled requirement of the type Effettivo. 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.

Istruzione 2. Update purchase schedule lines

The purchase schedule lines are updated in the Righe programma acquisti (tdpur3111m000) session.

Requirement date	Position no.	Ordered Qty.	Received Qty.	Requirement type	Price
11/01	10	5 pieces	5 pieces	Effettivo	10
12/01	20	5 pieces	2 pieces	Effettivo	10
13/01	30	5 pieces	0 pieces	Effettivo	10

Istruzione 3. Insert receipt details

The receipt details are updated in the Programma acquisti - Ricevimenti (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

Istruzione 4. Update planned inventory transactions

Planned inventory transactions are updated in Magazzino.

Position no.	Receipt date	Quantity
10	11/01	0 pieces
20	12/01	3 pieces
30	13/01	5 pieces

Istruzione 5. Update received cumulatives

The received cumulatives are updated in the Quantità cumulative ricevute (tdpur3132m000) session.

Receipt no.	Packing slip no.	Transaction date	Received quantity	Received CUM
RCP0001	PS001	10/1	7	7

Istruzione 6. Update required cumulatives

The required cumulatives are updated in the Quantità cumulative richieste (tdpur3130m000) session.

Planned requirement date	Required quantity	Required CUM
11/01	5	5
12/01	5	10

Argomenti correlati