MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Distribution > Synchro > Programs > Automatic Reconciliation of Synchronization Data - Purpose > Automatic Reconciliation of Synchronization Data - Calculations

Automatic Reconciliation of Synchronization Data - Calculations

GA205E

A.   Mainline

1.   For each item/delivery point on the master file (GA120M2), the following processing is performed:

a.   If the total received quantity (DPTRCQ) is zero (meaning it was not transmitted by the customer), recalculate the quantity by subtracting the difference between expected and received quantities (DPEXRS) from the total expected quantity (DPTEXQ):

DPTRCQ = DPTEXQ - DPEXRS

      All figures are in ordering units (OU) and have been transmitted by the customer with the DELINS message.

b.   The shipping list header and detail files are read for the last shipment received by the customer (subroutines DLVYHD, DLVYLN).  For all subsequent shipments (for this item/delivery point and blanket order), the shipped quantities (NLSHQT, in stockkeeping units - SKU) of the detail lines are added in the work field WCQEXP.  WCQEXP represents the items shipped but not yet received by the customer.

c.   WCQEXP is subtracted from the total shipped quantity as of that date (DPTSHP).  The result, WQCSKU, is converted from stockkeeping units into ordering units giving WQCDRU (subroutine SKUDRU).

WQCDRU = DPTSHP - WCQEXP

d.   If WQCDRU does not match the total receipts quantity (DPTRCQ) on GA120M2, the Synchronization flag is set on (DPSYFL) on the Item/Delivery Point file (GA120M2) and a warning will be reported on GA230AP.

2.   Errors occurring during the daily batch process are recorded on the message file GA999AP, sorted by warnings and critical and abort errors.

GA205E Program Menu