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

      • IM01S3 Inventory Management Iten Audit Trail Report

        Item Audit Trail Report Application Overview The Item Audit Trail Report will show the information about all transactions that have taken place against an inventory item during Inventory Item File Maintenance. This report displays information such as ...
      • 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 ...
      • Feature - Export Inventory TRX Audit Trail to CSV

        Release date: 2/26/2018 Added the option to export the inventory transaction audit trail report data to a CSV file. We will only export the base data from the transaction audit trail file. We will not be exporting any bin or serial/lot data at this ...
      • PO05S1 Purchase Order and Receiving Receivings Audit Trail Report

        Receivings Audit Trail Report Application Overview You may print the Receivings Audit Trail Report as often as you like. It may be printed for a range of purchase order numbers, item numbers and receipt dates. This report lists a great deal of ...
      • 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 ...