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.