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

CSV fields that will be exported:

ItemNo
Desc1
Desc2
Loc
Type
Doc#
TrxDate
TrxTime
DocDate
Src
TrxQty
TrxCost (optional based on flag)
NewQtyOH
Cus/Ven
Order#
User
RefDocNo
DistType (optional based on flag)
Comment (Optional Based on flag)

To export  inventory transaction audit trail report data to a CSV file, enter "Y" in "Export to CSV File?",

then enter a valid file name and path in "CSV File Name & Path."

Programs changed: IM04S2.CBL, IM04P2.CBL

DLM

• Related Articles

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

• IM2700 Inventory Management Set Trx Audit File Beginning Balances

  Set Trx Audit File Beginning Balances Application Overview The Set Trx Audit File Beg. Balances application should be run at the very end of every period to set a beginning balance for all stocked items for the next period. This balance will be ...

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

• IM02S2 Inventory Management Inventory Location Audit Trail Report

  Inventory Location Audit Trail Report Application Overview The Inventory Location Audit Trail Report shows transactions that have taken place against an inventory item in any location entered during the Inventory Location File Maintenance ...

• Feature - Added a Function "Create Inventory Trx CSV Import"

  Release date: 12/29/2016 Updated: 2/21/2017 Updated: 4/25/2017 Updated: 5/2/17 Added a function to IM / Maintenance / Item file / Create / Create Inventory Trx CSV Import to automate the receipt of inventory items thru returned inventory. This ...