Quantities on Hand

There are various transactions that will update the inventory quantities on hand in the inventory master list file (ivmaster.adt).  This chapter briefly outlines the various transactions and provides a list of the various files that are updated with the transaction information.  This information may assist you in reconciling the inventory quantities on hand to the inventory balances in the general ledger detail file (gldetail.adt).

Posting Receivers in the Inventory Module

The posting process includes updating the inventory master list (ivmaster.adt) with the purchased quantities for each part number, and then merging the purchase entries into the historical inventory receivers file (ivrecvr.adt). Note: The general ledger is NOT updated at this time.  The general ledger will only be updated when the vendor invoices are entered through the Payables system.

Posting Transfers in the Inventory Module

The posting process includes updating the inventory master list (ivmaster.adt) with the transferred quantities for each part number, updating the historical job cost transaction file (jobdetl.adt) with any transfer amounts (if applicable), updating the historical general ledger transaction file (gldetail.adt) with the debits and credits, and then merging the transfer entries into the historical inventory transfer file (ivxfers.adt).

Posting Receivers in the Orders Module

Shipments must be recorded on Stock Orders in order to update the quantity on hand. Note: The general ledger is NOT updated at this time.  The general ledger will only be updated when the vendor invoices are entered through the Orders Module.

Posting Payable Invoices in the Orders Module

Posting the payable invoices against an order will update the historical a/p invoices file (poapinv.db), the open payable invoice file (openap.adt), the historical purchase journal file (purchjnl.adt) and the general ledger detail file (gldetail.adt).

Creating Stock Requests in the Orders Module

Stock Requests are documents that are created to transfer inventory to a job.  The Stock Request must be fulfilled before the inventory quantities, or any other transaction file, is updated.  However, the Inventory Quantities After Commitments report will take into consideration unfulfilled stock requests when projecting the net inventory on hand.

Posting Stock Fulfillments in the Orders Module

The Stock Fulfillment option is used to spread the Stock Request information to the historical inventory transfers file (ivxfers.adt), the historical file (pofulfil.adt), the historical job cost transaction file (jobdetl.adt), and the historical general ledger transaction file (gldetail.adt).