Inventory Valuation Report seems extra slow

SmokeScreen

Is there anything that can be done to speed up the Inventory Valuation report? I never "timed" it before, but it seems as though the report is now running much slower. I seem to remember running a 60 page report in a few minutes (8) as opposed to it now generating a page every 90 seconds... any ideas on anything that can be done?

Savatage

With every Item Ledger Entry the report will get slower & slower.

I don't even try to run it during the day. If I need the whole report I run it before I leave at night so it's ready by the morning.

SmokeScreen

Thanks Harry, I did just that. Ran it and went home. Not enough time to worry about a report...

ara3n

here is a link on how to run this from sql

http://mibuso.com/blogs/ara3n/2009/07/0 ... amics-nav/

You can run it also from Nav using ADO.

ewhamond

I realize this is very old but the blog link that ara3n included is not valid. Is there more info on how to do this?

rmv_RU

Read this post:
http://forum.mibuso.com/discussion/comment/285905/#Comment_285905