Inventory Management IM04S2 Help - Elliott Business Software



Inventory Transaction Audit Trail 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.

 

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

 

 

                          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

 

 

REPORTSRun 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.

ScreenREPORTS

 

 

 

                          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

 

 

 



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile