Documentation >
MAC-PAC Technical Library >
Manufacturing >
Inventory Control >
Programs >
Inventory Control Warehouse Balance Audit - Purpose >
Inventory Control Warehouse Balance Audit - Calculations
Inventory Control Warehouse Balance Audit - Calculations
IC660E
A. Housekeeping
1. See Common Processing Routines - Housekeeping in this manual for a general discussion of this subroutine. Processing specific to this program is described below.
2. The Printer file (category D04) is retrieved from the Reference file, and its values are saved.
B. Mainline
1. Warehouse Balance Audit
a. The Warehouse Balance file is read sequentially.
b. For each record retrieved from the Warehouse Balance file, the component requirements, and manufacturing, purchase, sales, and transfer orders sourced from that warehouse are retrieved.
c. Lines that are closed, reference parts, standing orders, and orders to be relieved from manufacturing inventory are bypassed. Direct ship blanket orders are also bypassed. Orders with these characteristics do not affect the warehouse balance.
d. For manufacturing orders, the on-order quantity is calculated as:
Order Quantity - Received Quantity
(HORDQ) - (HTQR)
e. For purchase orders, the on-order quantity is calculated as:
Release Quantity - Received Quantity
(PDQTSK) - (PDRCSK)
f. For transfer orders, the on-order quantity is calculated as:
Ordered Quantity - (Received Quantity + Shrinkage Quantity)
(TLORQY) - (TLRCQY + TLQTLS)
g. For component requirements, the on-order quantity is calculated as:
Required Quantity - Quantity Issued
(MZRQTY) - (MZIQTY)
h. For component requirements, the allocated quantity is calculated as:
Required Quantity - Quantity Issued
(MZRQTY) - (MZIQTY)
i. For sales orders, the allocated quantity is calculated as:
(Required Quantity) + (Unreleased Quantity, if greater than zero)
(SLRLQO)
j. For transfer orders, the allocated quantity is calculated as:
Ordered Quantity - Shipped Quantity
(TLORQY) - (TLSHQY)
Note: For d through g, the calculated quantity is a sum of all valid references for a specific part in each file.
k. A report is generated showing all differences between the calculated values and the master file values.
l. If requested, the master file is updated.