|
This program reads and consolidates all inventory where:
Warehouse < 90 and Edp-no and Warehouse-Loc are the same.
Cost averaging: a table is used internally in the program where
the total-extended cost of each inventory detail and the qty are stored. When
all of the applicable details are found, the extended costs are totaled and
divided by the total quantity of all of the inventory details to compute the new
unit cost. The total quantity and the new unit cost are used to populate the
matching fields in both the new INV-DETAILS and INVENTORY-TRANS entries.
An INVENTORY-TRANS record is written to provide an audit trail
of this unique transaction. This program has two parms:
Parm 1 - live run
Parm 2 identifier mode, creates comma-del ASCII output file of resulting
entries
To provide roll-back capabilities, the INV-DETAILS and
INVENTORY-TRANS data-sets are saved in a Suprtool self-describing output file,
called SAVEIDT and SAVEITR in the HEIDATA group. |