Reconciling sales schedules

To insert reconciliation records

When you confirm a shipment for a sales schedule, LN creates a sales schedule reconciliation record in the Sales Schedule Reconciliation (tdsls3131m000) session with the following information:

• The date on which the items are shipped.
• The number of the shipment with which the goods are shipped.
• The quantity that you shipped with that specific shipment.
• The last quantity that is received for the sales schedule.
• The total cumulated quantity that you already shipped for the sales schedule.

For each shipment, one reconciliation record is created with the Created status.

When you approve a sales schedule, LN:

1. Inserts the number of the last shipment that your business partner received for the sales schedule in the Sales Schedule Reconciliation (tdsls3131m000) session.
2. Inserts the last quantity that your business partner received for the sales schedule in the Sales Schedule Reconciliation (tdsls3131m000) session.
3. Calculates the new Received CUM by adding the Last Receipt Quantity to the Received CUM of the concerned and next reconciliation records.
4. Compares the business partner's Received CUM with your Cumulative Shipped Quantity. If these CUMs are equal, the reconciliation record receives the Matched status. If these CUMs are unequal, the reconciliation record receives the Dispute status.

Reconciliation statuses

A reconciliation record can have the following statuses:

• Created

  The sales schedule reconciliation record is created and you have not yet received your business partner's received CUM and last receipt quantity for the concerned shipment.

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

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

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

To solve disputes

You can use the Sales Schedule Reconciliation (tdsls3131m000) session to solve disputes between your shipped cumulatives and your sold-to business partner's received cumulatives for a specific sales schedule. Only if a reconciliation record has the Dispute status, you can adjust the record.

To handle sales schedule reconciliation records with the Dispute status, select one of the following on the appropriate menu of the Sales Schedule Reconciliation (tdsls3131m000) session:

• Reconcile Received CUMs

  LN adjusts the Received CUM to equal the Cumulative Shipped Quantity. The reconciliation record gets the Reconciled status.

• Adjust Shipped CUMs

  LN adjusts the Cumulative Shipped Quantity to equal the Received CUM. The sales schedule reconciliation record gets 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 gets the Adjusted and Reconciled status.

When the dispute is solved:

• All previous records with the Dispute status receive the Matched (forced) status. Previous records with the Created status receive the Matched (no feedback) status.
• LN adjusts the Cumulative Shipped Quantity of the following records according to the adjustment. The Received CUM of successive records is not updated.
• For records with the Adjusted or Adjusted and Reconciled status, LN redetermines the status of the following records based on the new Cumulative Shipped Quantity. If, after adjustment, the Cumulative Shipped Quantity of a record with the Dispute status turns out to be correct, the sales schedule reconciliation record's status changes from Dispute into Matched (forced).
• And you have chosen to adjust the received CUM, your sold-to business partner must also adjust the received CUM. For invoiced purchase schedule lines, the received CUM can be updated in the Update Received CUMs (tdpur3432m000) session. If the received CUM is not updated on the purchase side as well, each time the purchase schedule is sent, it will cause a dispute.
• The shipped CUM records in the Shipped CUM (tdsls3532m000) session are updated according to the adjustments you made in the Sales Schedule Reconciliation (tdsls3131m000) session.

Loss of inventory

If as a result of the discussion with your business partner on a reconciliation record with the Dispute status is decided to adjust the Cumulative Shipped Quantity, you can also agree with your business partner on who will pay for the loss of inventory.

The following possibilities exist:

• You pay for the loss of inventory. In this case, you must create a Correction record in the Sales Schedule Invoice Lines (tdsls3140m200) session. This will result in a credit invoice to your business partner.
• Your business partner pays for the loss of inventory. In this case, you must not create a Correction record in the Sales Schedule Invoice Lines (tdsls3140m200) session.

For more information on shipment corrections and sales schedule invoices, refer to Sales schedules and Invoicing.