Sales Schedule Reconciliation (tdsls3131m000)
Use this session to reconcile sales schedules. The purpose of this session is to solve disputes between your shipped cumulatives and your customer's received cumulatives for a specific sales schedule.
On the
menu, you can sort your data by:-
Transaction Date
LN inserts the shipped CUM that is communicated on the shipment date. -
Delivery Date
The shipped CUM is calculated based on the delivery date.
You can sort schedule discrepancies by Planner, Item, and Transaction Date. To make a selection on these data, click the button in the current session. As a result, the Selection Criteria (tdsls3131s100) session starts in which you can make your selection. After you entered your selection criteria in the Selection Criteria (tdsls3131s100) session and click OK, the Sales Schedule Reconciliation (tdsls3131m000) session only displays the schedule reconciliation records for the given selection. To remove the filter, click the button. As a result, all records are displayed again.
From the Specific menu of the current session you can handle sales schedule reconciliation records with the Dispute status. If you choose:
- If you choose to adjust the received CUM, your sold-to business partner must also adjust the received CUM in the Update Received CUMs (tdpur3432m000) session.
- If you sorted your data by delivery date and you choose to adjust or reconcile a record, other records are still changed based on the order in which records are shown in the transaction date view. As a result, adjusting or reconciling in the delivery date view can give unexpected results.
Field Information
- Planner
-
The planner who is responsible for the sales schedule.
Default value
This field is defaulted from the Planner field of the Sales Schedules (tdsls3111m000) session.
Note: The planner who is attached to the sales schedule's latest revision number is the owner of the schedule. - Transaction Date
-
The date on which the items are shipped.
- Delivery Date
-
This field is filled with one of the following dates:
- The calculated receipt date when the shipment is confirmed.
- The actual receipt date when the shipment is received by the sold-to business partner.
- Shipment
-
The shipment with which the items are shipped.
- Last Receipt Quantity
-
The last quantity that your business partner received for the sales schedule.
- Cumulative Shipped Quantity
-
The total cumulated quantity that you already shipped for the sales schedule.
The setting of the Consider Planned/Actual Delivery Date during Reconciliation check box in the Items - Sales Business Partner (tdisa0510m000) session determines how the shipped CUM is calculated.
Example
Shipment date Shipment Quantity Shipped CUM Delivery date Status 27-9/13:00 SHIP1 10 10 28-9/9:00 Created 27-9/15:00 SHIP2 10 20 28-9/11:00 Created 27-9/17:00 SHIP3 10 30 28-9/13:00 Created Shipment 2 arrives at 8:00 at the warehouse, before shipment 1. The following occurs if the Consider Planned/Actual Delivery Date during Reconciliation check box is cleared:
Shipment date Shipment Quantity Shipped CUM Delivery date Status 27-9/15:00 SHIP2 10 20 28-9/8:00 Dispute 27-9/13:00 SHIP1 10 10 28-9/9:00 Created 27-9/17:00 SHIP3 10 30 28-9/13:00 Created The following occurs if the Consider Planned/Actual Delivery Date during Reconciliation check box is selected:
Shipment date Shipment Quantity Shipped CUM Delivery date Status 27-9/15:00 SHIP2 10 10 28-9/8:00 Matched 27-9/13:00 SHIP1 10 10 28-9/9:00 Matched (no feedback) 27-9/17:00 SHIP3 10 30 28-9/13:00 Created Because the calculation of the shipped CUM is as follows, the out of sequence receipt does not cause a dispute:
The total shipped quantity for the sales schedule (30) - the quantities that are shipped, but that are not received yet (-10, -10).
Note:- LN still generates disputes for shipments that are delayed till after the next shipment's delivery date. For example, if shipment 1 is delayed for more than one hour and shipment 2 is received as planned, a dispute is generated.
-
On the
menu, you can sort your data by:-
Transaction Date
As a result, LN shows the cumulative values based on the shipment date. -
Delivery Date
As a result, LN shows the cumulative values based on the delivery date.
-
If the Consider Planned/Actual Delivery Date during Reconciliation check box is selected, but you sorted your data by Transaction Date, LN shows the cumulative values based on the transaction date, but calculates the values based on the delivery date. This will give the following results:
Shipment date Shipment Quantity Shipped CUM Delivery date Status 27-9/15:00 SHIP2 10 20 28-9/8:00 Matched 27-9/13:00 SHIP1 10 10 28-9/9:00 Matched (no feedback) 27-9/17:00 SHIP3 10 30 28-9/13:00 Created - Cumulative Reset Date
-
CUM reset date
- Schedule
-
The number of the sales schedule.
- Item
- Sales Unit
-
The unit in which the item is expressed.
- Reconcile Status
-
The status of the sales schedule reconciliation record.
Allowed values
- Created
-
- The sales schedule reconciliation record or shipped cumulative record is created and you have not yet received your business partner's received CUM and last receipt quantity for the concerned shipment.
- The shipped cumulative record is created and you have not yet received an external component's shipped CUM for the concerned shipment.
- The invoiced cumulative record is created.
- Matched
-
- You received your business partner's received CUM and last receipt quantity for the concerned shipment and these quantities are equal to your shipped CUM and shipped quantity.
- The shipped CUM and CUM reset date that you received from an external component are equal to your shipped CUM and CUM reset date.
- If a shipped cumulative record has the Synchronize status, the previous record is set to Matched.
- Dispute
-
You received your business partner's received CUM and last receipt quantity for the concerned shipment and these quantities are unequal to your shipped CUM and shipped quantity.
- Reconciled
-
You discussed the difference between your business partner's received CUM and your shipped CUM, and as a result you have adjusted the received CUM to equal the shipped CUM.
- Adjusted
-
You discussed the difference between your business partner's received CUM and your shipped CUM, and as a result you have adjusted the shipped CUM to equal the received CUM.
- Reset
-
- The sales schedule cumulative record or the sales schedule authorization record are reset in the Reset Cumulatives (tdsls3230m000) session.
- The CUM reset date that you received from an external component is later than your CUM reset date, and as a result the sales schedule cumulative record or sales schedule authorization record are reset.
- Adjusted and Reconciled
-
You discussed the difference between your business partner's received CUM and your shipped CUM, and as a result you have adjusted the shipped CUM and the received CUM.
- Matched (forced)
-
- The received CUM and last receipt quantity that you received from your business partner for the concerned shipment are unequal to your shipped CUM and shipped quantity, but a later entry has already received the status Matched.
- If a sales schedule reconciliation record has the status Dispute, and its shipped CUM is updated as a result of adjusting previous records with the Dispute status, the current record is set to Matched (forced) if, after correction, quantities match.
- Matched (no feedback)
-
- You have not yet received your business partner's received CUM and last receipt quantity for the concerned shipment, but a later entry has already received the status Matched or Reconciled. The received CUM and last receipt quantity remain zero.
- You have not yet received an external component's shipped CUM for the concerned shipment, but a later entry has already received the status Matched.
- Synchronize
-
The shipped CUM that you received from an external component is unequal to your shipped CUM , and as a result your shipped CUM is adjusted with a correction value to equal the external component's shipped CUM.
- Received CUM
-
The total cumulated quantity that your business partner already received for the sales schedule.
- Shipped Quantity
-
The quantity of items that is shipped.