Feature - Hold Transaction Auditing Log File

Feature - Hold Transaction Auditing Log File

Release Date: 9/16/26
Version: 8.5 and Above

This new feature will generate an entry in a CSV log file whenever an item hold transaction record is added, changed, or deleted. The primary applications that update this table include:
  1. Inventory Management
    1. Maintenance -> Hold Transaction File: Add, change, delete, delete range, and purge (Task ID IMHLTMNT, IMHLTDRP, or IMHLTMNT)
    2. Processing-> Post Inventory Transactions: Allocated receiving distribution type (Task ID IM2402)
  2. Customer Order Processing
    1. Processing-> Order Entry: Allocation relief (Task ID CP0111)
    2. Processing-> Sales Desk: Allocation relief (Task ID CPQUOGEN)
  3. Purchase Order and Receiving
    1. Processing-> Warehouse Receiving Process: Allocated receiving (Task ID POWHRPST)
  4. Bill of Material Processor
    1. Processing-> Production Transaction Processing-> Plus Work Order: Material shortage entries (Task ID SYINVAL3)
The option must first be enabled through Global Setup> System-> Item Hold Processing.



 4. Log File Path & Name (Supports YYMMDD Mask) - Enter the full path and file name for the CSV file. File name supports date masks: YYYYMMDD, YYMM, YY. Max entry length is 41 characters. In case of a conflict when writing to the file, the time stamp and a 3-digit counter will be added to the CSV file name to resolve the conflict.

Typically, this log file path will be a subfolder under <ElliottRoot>\Log\, where all Elliott users will have modify rights if NTFS security is enabled. If not, please make sure all Elliott users have sufficient NTFS permissions for the folder you specified. Otherwise, users who do not have NTFS modify rights to the log file path may encounter errors or even have their sessions lock up.

The CSV file will contain the following columns:

  • Action Date - Date of the action
  • Action Time - Time of the action
  • Action (The possible values can be “A” (Add), “BC” (Before Change), “AC” (After Change) and “D” (Delete) )
  • User-ID - Elliott user ID
  • Task-ID (Which application program that added, changed, or deleted the hold transaction)
  • Hold-Trx-ID - Hold transaction ID
  • Location - Warehouse location
  • Item# - Item number on the hold transaction
  • Serial# - Serial number
  • Hold Type - Hold type such as USR, SLM, BMP, etc.
  • Qty - Transaction quantity
  • Transaction-Date - Original transaction date
  • Transaction-Time - Original transaction time
  • Expiration-Date - Expiration date
  • Expiration-Time - Expiration time
  • Description - Transaction description
  • Email-Address - Notification email address

Here is an an example the of CSV log file:



Programs Modified: IMHLTFIL.WS, IMHLTFIL.IO, NSCTLFIL.FD, NSCTLFIL.W42, NSCTLINI.CBL, NSCTLMN1.CBL, IMHLTMNT.CBL, CP0111.CBL, IMHLTGEN.CBL, IMHLTADD.CBL, CPQUOGEN.CBL, CPBATVER.CBL, CPBATVEB.CBL, IMHLTINQ.CBL, POWHRPST.CBL, SYINVAL3.CBL, IMHLTPUR.CBL, IM2402.CBL
Programs Added: IMHLTCSV.CBL, IMHLTCSV.SL, IMHLTCSV.FD, IMHLTCSV.WS, IMHLTCSV.DS
CLS

    • Related Articles

    • IMHLTMNT Inventory Management Hold Transaction File Maintenance

      Hold Transaction File Maintenance Application Overview This feature allows a user or salesman to reserve, (allocate), items without having to enter an order. Before this feature can be used, it must be defined (setup) in Global Setup System first. ...

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

    • Feature - Order Ship Status Auditing Report

      Release Date - 7/14/16 The Order Ship Status Auditing Report is available under COP -> Processing -> Pick/Pack tickets & Ship Label -> Shipping -> Order Ship Status Auditing Report. The feature gives the user the ability to reconcile EDI orders ...

    • Feature - Order Release Log File

      Release Date - 2/9/16 This new feature will generate an entry in a CSV log file when ever an order is released from hold through COP -> Processing -> Release Held Order. The option must first be enabled through Global Setup -> COP-Ctl -> Credit Check ...

    • Suggested Files to be Monitored by Audit Master

      Last Revised on 7/2/2019 Audit Master is an invaluable tool for the PSQL database. It helps to answer the question "what happened to my data?" For example, during day-to-day operation, if someone delete a sales order, you want to know who did it so ...