Hello,
I have a Product Value Report as at date which I run on my SQL Database (via my accounting software) which gives me the location value of stock as at a date.
One issue I have with the report is that the more transactions and warehouses you have in the database the longer the time taken to produce the report.
I’m wondering if anyone would know how to speed up the report for me if possible?
Attached is an example with saved data.
Thank you.
QuantityValuebyLocationAsAt.rpt