You’re offline. This is a read only version of the page.
60
We have approximately 1000 items in inventory. I ended up running the report in blocks of 100 item numbers at a time, and it took anywhere from 10 minutes to almost 1.5 hours depending upon how many active items there were in that particular block.
Is this the type of report that once it is run the first time, it will run quicker on subsequent requests?
Thanks in advance for any help!
*This post is locked for comments
I have the same question (0)
Hello,
Thank you for posting your inquiry to the Dynamics Communities.
The HSSR report looks at the inventory transaction tables (IV30300, IV30301 etc.) to pull the information that will be printed in the report. If you put in an as of date, what the system does is look at all the records in the tables and backs out all the transactions since the as of date. So in short we query the entire table to get a full set of results and then take off what we do not need.
The HSSR it does have performance issues with large data sets and this is because of all the calculations that have to be done to get us back to the As Of date that is chosen when running the report. Because if the performance issues the Historical Inventory Trial Balance (HITB) was created. Have you looked at implementing HITB?
If you run the following queries do you get results that are around a million records? If so I would anticipate performance issues and suggest you look at using the HITB report.
select COUNT(*) from IV30300
select COUNT(*) from IV30301
I hope this information is helpful to you. Please post back if we can be of further assistance.
Have a great day!
Share
Report
All responses (
Answers (
