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
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