Shipped Cumulatives (tdpur3131m000)
Use this session to view a purchase schedule's shipped cumulatives (CUMs).
If an advance shipment notice is received, in the current session, LN searches for an existing record for a combination of schedule number, CUM reset date, ASN number, and transaction date. If found, LN updates the applicable record and the Shipped CUM field for the successive records. If the combination is not found, LN creates a new record in this session and updates the Shipped CUM field for the successive records.
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 these 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.
- Shipped Quantity: -1 * reset quantity.
- Shipped CUM: cumulative shipped quantity of the last record before the CUM reset date - reset quantity.
Example
- Reset date: 14-02
- Reset quantity: 23
Transaction date | 01-02 | 05-02 | 06-02 | 0 | 01-03 | 04-03 |
Shipped quantity | 10 | 8 | 6 | -23 | 12 | 8 |
Shipped 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. - 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.
- Transaction Date
-
The transaction date that is used to update the shipped CUM.
These transaction dates are used:
-
Shipment date
If an ASN is created in Warehousing for the goods to be received - If the scheduled goods are received based on an ASN
-
Receipt date
If scheduled goods are received without an ASN
Default value
- The shipment date of the ASN is retrieved from the Shipping Date field in the Shipment Notices (whinh3100m000) session.
- The receipt date is retrieved from the Receipt Date field in the Receipt Lines (whinh3112s000) session.
-
- Shipped Quantity
-
The shipped quantity expressed in the inventory unit.
Default value
The shipped quantity is retrieved from the Shipment Notice Lines (whinh3101m000) session.
Note: If the shipped CUM is updated for a receipt without an ASN, the Received Quantity from the Receipt Lines (whinh3112s000) session is displayed in this field. - Inventory Unit
- Shipped CUM
-
The shipped CUM expressed in the inventory unit.
- Last Supplier's ASN
-
The last advance shipment notice number received from the supplier.
- Shipment
-
The advance shipment notice 's number, which is retrieved from the Shipment field in the Shipment Notices (whinh3100m000) session.
- Shipment sequence
-
The sequence number of the ASN line, which is retrieved from the Sequence field in the Shipment Notice Lines (whinh3101m000) session.