Program Description
This program is also called Stock Status by Inventory or Inventory Transaction Report. It can be found on the Inventory Reports Stocking and Analysis Reports menu (INV-4-2-6). It includes all inventory transactions made through the Inventory Data Entry and PO Receipts programs. Also, changes and deletions made to the Item File (ITEM), Item Warehouse File (ITEMWHD), and Serial File (SERIALD) are included. The report provides a way to monitor inventory transactions entered for a specific date, date range, or the current accounting month. The included inventory transactions can be specified by product class, warehouse, item number, and the type of inventory transactions. Information included is the transaction type, quantity, item and warehouse affected, product class of item, cost on receipts transactions, document and purchase order numbers, date of transaction, and the initials of the operator who entered the transaction.
The report uses the Inventory Transaction (IMWACTD) (Inventory Warehouse ACTivity Data) table. This table is updated by On Order Posting/Adjustments, Inventory Receipts, On Hand Adjustments, Back Order Adjustments, Allocation Adjustments, Inventory Transfer, Automatic Inventory Transfer, Physical Posting, Remote Physical Posting, PO Receipts, and PO File Maintenance (when reversing a P.O. Receipt). The file is also updated when an item and Item/warehouse record are accessed in the change mode or deleted in Item File Maintenance and Warehouse/Item File Maintenance. Accessing a Serial File record in the change mode in Machine Placement and Serial File Maintenance creates an Inventory Transaction (IMWACTD) record. Accessing an existing machine through the add mode in Machine Placement also creates an Inventory Transaction record, since this is basically a change. Deleting a Serial File out of Serial File Maintenance also creates an Inventory Transaction record. Therefore, all transactions entered through these listed programs are included on the Stock Activity Inventory Report in Stocking and Analysis Reports.
The information stored in the IMWACTD table is maintained on the system until a purge is run. The Initialize Index Files program which must be run with the AR Billing End of Month Procedures, marks the current month's transaction as not a current month transaction. This enables the report to include only all the inventory transactions for the current accounting month. Possible Inventory Transaction Types:
1 = On Order Adjustments
2 = On Hand Adjustments
3 = Back Order Adjustments
4 = Allocation Adjustments
5 = Inventory Transfers
6 = Receipts
7 = Physical Posting
8 = Item & Item Warehouse Changes/Deletions
9 = Serial Changes/Deletions
Results
Sample Ouput 1:
Sample Output 2:
Rev 14 Changes
On Physical Posting transactions, there will now be a second line printed on the report showing the “PRIOR ON-HAND QTY”. See the example below:
Rev 13 Changes
Internal changes were made so that this report will run properly in the End of Month Report chain to disk only.