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

      

                        


    REPORTRun 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

       

       

       

      Inventory Management

      1. Long-Term vs. Short-Term Inventory Quantity Available and Inventory with Time Line
      2. Introduction to Available to Promise (ATP)
      3. Inventory Aging Report by Location Sequence Produces Different Result Than by Other Sequence
      4. Inventory Aging Report Shows Different Age Between Single and All Locations
      5. Multiple Users Entering Physical Count Tag at the Same Time Issue
      6. Expand Item Description 1 and 2 Character Limit
      7. How Different is an IM Kit from a BOMP Kit?
      8. Explanation on Component Availability Inquiry
      9. How Is Shortcut Item Different from Kit Item?
      10. No Privilege to View Location History
      11. How to Calculate EOQ (Economic Order Quantity)
      12. Item Quantity Allocation Is Incorrect
      13. Reorder Advice Custom CSV Export Shows Zero Items
      14. Elliott Physical Count Processing
      15. Feature - Add-On Item Drill Down From Item Search
      16. Feature - Utility to Reset Item PTD Fields from Location History
      17. Feature - Inventory Snapshot
      18. Feature - ATP Regen to Consider Order Multiple and Economic Order Qty
      19. Feature - Item Master Activity Sub-Code
      20. Feature - Add Support for the Update of “Mostly Mfg Flag” in Change Existing Item Import
      21. Feature - Auto Delete BOMP Product Structure When Item Obsolete
      22. Feature - Item Linkage Report/Processing
      23. Feature - Added the Ability to Organize Product Categories by a New Product Category Group
      24. Procedure to Correct Bad Serial Number with Special Symbol
      25. Feature - Additional SY12MONS Updates
      26. Feature - Additional Activity Codes for Item Linkage CSV Report and Item Linkage Processing
      27. Feature - Item Number Wild Card Support for Starting Item Number
      28. Feature - Obsolete Kit Parent When First Component is Obsolete
      29. Feature - Show Items with Qty Variance on Tag Variance Reports
      30. IM01S3 Inventory Management Iten Audit Trail Report
      31. IM04S2 Inventory Management Inventory Transaction Audit Report
      32. IM02S2 Inventory Management Inventory Location Audit Trail Report
      33. IM03S1 Inventory Management Usage Exception Reports
      34. IM06SCN Inventory Management Stock Status Report
      35. IM08S1 Inventory Management Print Cycle Count Worksheet
      36. IM14S1 Inventory Management Item History Report
      37. IM19S1 Inventory Management Serial/Lot Stock Status Report
      38. IM19S2 Inventory Management Serial/Lot Issue History Report
      39. IM20S1 Inventory Management I/M Distribution to G/L Report
      40. IM26SCN Inventory Management Frozen Stock Status Report
      41. IM30S1 Inventory Management Kit Where-Used Report
      42. IM31S1 Create Unreleased POs by Vendor
      43. IM32S1 Inventory Management Kit Gross Requirements Report
      44. IM0201 Inventory Management Location Control File Maintenance
      45. IM0405 Inventory Management Available To Promise Inquiry
      46. IM0500 Inventory Management Stock Status Inquiry
      47. IM0500Q Inventory Management Stock Status Inquiry
      48. IM0700 Inventory Management ABC Analysis Reports
      49. IM0900 Inventory Management Reordering Advice Reports
      50. IM1000 Inventory Management Physical Count Processing
      51. Feature - Utility to Reset Item PTD/YTD Fields from Location History
      52. IM1100 Inventory Management Utilities Setup
      53. IM1201 Inventory Management Location File Maintenance
      54. IM1300 Inventory Management Recalculate Reorder Fields
      55. IM1400 Inventory Management Clear Item Accumulators
      56. IM1501 Inventory Management Product Category File Maintenance
      57. IM1601 Inventory Management Material Cost Type File Maintenance
      58. IM1701 Inventory Management Material Cost Type/Loc File Maintenance
      59. IM1801 Inventory Management Buyer/Analyst Code File Maintenance
      60. IM1901 Inventory Management Initialize Lifo/Fifo File
      61. IM1902 Inventory Management Adjust Item File to Lifo/Fifo
      62. IM1903 Inventory Management Serial/Lot Processing/Multi-bin Utilities
      63. IM1904 Inventory Management Serial/Lot Stock Status Inquiry
      64. Feature - Add Additional Record Types to Reorder Advise User-Defined CSV Export
      65. IM2500 Inventory Management Reset Allocated Quantities
      66. IM2700 Inventory Management Set Trx Audit File Beginning Balances
      67. IM2800 Inventory Management Freeze Inventory
      68. IM2900 Inventory Management Kit File Maintenance
      69. IM3301 Inventory Management Job Code File Maintenance
      70. IM3400 Inventory Management Job Analysis Report
      71. IMACTMNT Inventory Management I/M Account File Maintenance
      72. IMAGESCN Inventory Management Inventory Aging Report
      73. IMATPGSN Inventory Management Generate ATP File
      74. IMATPRSN Inventory Management Available to Promise Report
      75. IMBININV Inventory Management Bin Inventory File Maintenance
      76. IMBINMNT Inventory Management Bin File Maintenance
      77. IMBINTRN Inventory Management Inventory Transfer Processing
      78. IMCHGBIN Inventory Management Change Bin No/Pick Seq
      79. IMEXPTSN Inventory Management Export Item for Take an Order
      80. IMFRMMNT Inventory Management Item Label Form Setup
      81. IMGENMNU Inventory Management Generate Location History
      82. IMIMSITM Inventory Management Item Import Utility
      83. IMITMUDS Inventory Management Item User-Defined Fields Import Utility
      84. IMSUBMNT Inventory Management Substitute Item Class File Maintenance
      85. IMUSRMNT Inventory Management User-Defined Code File Maintenance
      86. IMVESMNT Inventory Management Vessel File Maintenance
      87. IMVLSMNT Inventory Management I/M Serial/Lot History File Maintenance
      88. Feature - Expanded Selection Parameters for Reorder Advise User Defined CSV Export
      89. Change - Update Both Kit Parent and Components Usage
      90. Feature - Create Price Code 1 from Item Minimum Price Utility
      91. Change - Available to Promise by Item Report - Add Item Description 2
      92. Feature - Support AR (Attribute) Type in Reorder Advise User Defined CSV Export
      93. Can System Default Item User-Defined Code?
      94. Feature - Item Label Printing Enhancements
      95. Feature - Ability to Initialize Character Fields During Change Existing Item Import
      96. Understanding Status Code at Inventory Transfer Dispatch Screen
      97. Feature - Support GTIN Based on Two Different UPC Codes
      98. Feature - Update Estimated Date/Time When Printing Transfer Tickets
      99. Feature - Allow Physical Count Tag Import Without Serial Number
      100. Feature - Delete Kit Components When Item Activity Code is Set to 'O'
      101. Feature - New QTYAVAILBYCOMP Attribute Fields
      102. Feature - Allow GTIN Maintenance in I/M Change Bin No/Pick Seq Processing
      103. Feature - Improvements to Reorder Advise Reports
      104. What Is the Difference Between INV_TRX_UN_COST and INV_TRX_NEW_AVG_COST in IMINVTRX Table?
      105. Feature - Added a Function "Create Inventory Trx CSV Import"
      106. Feature - Added Support to “Create I/M Trx CSV Import” for Kit Items
      107. Feature - Improvements to QTYAVAILBYCOMP and QTYAVAILBYCOMP2 Attributes
      108. Feature - Add Desc2 Column to Item Linkage CSV Report
      109. Feature - Numeric Item List Changes
      110. Feature - Added 1C and LD Column Types to Reordering Advise User Defined CSV Export
      111. What's the Difference Between Lead Time & Planning Lead Time?
      112. Explanation of ATP LP Type - Negative Sign (-) vs (*) Symbols
      113. IM0000 Inventory Management Package Overview 7
      114. IM0000 Inventory Management Package Overview 1
      115. IM0000 Inventory Management Package Overview 2
      116. IM0000 Inventory Management Package Overview 3
      117. IM0000 Inventory Management Package Overview 4
      118. IM0000 Inventory Management Package Overview 6
      119. IM0000 Inventory Management Package Overview 5
      120. IM0000 Inventory Management Package Overview 8
      121. IM0000 Inventory Management Package Overview: Index
      122. IM0101 Inventory Management Item File Maintenance 1
      123. IM0101 Inventory Management Item File Maintenance 2
      124. IM0101 Inventory Management Item File Maintenance 3
      125. IM0101 Inventory Management Item File Maintenance 4
      126. IM0101 Inventory Management Item File Maintenance 5
      127. IM0101 Inventory Management Item File Maintenance 6
      128. IM0101 Inventory Management Item File Maintenance 7
      129. IM0101 Inventory Management Item File Maintenance 8
      130. IM0101 Inventory Management Item File Maintenance: Index
      131. IM2400 Inventory Management Inventory Transaction Processing 1
      132. IM2400 Inventory Management Inventory Transaction Processing 2
      133. IM2400 Inventory Management Inventory Transaction Processing 3
      134. IM2400 Inventory Management Inventory Transaction Processing 4
      135. IM2400 Inventory Management Inventory Transaction Processing 5
      136. IM2400 Inventory Management Inventory Transaction Processing 6
      137. IM2400 Inventory Management Inventory Transaction Processing 7
      138. IM2400 Inventory Management Inventory Transaction Processing: Index
      139. How to Run Inventory Stock Status Report for a Certain Date
      140. Feature - Transition to Obsolete
      141. Item Last Received Date Not Updated When Received from I/M Transaction Processing
      142. Feature - Zero Item Weight When Using F3 to Copy Item
      143. Feature - Initialize User-Defined Note, Date and Amount Fields When Using F3 to Copy Item
      144. What Information Is Stored in the Location History (IMLOCHST) Table?
      145. Feature - Prevent Excel from Dropping Leading Zeroes in CSV Item Number Field
      146. Feature - Add User ID to User Defined CSV Export
      147. Feature - User Defined CSV Export Item Batch Support
      148. Feature - Export Inventory TRX Audit Trail to CSV
      149. Feature - Add User-Defined Code Table Support in IM User-Defined CSV Export
      150. Feature - Added “Item 1st Received Date Range” Criteria to Item User Defined CSV Export
      151. How to Get a List of Items That Does Not Have GTIN Code Defined
      152. Feature - User Defined CSV Export Quantity Sold by Customer#, Customer Type or Customer Group
      153. Feature - Added inKit (IK) and inBOMP (IB) Column Types to the User-Defined CSV Report
      154. Feature - Added Phantom Locking to Item File Maintenance
      155. Feature - Added CSV Support to the Physical Count Posting Update Edit List and the Variance Report By Item/Warehouse
      156. Feature - Inventory Transfer Management Batches Using CSV Import
      157. Limitations for Inventory Aging Report
      158. Feature - ATP Inquiry Number of Days from Today
      159. Feature - Added Report to "Set TRX Audit File Beginning Balances"
      160. Feature - Added Product Category Selection Range to ABC Analysis Reports
      161. Feature - Added Days out of stock (DOS) column to the Location History Information, Sales Desk Info - screen.
      162. Feature - Show Turn Over Ratio (TOR) in Stock Status Inquiry

      Feedback and Knowledge Base