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

    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.

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

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.

Related topics