Perform Reconciliation
Explanation
When a new customer schedule arrives, it is considered an override of previous
schedule information for the same time period. The reconciliation process is
designed to bring newly arrived schedules up to date, based on an alignment
of the customer's and the company's delivery records.
The reconciliation process attempts to automatically align the schedules
so that no delivery quantities are skipped or duplicated. The process recognizes
the latest receipt recorded by the customer and the last delivery recorded for
the order, then consumes the differences in the schedule to align the necessary
delivery quantities.
Perform reconciliation by using one of the following alternatives:
- Directly reconcile a specific customer schedule from the
Customer Schedule or the
Customer Schedules page.
- Directly reconcile all customer schedules that meet the defined selection
criteria in the
Reconcile Customer
Schedule dialog.
- Create a schedule to perform a reconciliation on a regular basis of
all the customer schedules that meet the defined selection criteria in the
New Database Task Schedule. Default settings
in the Reconcile
Customer Schedule dialog can be used by selecting the Default
feature. Default settings are derived from the Database Tasks
page set by the administrator.
- Manually update the necessary information, and then directly reconcile
a specific customer schedule from the
Manually Reconcile Customer
Schedule page.
When setting up the reconciliation conditions, you can select one of the
following options:
- No Reconcile. The reconciliation process is not used.
- Use Delivery Note: The system erases the quantities that are
sent after the last delivery note indicated by the customer. However, if
you chose to use the backorder feature together with the reconciliation
process, it is possible to add schedule lines that are due before the validity
period of the schedule. All quantities with a due date before the start
date of the schedule are considered as backorder lines. When running the
reconcile process and you have indicated that you want to match the backorder
quantity for the schedule, the system will check whether the back order
quantity matches the previously generated customer order lines.
- Use Cumulative Quantity: Only cumulative records are compared.
Delivery notes are not taken into consideration.
- Use Delivery Note and Cumulative Quantity: Both delivery notes
and cumulative records are matched.
If the Delivered Qty per Agreement Cross Reference
toggle is set to True in the Customer Schedule Agreement
Part Page, and the Reconciliation Option is set to
Use Delivery Note and Cum Quantity or Use Cumulative Quantity,
then during Reconciliation, the delivered quantity per each
Customer Agreement Cross Reference will be used separately to reconcile
the Customer Schedule lines.
If the toggle is disabled, the total
cumulative delivered quantity will be used for reconciliation,
disregarding the Customer Agreement Cross Reference.
Note: It is not possible to perform a reconciliation if the reconciler
is blocked for use.
Prerequisites
- A customer schedule with schedule lines must have been entered.
- The user performing the reconciliation process must have been linked
to the reconciler ID entered on the customer schedule agreement.
System Effects
- If a previous schedule plan or call-off is overlapped by this new schedule,
the previous data is overruled by the new schedule. This means that, if
the first schedule indicated a schedule line on the 3rd of December and
the second schedule starts at the 1st of December (not indicating any schedule
line until the 5th of December), the system automatically assumes that the
schedule line for the 3rd of December should be skipped. If both schedules
have lines on the same date, they are considered and treated as identical
lines.
- If you have scheduled the task as a background job in the
Reconcile Customer
Schedule dialog, the task will be automatically performed based
on the specified selection criteria.