Invoiced Cumulatives (tdpur3133m000)

Use this session to view a purchase schedule's invoiced cumulatives (CUMs).

When an invoice is approved in ERP Financials, LN searches in the current session for an existing record for a combination of schedule number, CUM reset date, and invoice date. If found, LN updates the applicable record and the Invoiced CUM field for the successive records, if present. If the combination is not found, LN creates a new record in this session and updates the Invoiced CUM field for the successive records, if present.

The moment the status of a purchase schedule line becomes Final Receipt, a signal is sent to Accounts Payable (ACP) that all goods are received on the purchase schedule line. As soon as the invoice is approved in ERP Financials, invoice details are sent back to Purchase Control (PUR) to update the Purchase Schedule Lines (tdpur3111m000) session and to create turnover history for the schedule line.

When the cumulatives are reset in the Reset Cumulatives (tdpur3230m000) session, LN adds a reset record in the current session. The reset record's fields have the following values:

  • CUM (Reset) Date: the CUM reset date as entered in the Reset Cumulatives (tdpur3230m000) session.
  • Transaction Date: the reset record always has a transaction date of zero.
  • Invoiced Quantity: -1 * reset quantity.
  • Invoiced CUM: cumulative invoiced quantity of the last record that falls before the CUM reset date - reset quantity.
Note: The cumulative quantities of records with a transaction date that falls after the CUM reset date are decreased by the reset quantity. For more information on resetting the cumulatives, refer to Resetting purchase schedule cumulatives.

Example

  • Reset date: 14-02
  • Reset quantity: 23
Transaction date 01-02 05-02 06-02 0 01-03 04-03
Invoiced quantity 10 8 6 -23 12 8
Invoiced CUM 10 18 24 1 13 21

Field Information

Schedule

The number of the purchase schedule.

CUM (Reset) Date

CUM reset date

Note: You can reset the cumulatives in the Reset Cumulatives (tdpur3230m000) session.
Transaction Date

The date on which an invoice is approved in ERP Financials.

Invoiced CUM

The invoiced CUM expressed in the inventory unit.

Sequence Number

A number that is increased as soon as a new record is added to the current session with a transaction date/time that is equal to the transaction date/time of an already existing record.

Inventory Unit

inventory unit

Invoiced Quantity

The invoiced quantity expressed in the inventory unit.