Slow reports, especially the "Inventory to G/L Reconcil

Compuoso

We are running Navision Attain 3.6 with the Microsoft SQL Server (2000 STD ED) Option. The OS is Windows Server 2003 and the hardware is an HP Proliant DL560 G1 with great specs, including dual processors, 4 GB RAM (2 GB dedicated to SQL), multiple hard drives in more than one RAID 1 configuration, and with the database and transaction logs on separate disks.

Yet, our Navision users constantly complain that it is "too slow," especially when they run reports. One report, in particular, the "Inventory to G/L Reconcile" report (Report 10138), takes 2 to 3 hours to run regardless of whether it is executed with Navision client software installed on a workstation, in our Citrix environment, or on the server itself! It doesn't even help to log everyone off the server except the handful of people running the "Inventory to G/L Reconcile" report.

We would appreciate hearing from anyone else that is experiencing these kinds of performance issues, especially those of you who have resolved them.

Savatage

Some reports are just HUGE. Especially if they have to gather thousands & thousands of entries.

I don't even dare even run Inventory Valutaion report anymore.

If I have to I'll start it at the end of the day on friday and get the results when I come in on monday.

Alex_Chow

Yeah, the inventory to g/l reconcile and inventory valuation reports takes a very long time to print. It's especially frustrating during month end when you're trying to gather all the reports together.

I really hope something can be done about this in the future version of Navision.

Tomas

This topic was created on 2006. Any improvements yet?

At the moment I am looking at the Inventory Valuation report and trying to figure out if there is any way of improving the speed of the report.

From posts in this forum, I have realized that date compression probably will not help.

Any other ideas?

Alex_Chow

Nope... You can speed it up a little bit in SQL version, but not much changed...