Dynamics Community Forum Thread Details

How long should it take for the Summary Historical Stock Status report to run?

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.

GP 2010 (Literally just went live two weeks ago; all updates are current)
Except for item numbers all ranges were First to Last
Sorted by: Site Id (We assign each tech a Site; about 60-70 sites total)
Only implemented Inventory module on 6/30/10 (in GP9.0)
Tried running on multiple machines with similar results
Windows 7

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!

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!

Quick Links

Leaderboard