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.
-
Avi Weissbard - Cybermac software LLC
commented
Also as we know the report is driven by the date of the transaction and not the document date. If Netcellent is making a change maybe the Doc Date can be used as an alternate key to allow selection by document date. Currently users make a wider range and filter the output in order to get information by doc date.