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

Compuoso
Member Posts: 2
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.
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.
0
Comments
-
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.0 -
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.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
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?Tomas,
Dynamics NAV Enthusiast0 -
Nope... You can speed it up a little bit in SQL version, but not much changed...Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions