Reconciling sales schedules

Material releases and shipping schedules with non-referenced items can be reconciled, which means that your business partner's Received CUM is matched with your Cumulative Shipped Quantity. If the cumulatives (CUMs) do not match, disputes are generated that you must resolve.

Important!
  • In the Item - Sales Business Partner (tdisa0510m000) or Sales Contract Line Logistic Data (tdsls3102m000) session, the Consider Planned/Actual Delivery Date during Reconciliation check box determines how the Shipped CUM is calculated in the Sales Schedule Reconciliation (tdsls3131m000) and Shipped CUM (tdsls3532m000) sessions.

  • If the sales schedule is based on a sales contract with a linked terms and conditions agreement:

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

When you approve a sales schedule for which a reconciliation record with the Dispute status exists, a warning message is printed on the approval report. For more information on approving sales schedules, refer to Approving sales schedules.

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

If a record obtains the Dispute status because the quantity shipped is more than the quantity that you reported shipped, you must record an extra quantity shipped in Warehousing instead of choosing Adjust Shipped CUMs, or Adjust and Reconcile. The reason for this is that if you adjust the shipped CUM, no invoice is raised for the additionally shipped goods.

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

You can also check whether you must create an invoice correction in the Sales Schedule Invoice Lines (tdsls3140m200) session by comparing the Cumulative Invoiced Quantity from the Invoiced CUM (tdsls3533m000) session with the Received CUM after reconciliation. As a result, you can view whether you invoiced your customer too much or too little compared to the receipts.

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

Related topics