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
    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 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:

  • Reconcile Received CUMs
    LN adjusts the Received CUM to equal the Cumulative Shipped Quantity. The reconciliation record receives the Reconciled status.
  • Adjust Shipped CUMs
    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.

 

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 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 dateShipmentQuantityShipped CUMDelivery dateStatus
27-9/13:00SHIP1101028-9/9:00Created
27-9/15:00SHIP2102028-9/11:00Created
27-9/17:00SHIP3103028-9/13:00Created

 

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 dateShipmentQuantityShipped CUMDelivery dateStatus
27-9/15:00SHIP2102028-9/8:00Dispute
27-9/13:00SHIP1101028-9/9:00Created
27-9/17:00SHIP3103028-9/13:00Created

 

The following occurs if the Consider Planned/Actual Delivery Date during Reconciliation check box is selected:

Shipment dateShipmentQuantityShipped CUMDelivery dateStatus
27-9/15:00SHIP2101028-9/8:00Matched
27-9/13:00SHIP1101028-9/9:00Matched (no feedback)
27-9/17:00SHIP3103028-9/13:00Created

 

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 View 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 dateShipmentQuantityShipped CUMDelivery dateStatus
27-9/15:00SHIP2102028-9/8:00Matched
27-9/13:00SHIP1101028-9/9:00Matched (no feedback)
27-9/17:00SHIP3103028-9/13:00Created

 

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

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.