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:

1. Query for the schedule's document number.
2. 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.
3. 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:

1. Open the Reconcile Customer Schedule dialog box. 
2. If you want to reconcile all the existing schedules, leave all the fields blank in the Parameters group box. 
3. 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.
4. 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:

1. 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:

1. 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.
2. 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:

1. Query for the  desired schedule.
2. Right-click and then click Reconcile.