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 window.
- Directly reconcile all customer schedules
that meet the defined selection criteria in the
Reconcile Customer Schedule
dialog box.
- 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 box can be used by selecting the Default
feature. Default settings are derived from the Database Tasks
window set by the administrator.
- Manually update the necessary information, and then
directly reconcile a specific customer schedule from the
Manually
Reconcile Customer Schedule window.
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.
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
box, the task will be
automatically performed based on the specified selection criteria.
Window
Customer Schedule
Reconcile Customer Schedule
Manually Reconcile Customer
Schedule
Customer Schedules
Related Window Descriptions
Customer Schedule
Reconcile Customer
Schedule
Manually Reconcile Customer Schedule
Customer Schedules
Procedure
To directly reconcile a specific customer schedule from the Customer Schedule
window:
- Query for the schedule's document number.
- Study the delivery note data in
the
Reconciliation Info tab. If the last delivery received by
the customer does not correspond to the last delivery shipped by the
company, enter the delivery note number from the customer in the Last Receipt group box.
- On the Operations menu, click Reconcile.
Note:
If you have chosen to reconcile cumulative quantities, delivery notes are not taken
into account.
To directly
reconcile all the customer schedules that meet the defined selection criteria in the
Reconcile
Customer Schedule
dialog box:
- Open the
Reconcile Customer Schedule
dialog box.
- If you want to reconcile all the existing schedules, leave all
the fields blank in
the Parameters group box.
- If you want to use the customer number, ship address
number, customer part number, agreement identification, schedule type, schedule document
number, or schedule number
as selection criteria, enter the appropriate values in the respective
fields. Enter the values or click List
to select one from the List of Values.
- Click OK to complete the process.
Note: Click Default if you want to use
the default settings.
Create
a schedule that on a regular basis reconciles all the customer schedules that meet
the defined selection criteria in the
Reconcile Customer Schedule
dialog box:
- Click
Schedule to open the New Database Task Schedule window.
Set the scheduling parameters as desired and save. Scheduled tasks can be
seen in Scheduled Database Tasks window
Note:
If you have chosen to reconcile cumulative quantities, delivery notes are not
taken into account.
Manually
update the necessary information, and then directly reconcile a specific customer
schedule from the
Manually Reconcile Customer Schedule window:
- Query for the schedule's document number. Study the delivery note data in
the
Reconciliation Detail tab. If the last delivery received
by the customer does not correspond to the last delivery shipped by the
company, enter the delivery note number from the customer in the Last Receipt group box.
- On the Operations menu, click Reconcile Manually.
Note:
If you have chosen to reconcile cumulative quantities, delivery notes are not taken
into account.
To directly reconcile a specific customer schedule from the Customer Schedules
window:
- Query for the desired schedule.
- Right-click and then click Reconcile.