Improve Inventory Transaction Audit Trail Report Performance If Selection by Date Range

Improve Inventory Transaction Audit Trail Report Performance If Selection by Date Range

If user choose to print Inventory Transaction Audit Trail Report for All Items of a single date range, the report can for run a long time as if it is stuck. See attached example. General speaking, user will get good performance if they select for specific item number range. Running this report on PSQL server directly will be much faster. Also, purge older inventory trx audit trail records will also help to speed up the report. Netcellent recommend keeping inventory trx audit trail database for 3 years of history. It is suggested that Netcellent should optimize this report's performance even if users select ALL items for a specific date range as in the attached example.

The following post was created by Edward M. Kwang from NETcellent System, Inc. on 2/6/2021 in our old Knowledge Base.