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
Unable to write decimals in quantity
marvinq
Member Posts: 69
Hi,
I have got a mysterious problem.
I have made a asp.net site which creates sales orders and lines in NAV. Everything works just perfect, until I tried to use decimals in my quantity. When decimals are used I get the message that the input string is not i the correct format.
My site is pretty much like this one:
http://blogs.msdn.com/b/freddyk/archive ... d-rtm.aspx
If I replace the following line I get the error...
line1.Quantity = 3;
replaced by:
line1.Quantity = decimal.Parse(tbQuantity.Text);
I have also tried in a more static way, to debug..
line1.Quantity = 3.3m;
..this just sets quantity to 33.
Why?? What is wrong?
I have got a mysterious problem.
I have made a asp.net site which creates sales orders and lines in NAV. Everything works just perfect, until I tried to use decimals in my quantity. When decimals are used I get the message that the input string is not i the correct format.
My site is pretty much like this one:
http://blogs.msdn.com/b/freddyk/archive ... d-rtm.aspx
If I replace the following line I get the error...
line1.Quantity = 3;
replaced by:
line1.Quantity = decimal.Parse(tbQuantity.Text);
I have also tried in a more static way, to debug..
line1.Quantity = 3.3m;
..this just sets quantity to 33.
Why?? What is wrong?
0
Comments
I presume Denmark has a decimal notation similar to the Belgian one. With "." for seperation of thousands and "," for seperation of decimals.
It is best to save your send your quantity through as text and evaluate it with a decimal before putting it in the quantity field of your order.
a handy line of code is available for the conversion variables to replace are in []:
[MyparsableString] := CONVERTSTR([YourQuantityString],'.',DELCHR(FORMAT(0.1),'=','01')))
This part will get the country-specific decimal seperator: DELCHR(FORMAT(0.1),'=','01')
It will replace it with a '.' which in C/AL is always the decimal seperator
|To-Increase|