A/R Aging Array Limit Met

Savatage
Member Posts: 7,142
I guess this is a sign that our internet business is growing but I have just come across an error while running the Account Receivable Aging report that says 10000 outstide the permitted array range.
Now this means we have 1 customer that has over 10,000 OPEN entries.
Noew on the aging report I have increases the 3 or 4 fields starting with "LedgEntryXXXX" dimensions from 9999 to 19999.
The report now runs without crashing - the question is was 9999 just some random number nav put there or is there any reason that anyone knows. Infact I simply added a 1 to make it 19999 but is there a limit say 99999 or more?
Now this means we have 1 customer that has over 10,000 OPEN entries.
Noew on the aging report I have increases the 3 or 4 fields starting with "LedgEntryXXXX" dimensions from 9999 to 19999.
The report now runs without crashing - the question is was 9999 just some random number nav put there or is there any reason that anyone knows. Infact I simply added a 1 to make it 19999 but is there a limit say 99999 or more?
0
Answers
-
You can put more. We had a customer that had the exact same problem.
It's been a while, but I remembered that they put the coding like that for performance reasons. Something like it will loop through all the arrays, so the bigger your array the longer it's going to run.
Nonetheless, I modified the aging report exactly as you did.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