IC242 - Transaction Audit Report Run this report to audit transaction quantities and stock-on-hand balances for a specific period and year. Before you run this program, ensure that two periods are closed: the period for which you are printing the report and the prior period. When you close periods in IC190 (Closing), the system updates stock-on-hand balances to inventory history records. You can select items printed on this report by location, report group, and inventory class. You must specify a period and year. This report lists item transactions followed by transaction summary totals. Optionally, you can print summary totals only. When you run this program, the system calculates a running total of stock-on-hand quantities, beginning with stock-on-hand balances from the last period. The system prints an exception error message if ending stock-on-hand balances calculated in this program do not agree with the stock-on-hand ending balances updated to inventory history records. Note: This program reads all inventory transactions processed in the Inventory Control, Purchase Order, Requisitions, Order Entry, Work Order, and Case Carts systems. Updated Files CKPOINT - Referenced Files ICCOMPANY - Used to validate the Inventory Control system company. ICHISTORY - Used to retrieve the entered periods beginning stock on hand. ICLOCATION - Used to validate and print location information. ICRPTGRP - Used to validate the report group. ICTRANS - Used to retrieve historical inventory transaction records. ITEMLOC - Used as a primary file to sequence by item within location. ITEMMAST - Used to retrieve the item description information. POCOMPANY - Used to retrieve purchase order account information. POPROCLEV - Used to retrieve purchase order account information. PORECLINE - Used to retrieve historical purchase order transaction records. |