mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 3:01 am

View unanswered posts | View active topics


Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » NAV/Navision Classic Client

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
  What's this MUID? [MUID:WINA] Previous topic | Next topic 
Author Message
r-p
 Post subject: Amount in Words - Decimal doesn't appear
PostPosted: Sun Feb 19, 2012 11:04 pm 
Offline

Joined: Wed Dec 14, 2011 6:50 pm
Posts: 27
Country: Portugal (pt)
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.
Top
 Profile E-mail  
 
ssingla
 Post subject: Re: Amount in Words - Decimal doesn't appear
PostPosted: Mon Feb 20, 2012 10:56 am 
Offline

Joined: Thu Dec 08, 2005 9:12 am
Posts: 2870
Location: India
Country: India (in)
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.in

Top
 Profile E-mail WWW  
 
r-p
 Post subject: Re: Amount in Words - Decimal doesn't appear
PostPosted: Mon Feb 20, 2012 12:52 pm 
Offline

Joined: Wed Dec 14, 2011 6:50 pm
Posts: 27
Country: Portugal (pt)
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.
Top
 Profile E-mail  
 
chengalasettyvsrao
 Post subject: Re: Amount in Words - Decimal doesn't appear
PostPosted: Mon Feb 20, 2012 1:20 pm 
Offline

Joined: Wed Aug 12, 2009 10:33 am
Posts: 709
Country: India (in)
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.
Top
 Profile E-mail  
 
r-p
 Post subject: Re: Amount in Words - Decimal doesn't appear
PostPosted: Mon Feb 20, 2012 1:26 pm 
Offline

Joined: Wed Dec 14, 2011 6:50 pm
Posts: 27
Country: Portugal (pt)
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:2
Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 

Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » NAV/Navision Classic Client

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: Google [Bot] and 10 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to:  
cron