Amount in Words - Decimal doesn't appear

r-p
Member Posts: 33
Hello,
I have converted amount in words, using formatnotext.
when the payment is made in EUR, i get the amount receipt in words correctly.
But if the payment is made in US or MZM, i get the amount receipt in words but the decimal not.
ex: 1460,54
in euros: a get the words correctly
in US and MZM get: one thousand four hundred sixty dollars and one cents(underline is incorrect)
Can someone help me.
Thanks.
I have converted amount in words, using formatnotext.
when the payment is made in EUR, i get the amount receipt in words correctly.
But if the payment is made in US or MZM, i get the amount receipt in words but the decimal not.
ex: 1460,54
in euros: a get the words correctly
in US and MZM get: one thousand four hundred sixty dollars and one cents(underline is incorrect)
Can someone help me.
Thanks.
0
Comments
-
If all the 3 currencies mentioned are FCY then check the values in Currency table. If the setups are correct then try to debug the function used for conversion and try to find the difference in calculation.CA Sandeep Singla
http://ssdynamics.co.in0 -
ssingla wrote:If all the 3 currencies mentioned are FCY then check the values in Currency table. If the setups are correct then try to debug the function used for conversion and try to find the difference in calculation.
Can you help me by saying where can i check if the 3 currencies mentioned are FCY.
Can you be i little more specific about the all process you describe.
Thanks.0 -
r-p wrote:
Can you help me by saying where can i check if the 3 currencies mentioned are FCY.
Can you be i little more specific about the all process you describe.
what Sandeep meant to say is, check Amount Rounding precision and Amount decimal places fields for those currencies in the currency table.0 -
chengalasettyvsrao wrote:r-p wrote:
Can you help me by saying where can i check if the 3 currencies mentioned are FCY.
Can you be i little more specific about the all process you describe.
what Sandeep meant to say is, check Amount Rounding precision and Amount decimal places fields for those currencies in the currency table.
I have in Currency table:
Amount Round Prec. Amount Decimal Places
Euro : 0,01 2:2
Dolar: 0,01 2:2
MZM: 0,01 2:20
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