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 View menu, you can sort your data by:
Note Use the Consider Planned/Actual Delivery Date during Reconciliation check box in the Item - Sales Business Partner (tdisa0510m000) session to define how the shipped CUM is retrieved. You can sort schedule discrepancies by Planner, Item, and Transaction Date. To make a selection on these data, click the Set Filter 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 Undo Filter button. As a result, all records are displayed again. Note You can print sales schedule reconciliation records for a specific selection in the Print Shipped CUM (tdsls3432m000) session. From the Specific menu of the current session you can handle sales schedule reconciliation records with the Dispute status. If you choose:
Note
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:
Shipment ID The shipment with which the items are shipped. Last Receipt Quantity The last quantity that your business partner received for the sales schedule. Shipped CUM 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 Item - Sales Business Partner (tdisa0510m000) session determines how the shipped CUM is calculated. Example
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:
The following occurs if the Consider Planned/Actual Delivery Date during Reconciliation check box is selected:
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
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:
Cumulative Reset Date The date and time at which a schedule's cumulatives/ authorizations are reset. Schedule The number of the sales schedule. Item Unit The unit in which the item is expressed. Reconcile Status The status of the sales schedule reconciliation record. Allowed values 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.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||