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:

When setting up the reconciliation conditions, you can select one of the following options:

Note: It is not possible to perform a reconciliation if the reconciler is blocked for use.

Prerequisites

System Effects

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.