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

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

• 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 - Add Desc2 Column to Item Linkage CSV Report

  Release Date: 4/19/2017 In I/M -> Reports -> Item Linkage CSV Report, the Desc2 column is now added to the exported CSV file. See sample screen below. The following columns are supported in the CSV file: Item# - Item number Desc - Item description 1 ...

• EMPAUD Payroll Employee Audit Trail Report

  Reports Employee Audit Trail Report Application Overview The Employee Audit Trail Report application enables you to track changes made to sensitive payroll data entered into the change mode of the Employee File. In order to obtain an audit trail ...

• CP07S1 Customer Order Processing Backorder Audit Trail Report

  Backorder Audit Trail Report Application Overview The Backorder Audit Trail Report displays transactions of the automatic and manual backorders that have been filled. If you select Backorder Audit Trail Report, a screen will display upon which ...