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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
Overflow error converting numeric to data type money
intelcore2quad88
Member Posts: 7
Hello everyone,
I have report which get Data by Query SQL using ADO in Navision 2009 R2.
If you want to get decimal value in Query SQL, you need to CAST decimal to Money before passing value to Navision, if you don't cast value to Money, you will get error like that:
This data type is not supported by C/SIDE. You can access data from
any of the following data types:
VT_VOID, VT_I2, VT_I4, VT_R4, VT_R8, VT_CY, VT_DATE, VT_BSTR and VT_BOOL
But, today I have problem with amount in G/L Entry: 14,138,211,287,616,041, this is overflow datatype Money (Maximum is: +/- 999,999,999,999,999.99)
I have idea to Cast value to varchar, and in NAV, I will Evaluate it to Decimal variable, but when evaluate value, I still get error with overflow: 999,999,999,999,999.99
I try testing one case: delete amount 14138211287616041 in G/L Entry, and paste 14138211287616041 to table again. When paste value, I will get error:
Can everyone help me to resolve this issues?
Thanks.
I have report which get Data by Query SQL using ADO in Navision 2009 R2.
If you want to get decimal value in Query SQL, you need to CAST decimal to Money before passing value to Navision, if you don't cast value to Money, you will get error like that:
This data type is not supported by C/SIDE. You can access data from
any of the following data types:
VT_VOID, VT_I2, VT_I4, VT_R4, VT_R8, VT_CY, VT_DATE, VT_BSTR and VT_BOOL
But, today I have problem with amount in G/L Entry: 14,138,211,287,616,041, this is overflow datatype Money (Maximum is: +/- 999,999,999,999,999.99)
--------------------------- Microsoft Dynamics NAV Classic --------------------------- This message is for C/AL programmers: The call to member Execute failed. Microsoft OLE DB Provider for SQL Server returned the following message: Arithmetic overflow error converting numeric to data type money. --------------------------- OK ---------------------------
I have idea to Cast value to varchar, and in NAV, I will Evaluate it to Decimal variable, but when evaluate value, I still get error with overflow: 999,999,999,999,999.99
--------------------------- Microsoft Dynamics NAV Classic --------------------------- Decimal must not be 14138211287616041. Decimal must be in the range of -999,999,999,999,999.99 - 999,999,999,999,999.99. --------------------------- OK ---------------------------
I try testing one case: delete amount 14138211287616041 in G/L Entry, and paste 14138211287616041 to table again. When paste value, I will get error:
--------------------------- Microsoft Dynamics NAV Classic --------------------------- Decimal must not be 14138211287616041. Decimal must be in the range of -999,999,999,999,999.99 - 999,999,999,999,999.99. --------------------------- OK ---------------------------I don't know how NAV store value to table when it is overflowed.
Can everyone help me to resolve this issues?
Thanks.
0
Comments
First of all you have check data type of both fields they should be contain decimal values.
First of all you have to check data type of both fields they should be contain decimal values.