| # To reconcile sales schedules Sales schedule reconciliation is the process to monitor if your business partner's Received CUM matches with your Cumulative Shipped Quantity. Matching is only performed for material releases and shipping schedules that contain non-referenced items. If the CUMs do not match, disputes are generated that must be solved. Important! It depends on the setting of the Consider Planned/Actual Delivery Date during Reconciliation check box in the Items - Sales Business Partner (tdisa0510m000) and/or the Sales Contract Line Logistic Data (tdsls3102m000) session how the Cumulative Shipped Quantity is calculated in the Sales Schedule Reconciliation (tdsls3131m000) and Shipped CUM (tdsls3532m000) sessions. If the Synchronize Cums check box is selected in the Schedule Terms and Conditions (tctrm1131m000) session, you cannot reconcile sales schedules. To insert reconciliation records When you confirm a shipment for a sales schedule, ERP 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, ERP LN: Inserts the number of the last shipment that your business partner received for the sales schedule in the Sales Schedule Reconciliation (tdsls3131m000) session. Inserts the last quantity that your business partner received for the sales schedule in the Sales Schedule Reconciliation (tdsls3131m000) session. Calculates the new Received CUM by adding the Last Receipt Quantity to the Received CUM of the concerned and next reconciliation records. 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 To approve 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 Specific menu of the Sales Schedule Reconciliation (tdsls3131m000) session: Reconcile Received CUMs ERP LN adjusts the Received CUM to equal the Cumulative Shipped Quantity. The reconciliation record gets the Reconciled status. Adjust Shipped CUMs ERP 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 Warehouse Management 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. ERP 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, ERP 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 less compared to the receipts. For more information on shipment corrections and sales schedule invoices, refer to Sales schedules and Central Invoicing. Related topics Sales schedule cumulatives Sales schedule procedure |