Covert Number to Words

Madhan
Member Posts: 96
Great Day All,
I would like to know, if there is any method of coverting number to words in Navision, which takes care of various currency formats.
Right now, i am using check report (FormatNoText Fuction), which takes care of coverting only in the case of Local currency.
But, in the case of different currency, how to do?
Example:
100.20 INR = One Hundred Rupees and Twenty Paise Only.
100.20 USD = ?
I would like to know, if there is any method of coverting number to words in Navision, which takes care of various currency formats.
Right now, i am using check report (FormatNoText Fuction), which takes care of coverting only in the case of Local currency.
But, in the case of different currency, how to do?
Example:
100.20 INR = One Hundred Rupees and Twenty Paise Only.
100.20 USD = ?
0
Comments
-
I don't think there is, but you could write one.
you need to split the 100 and .20 and call FormatNoText Function twice. Then you need a field to the currency table for the cents description (Paise)
The code would look like thisCurrency.get("Currency code"); MyAmount := 100; MyAmountText := formatNoText(MyAmount); MyDecimal := 0.20; MyDecimalText := formatNoText(MyAmount); TextToPrint := MyAmountText + ' ' + Currency.Description + ' ' + MyDecimalText + ' ' + Currency."Decimal Description"
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