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 stored in the registry and will be used as defaults if found.

Fields exported:

ItemNo 

Desc1 
Desc2 
Date 
Time 
User 

Action (Add, Before Change, Change or Delete)
Loc 
QtyOH 
QtyAlloc 

AvgCost 
LastCost 
StdCost 
ItemPrice 
CommType 

CommPctAmt 
SalePrice 
StartSaleDate 
EndSaleDate 
ActCode 
Stocked 
Controlled 
SubstItemNo 

When printing the Change record, ItemNo, Desc1, Desc2, Date, Time, User, Action and the actual fields that changed will be added to the CSV line.

Modified Programs: IM01S3, IM01P3

DLM

• Related Articles

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

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

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

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

• Feature - Support Product Category, User-Defined Code and Material Type in Item Audit Master

  Release Date: 12/14/22 Version: 8.5 and Above This feature adds support for the product category, user-defined code, and material cost type to the item audit trail. Item Master additions, changes, and deletions will record data from these fields in ...