| 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: Transaction Date ERP LN inserts the shipped CUM that is communicated on the shipment date. Delivery Date The shipped CUM is calculated based on the delivery date. Note Use the Consider Planned/Actual Delivery Date during Reconciliation check box in the Items - 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: Reconcile Received CUMs ERP LN adjusts the Received CUM to equal the Cumulative Shipped Quantity. The reconciliation record receives the Reconciled status. Adjust Shipped CUMs ERP LN adjusts the Cumulative Shipped Quantity to equal the Received CUM. The sales schedule reconciliation record receives the Adjusted status. Adjust and Reconcile The Enter new CUMs (tdsls3131s000) session starts in which you can specify the quantity that must replace the current Received CUM and Cumulative Shipped Quantity. The sales schedule reconciliation record receives the Adjusted and Reconciled status. Note 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. Related topics To reconcile sales schedules Sales schedule cumulatives
Fields | Description
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 ERP 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 View menu, you can sort your data by: Transaction Date As a result, ERP LN shows the cumulative values based on the shipment date. Delivery Date As a result, ERP 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, ERP 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 | The date and time at which a schedule's cumulatives/ authorizations are reset.
Schedule | The number of the sales schedule.
Item | In ERP LN, the raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, sold, and so on. An item can also represent a set of items handled as one (kit), or exist in multiple product variants (generic item). You can also define nonphysical items, which are not held in inventory but can be used to post costs or to invoice services to customers. Examples of nonphysical items: Cost items (for example, electricity) Service items Subcontracting services List items (menus/options)
Sales Unit | The unit in which the item is expressed.
Reconcile Status | The status of the sales schedule reconciliation record. Allowed values Reconcile status
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.