| Reconciling sales schedulesMaterial 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 Items - 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 Cumulative Shipped Quantity 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: - 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 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. | |