mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 5:55 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Amount In Words in Posted Invoice
PostPosted: Thu Jun 21, 2012 10:48 am 
Offline

Joined: Sun Mar 21, 2010 7:52 am
Posts: 204
Country: United Arab Emirates (ae)
Dear Experts,


I am looking to print the total amount of posted invoice to be displayed in words.

Is there any way to do that???

We are already using this kind of functionality for Checks and it's converting into Words using report 1401.

So can i use that in Posted Sales Invoice print out??

Please let me know the steps if it's possible to do that as i am not a very good programmer but i have my testing database i will test it there first.

Please let me know how can i do this?


Top
 Profile E-mail  
 
 Post subject: Re: Amount In Words in Posted Invoice
PostPosted: Thu Jun 21, 2012 11:07 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4224
Location: New Delhi
Country: India (in)
http://lmgtfy.com/?q=amount+in+words+navision

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: Amount In Words in Posted Invoice
PostPosted: Thu Jun 21, 2012 11:08 am 
Offline

Joined: Mon May 18, 2009 6:36 am
Posts: 792
Location: India
Country: India (in)
Call the function FormatNoText(defined in report 1401) and pass relevent parameter and get the value in first parameter. Do not forget to round the amount in max 2 decimal before calling this function.

_________________
Vijay Gupta
Changing the code is last step. Try to change processes first...


Top
 Profile E-mail  
 
 Post subject: Re: Amount In Words in Posted Invoice
PostPosted: Thu Jun 21, 2012 12:58 pm 
Offline

Joined: Sun Mar 21, 2010 7:52 am
Posts: 204
Country: United Arab Emirates (ae)
Dear Vijay,

thanks for replying. Could u also please tell me under which trigger of the report do i have to mention the code??


Top
 Profile E-mail  
 
 Post subject: Re: Amount In Words in Posted Invoice
PostPosted: Thu Jun 21, 2012 4:54 pm 
Offline

Joined: Mon May 18, 2009 6:36 am
Posts: 792
Location: India
Country: India (in)
You can write the code on section where are you want to print it.

_________________
Vijay Gupta
Changing the code is last step. Try to change processes first...


Top
 Profile E-mail  
 
 Post subject: Re: Amount In Words in Posted Invoice
PostPosted: Sun Jun 24, 2012 1:12 pm 
Offline

Joined: Sun Mar 21, 2010 7:52 am
Posts: 204
Country: United Arab Emirates (ae)
Alright!

thank you very much for your time!!:)


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 5 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: