Howdy, Stranger!
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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Account Schedule Problem - You have entered an illegal value
fmhigue
Member Posts: 290
I am having a strange problem with one of my Accounts Schedules. Account Schedule works properly on the Native database but it does not on the SQL database that we are currently testing.
Let me give you the facts.
* Currently I am working with NAV 5.0 SP1 (My objects are from 3.10 I just update the EXE file) on the Native Database.
* Account Schedule has 1322 lines.
* It is the PL Statement.
Account Schedule shows the following error message:
"You have entered an illegal value or a nonexisting row number.
The error occurred when the program tried to calculate: Acc. Sched. Line Row No. =126000, Line No.=4430000, Totaling=26000..1240000
Acc. Sched. Column: Column No=300, Line No = 5000.
The strange part here is that If I delete that particular line on the account schedule it works without problems. Or If I decrease the range it also works.
Any ideas? Are there any limitation on the ranges on SQL?
Thank you in advance.4
Let me give you the facts.
* Currently I am working with NAV 5.0 SP1 (My objects are from 3.10 I just update the EXE file) on the Native Database.
* Account Schedule has 1322 lines.
* It is the PL Statement.
Account Schedule shows the following error message:
"You have entered an illegal value or a nonexisting row number.
The error occurred when the program tried to calculate: Acc. Sched. Line Row No. =126000, Line No.=4430000, Totaling=26000..1240000
Acc. Sched. Column: Column No=300, Line No = 5000.
The strange part here is that If I delete that particular line on the account schedule it works without problems. Or If I decrease the range it also works.
Any ideas? Are there any limitation on the ranges on SQL?
Thank you in advance.4
0