IM02S2 Inventory Management Inventory Location Audit Trail Report

IM02S2 Inventory Management Inventory Location Audit Trail Report

Inventory Location Audit Trail Report

Application Overview

 The Inventory Location Audit Trail Report shows transactions that have taken place against an inventory item in any location entered during the Inventory Location File Maintenance application.  This report displays information such as the item number, location, and what type of action has been taken on that item.  It also displays the item's quantity on hand, on order, and allocated for the location.  Each item's last sale date and quantity sold are also displayed.  The report is designed to help track all transactions that have taken place against inventory items stocked at multiple locations.

The report codes representing the types of action (transactions) taken against the items are as follows:

   A  =      Addition

   B  =      Before Change

   C  =      Change

   D  =      Deletion

 

Run Instructions

 Select Inv Location Audit Trail Report from the pull down I/M Reports window.  The following screen will then be displayed:

 


 

 The following options are available:

    • Select the desired mode from the Inv Location 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

     

    Name

    Type and Description

    Starting Item No

    15 alphanumeric characters.

    Enter the starting item number for the range of items to be printed. 

    Defaults to All.

    Ending Item No

    15 alphanumeric characters.

    Enter the ending item number for the above range. 

    Defaults to the starting item number.

    Starting Location

    2 alphanumeric characters.

    Enter the starting location for the range of locations within the above item range to be printed.

    Ending Location

    2 alphanumeric characters.

    Enter the ending location for the above range. 

    Defaults to the starting location.

    Starting Date

    A date in the standard date format.

    Enter the starting date in the range you want to print. Defaults to All dates.

    Ending Date

    A date in the standard date format.

    Enter the ending date for the range you want to print. Defaults to the starting date.

    Purge File ?

    Y or N.

    Enter Y to purge all records in the Audit Trail File, or N to retain the records for future reference.  Defaults to N.

     

     

     

    Inventory Location Audit Trail Entry Screen



     

     

                          

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     




      • Related Articles

      • Feature - Added CSV Support to the Item Audit Trail Report

        Release Date: 01/29/2019 Added CSV support to the Item Audit Trail Report. Enter "Y" in field "6. Export to CSV File." Enter the path and file name in field "7. CSV File Name & Path." The default for field 6 is N. Values for both fields will be ...
      • AP01S4 Accounts Payable Vendor Audit Trail Report

        Vendor Audit Trail Report Application Overview The Vendor Audit Trail Report shows any additions, changes, and deletions made to the Vendor File. When you are in A/P Setup, you can choose to keep an "audit trail" on the Vendor File. Additions to the ...
      • BM01S1 Bill of Material Audit Trail Report

        Audit Trail Report Application Overview The Audit Trail Report can be printed at any time showing all additions, changes and deletions to the Product Structure File. Run Instructions Select Audit Trail Report from the pull down BOMP Maintenance ...
      • EMPAUD Payroll Employee Audit Trail Report

        Reports Employee Audit Trail Report Application Overview The Employee Audit Trail Report application enables you to track changes made to sensitive payroll data entered into the change mode of the Employee File. In order to obtain an audit trail ...
      • CP07S1 Customer Order Processing Backorder Audit Trail Report

        Backorder Audit Trail Report Application Overview The Backorder Audit Trail Report displays transactions of the automatic and manual backorders that have been filled. If you select Backorder Audit Trail Report, a screen will display upon which ...