IM04S2 Inventory Management Inventory Transaction Audit Report
Inventory Transaction Audit Trail Report
Application Overview
The Inventory Transaction Audit Trail Report provides a complete history of transactions affecting on-hand levels of an item or range of items. The report is generated two different ways depending on whether on-line or batch transaction processing is selected in I/M Setup.
On-line Processing
If on-line processing is being used, the report prints all add, change, or delete actions taken against an item by location. It allows the user to define which types of transactions (issue, receipt, and transfer) will appear on the report. The user may also choose whether to print the report and purge the Transaction Audit File or to only do one or the other.
Batch Processing
If batch processing is being used, the report will always be printed, but the user may still decide whether or not the Transaction Audit File will be purged. The user may also set two additional limits on the batch report. Transactions for the report can originate in the I/M, COP, P/O, BOMP, SFC, LP, and JC packages. The user may choose to include transactions from any one or all of the packages. The report may also be run for a specific location or for all locations on file.
The batch report prints the transactions by item number and location, and lists the type of transaction, date, quantity involved, new quantity on-hand, and other information for each.
If batch processing is being used, beginning balance records can be created in the audit file using the Set Trx Audit File Beg. Balances application. The beginning balance record captures each item's quantity on hand at each stocked location as of a specified date. New items added through Item File Maintenance and new stocking locations for items added through Location Control File Maintenance after beginning balances have been set will create new records using the system date.
Note: Regardless of which type of processing is being used, this application may only be accessed if the Audit Trail On Inv. Transactions ? flag #19 in I/M Setup is set to Y.
Run Instructions - On-Line Processing
Select Inv Transaction Audit Trail Report from the pull down I/M Reports window. The following screen will then be displayed:
On-Line Inventory Transaction Audit Trail Report Entry Screen
The following options are available:
- Select the desired mode from the Inv Transaction Audit Trail Report menu bar
- Enter the data requested on the screen
To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.
Entry Field Descriptions - On-line Processing
Name | Type and Description |
1. Print Report | Y or N. Enter Y to print the report or N to decline. Fields 1 and 2 may not both be set to N. Defaults to Y. |
2. Purge File | Y or N. Enter Y to purge the transactions or N to decline. Keep in mind that Inventory Transaction Audit Trail File is used for many statistic information calculation in Elliott, therefore, we suggest you to keep a reasonable amount of history (e.g. 3 yearss) Also, be aware that if this flag is disable, then it means the purge control is turned on in Global Setup -> System -> User Purge Control. Defaults to N. |
3. Starting Item | 15 alphanumeric characters. Enter the starting item for the range you want to print. Defaults to All items. |
4. Ending Item | 15 alphanumeric characters. Enter the ending item for the range you want to print Defaults to the starting item. |
5. Transaction Type | 1 alphanumeric character. Enter one of the valid types or press RETURN to default to All types. The valid transaction types are: I = Issues R = Receipts T = Transfers |
6. Starting Date | A standard date format. Enter the starting date range for the transactions you want to print. Defaults to All dates. |
7. Ending Date | A standard date format. Enter the ending date of the range of transactions you want to print. Defaults to the starting date. |
On-Line Inventory Transaction Audit Trail Report
Run Instructions - Batch Processing
Select Inv Transaction Audit Trail Report from the pull down I/M Reports window. The following screen will then be displayed:
Batch Inventory Transaction Audit Trail Report Entry Screen
The following options are available:
- Select the desired mode from the Inv Transaction Audit Trail Report menu bar
- Enter the data requested on the screen
To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.
Entry Field Descriptions - Batch Processing
Name | Type and Description |
1. Purge File | Y or N. Enter Y to purge the transactions or N to decline. Defaults to N. |
2. Starting Item | 15 alphanumeric characters. Enter the starting item for the range you want to print. Defaults to All items. |
3. Ending Item | 15 alphanumeric characters. Enter the ending item for the range you want to print. Defaults to the starting item. |
4. Transaction Type | 1 alphanumeric character. Enter one of the valid types or press RETURN to default to All types. The valid transaction types are: I = Issues A = Adjustments R = Receipts T = Transfers C = Cost Adjustment L = Layer Adjustment B = Beginning Balance |
5. Starting Date | A standard date format. Enter the starting date range for the transactions you want to print. Entry is required unless the Set Transaction Audit File Beg. Balances application has been run. In that case the date defaults to the date defined in that application. |
6. Ending Date | A standard date format. Enter the ending date of the range of transactions you want to print. Defaults to the starting date. |
7. Location To Print | 2 alphanumeric characters. Enter the location for which the report will be printed. Defaults to All locations. |
8. Source | 2 alphanumeric characters Valid entries are: IM = Inventory Management CP = Customer Order Processing PO = Purchase Order & Receivings BM = Bill of Material Processor SF = Shop Floor Control LP = Labor Performance JC = Job Costing Enter the source package for the transactions to print on the report. If a source is entered, only transactions originating in that package will appear on the report. Press RETURN to default to ALL packages. |
