Documentation >
MAC-PAC Reference Library >
Reference >
Common Features >
Reports >
Warehouse Balance Audit
Warehouse Balance Audit
CF570A
DATE 27/02/92 WAREHOUSE BALANCE AUDIT REPORT PAGE 1
TIME 11:49:17
REPORT CF570A
PART NUMBER CO WHS FIELD IN ERROR QUANTITY IN ERROR CORRECTED QUANTITY
--------------- --- --- ---------------------------------- --------------- ---------------
BOLT-100 001 ITA BACKORDERED SALES ORDER QUANTITY 175.0 .0
BOLT-100 001 ITB UNRESERVED SALES ORDER QUANTITY 100.0 .0
BOLT-100 001 IT1 RESERVED SALES ORDER QUANTITY 1,690.0 75.0
BOLT-100 001 IT1 BACKORDERED SALES ORDER QUANTITY 100.0 .0
BOLT-100 001 IT1 UNRESERVED SALES ORDER QUANTITY 5,593.0- 180.0
BOLT-100 001 IT1 ON-ORDER QTY DIRECT SHIPMENT-S.O. 475.0 .0
BOLT-100 001 IT3 RESERVED SALES ORDER QUANTITY 220.0 170.0
BOLT-100 001 IT3 BACKORDERED SALES ORDER QUANTITY 2,384.0 2,184.0
BOLT-100 001 IT3 UNRESERVED SALES ORDER QUANTITY 148.8 1,775.8
BOLT-200 001 ITA BACKORDERED SALES ORDER QUANTITY 275.0 .0
BOLT-200 001 IT1 RESERVED SALES ORDER QUANTITY 20,095.6 12,280.5
|
Purpose
The Warehouse Balance Audit Report provides a list of fields whose values are in error according to the audit of the sales order lines to the Warehouse Balance File. For each sales order sourced from a warehouse, the following quantities are calculated from the Sales Order Line File records.
1. Unreserved quantity for blanket orders
2. On-order quantity for direct ship orders
3. Reserved quantity
4. Backordered quantity
5. Unreserved quantity
Each of these calculated fields is compared to the corresponding field on the Warehouse Balance Header File. Any differences are noted on the report.
Report Sequence
Sourcing Company, Sourcing Warehouse, Part.