Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Adjust Cost - Item Entries SQL Decimal Overflow error
Veronica
Member Posts: 2
Hi,
My client is running Navision 3.70 on an SQL database.
When we run the Adjust Cost - Item Entries periodic activity we get an SQL decimal overflow error.
I have used debug and determined that it occurs when creating the G/L Entry in Codeunit 12 Gen. Jnl.-Post Line\FinishCodeunit() and is because the Amount is too big. I suspect that there is a problem with the data.
Has anyone else experienced any issues with this, or does anyone have any suggestions as to where I could continue my investigation?
I have searched the Forum and found a paper which suggests that it could be related to the Valuation Date, but specifically for Transfers. I have checked this with our data, and this does not seem to be the case here...
Thanks,
Veronica
My client is running Navision 3.70 on an SQL database.
When we run the Adjust Cost - Item Entries periodic activity we get an SQL decimal overflow error.
I have used debug and determined that it occurs when creating the G/L Entry in Codeunit 12 Gen. Jnl.-Post Line\FinishCodeunit() and is because the Amount is too big. I suspect that there is a problem with the data.
Has anyone else experienced any issues with this, or does anyone have any suggestions as to where I could continue my investigation?
I have searched the Forum and found a paper which suggests that it could be related to the Valuation Date, but specifically for Transfers. I have checked this with our data, and this does not seem to be the case here...
Thanks,
Veronica
Veronica
0
Comments
Overflow error usually occurs then Data from one field size is larger than field it is trying to populate.
Run Debugger again and watch what line of data it is erroring out on. Remember to turn off Breakpoint on Triggers.