 |
|
Inventory Transaction Audit Trail ReportApplication 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
On-Line Inventory Transaction Audit Trail Report
I N V E N T O R Y T R A N S A C T I O N A U D I T T R A I L R E P O R T
Range: All Items All Dates Actions: A = Addition C = Change D = Deletion Trx Types: I = Issue R = Receipt T = Transfer P = Production
Item No Description Act Type Pkg Trx‑Date Trx‑Time Loc Loc Trx‑Qty Old‑Qty‑Oh New‑Qty‑Oh Order/PO No Ord Org‑Date Org‑Time Fr To Trx‑Cost Old‑Avg‑Cost New‑Avg‑Cost Comments Cmp? Serial/Lot No
BOX‑386‑1 Basic SM Box w/7 Exp 6‑16 1‑8
A I BM 02/14/92 20:54:47 LA 1.000 742.000 741.000 000101 N 02/14/92 20:54:47 311.0000 311.0000 311.0000 In‑House Work Stations
A I BM 02/17/92 20:54:48 LA 1.000 741.000 740.000 000101 N 02/17/92 20:54:48 311.0000 311.0000 311.0000 In‑House Work Stations
A I BM 02/18/92 20:54:49 LA 2.000 740.000 738.000 000101 N 02/18/92 20:54:49 311.0000 311.0000 311.0000 In‑House Work Stations
A I BM 04/06/92 12:56:27 LA 3.000 738.000 735.000 000110 Y 04/06/92 12:56:27 311.0000 311.0000 311.0000 Personal Computer Job PC‑386
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
I N V E N T O R Y T R A N S A C T I O N A U D I T T R A I L R E P O R T
Range: All Items Dates 03/01/93 Thru 03/16/93 All Locations All Transaction Types All Sources Trx Types: I=Issue R=Receipt T=Transfer A=Item Adj. C=Cost Adj. L=Layer Adj. B=Begin Balance ** = Not in Total
Item/Desc Loc Typ Doc# Doc‑Date Doc‑Time Src Trx‑Qty Trx‑Cost New‑Qty‑O/H Cust/Vend Order# Serial/Lot
CLOCK 25 Meg Clock For Mother Board Clock ‑ 25M
LA I 000000 03/08/93 14:54:35 SF 1.000‑ 12.5400 14.000 CPU‑PC 000010002530501 LA I 000000 03/08/93 14:54:40 SF 1.000‑ 12.5400 13.000 CPU‑PC 000010002530502 LA I 000000 03/08/93 14:54:45 SF 1.000‑ 12.5400 12.000 CPU‑PC 000010002530503 LA I 000000 03/08/93 14:54:50 SF 1.000‑ 12.5400 11.000 CPU‑PC 000010002530504 LA I 000000 03/08/93 14:54:56 SF 1.000‑ 12.5400 10.000 CPU‑PC 000010002530505 LA I 000000 03/12/93 10:52:08 SF 1.000‑ 12.5400 9.000 CPU‑PC 000000103820003
Totals: Beg‑Bal: .000 Rec: .000 Adj: .000 Iss: 6.000 End‑Bal: 6.000‑ Itm‑O/H: 8.000 **
CPU Mother Board For Parent Central Processing
LA R 000000 03/08/93 14:54:39 SF 1.000 2,103.4900 5.000 CPU‑PC 000010002530501 LA R 000000 03/08/93 14:54:44 SF 1.000 2,103.4900 6.000 CPU‑PC 000010002530502 LA R 000000 03/08/93 14:54:49 SF 1.000 2,103.4900 7.000 CPU‑PC 000010002530503 LA R 000000 03/08/93 14:54:54 SF 1.000 2,103.4900 8.000 CPU‑PC 000010002530504 LA R 000000 03/08/93 14:55:00 SF 1.000 2,103.4900 9.000 CPU‑PC 000010002530505 LA R 000000 03/12/93 10:52:12 SF 1.000 2,493.3700 10.000 CPU‑PC 000000103820003
Totals: Beg‑Bal: .000 Rec: 6.000 Adj: .000 Iss: .000 End‑Bal: 6.000 Itm‑O/H: 11.000 **
CPU‑30MEG Z80 Micro Processor 30 Meg CPU ‑ Z80
|
