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

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

• Is There an AP Vendor Audit Trail Feature?

  Release Date: 12/8/2022 Version: 7.5 & Up Q - Do we have a Vendor Audit feature in Elliott on Add and Change? A - Yes, we do. But you need to make sure the feature is turned on in Accounts Payable -> Utility -> A/P Setup. The following flag need to ...

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