Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Export to Excel from Account Schedule Overview
Lee14
Member Posts: 5
Issue…
The Export to Excel functionality in the GL Account Schedule Overview is very, very slow on one of my client's workstations. Other client sites have the normal drop-off associated with client vs server comparison, but this site takes 15 minutes to export to excel from Account Schedule Overview.
Current Work-around…
Client uses remote desktop to server to perform this Export to Excel function.
But their IT staff is complaining about lack of controls, etc…
Question…
Has anyone such a large difference in performance when using Export to Excel functionality?
Or have any recommendations on how to improve performance?
Environment…
Client PC: Server
OS XP Pro – SP2 Small Business Server 2003 – 5.2 build 3790 SP1
MS Office 2007 2002 (10.2614.2685)
RAM 3 mg 4 mg
NAV version 5.0 SP1 Build 26084
Object
Cache 64000 32000
Tests…
I performed a Print Preview and an Export to Excel operation on the following NAV reports and the Account Schedule Overview on both the Client PC and the NAV Server environment.
I also traced the network flow by testing the ping of the network and did not notice any degradation of performance.
RESULTS...
Preview
NAV Report Client Time Server Time
GL Trial Balance (4 pgs) 30 sec 10 sec
AR Aging (3 pgs) 30 sec 10 sec
AP Aging (3 pgs) 30 sec 10 sec
Acct Sched.
Overview (700 rows) 3 minutes 30 sec
Export to Excel
Client Time Server Time
GL Trial Balance (4 pgs) 3 min 20 sec
AR Aging (3 pgs) 3 min 20 sec
AP Aging (3 pgs) 3 min 20 sec
Acct Sched.
Overview (700 rows) 15 minutes 1 minute
The Export to Excel functionality in the GL Account Schedule Overview is very, very slow on one of my client's workstations. Other client sites have the normal drop-off associated with client vs server comparison, but this site takes 15 minutes to export to excel from Account Schedule Overview.
Current Work-around…
Client uses remote desktop to server to perform this Export to Excel function.
But their IT staff is complaining about lack of controls, etc…
Question…
Has anyone such a large difference in performance when using Export to Excel functionality?
Or have any recommendations on how to improve performance?
Environment…
Client PC: Server
OS XP Pro – SP2 Small Business Server 2003 – 5.2 build 3790 SP1
MS Office 2007 2002 (10.2614.2685)
RAM 3 mg 4 mg
NAV version 5.0 SP1 Build 26084
Object
Cache 64000 32000
Tests…
I performed a Print Preview and an Export to Excel operation on the following NAV reports and the Account Schedule Overview on both the Client PC and the NAV Server environment.
I also traced the network flow by testing the ping of the network and did not notice any degradation of performance.
RESULTS...
Preview
NAV Report Client Time Server Time
GL Trial Balance (4 pgs) 30 sec 10 sec
AR Aging (3 pgs) 30 sec 10 sec
AP Aging (3 pgs) 30 sec 10 sec
Acct Sched.
Overview (700 rows) 3 minutes 30 sec
Export to Excel
Client Time Server Time
GL Trial Balance (4 pgs) 3 min 20 sec
AR Aging (3 pgs) 3 min 20 sec
AP Aging (3 pgs) 3 min 20 sec
Acct Sched.
Overview (700 rows) 15 minutes 1 minute
0