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
Desc2
Date
Time
User
Action (Add, Before Change, Change or Delete)
Loc
QtyOH
QtyAlloc
Loc
QtyOH
QtyAlloc
AvgCost
LastCost
StdCost
ItemPrice
CommType
LastCost
StdCost
ItemPrice
CommType
CommPctAmt
SalePrice
StartSaleDate
EndSaleDate
ActCode
Stocked
Controlled
SubstItemNo
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