Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Amount in words
Microsoft Dynamics NAV (Archived)

Amount in words

(0) ShareShare
ReportReport
Posted on by Spsanthu 205

Hi,

How will it come "amount in words " in reports 2013

In my requirement grand total should be appear in words

Please guide me

Thanks & Regards

santhosh

*This post is locked for comments

  • Suhail Profile Picture
    Suhail 140 on at
    RE: Amount in words

    NAV 2017

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Amount in words

    Till the first version of NAV its a very common procedure meet such requirements and that is to use CHECK Reports - 1401.

  • Suhail Profile Picture
    Suhail 140 on at
    RE: Amount in words

    Thanks for the code but when i try to save it and compile it gave this error :Type conversion is not possible because 1 of the operators contain an Invalid Type Char = Code in :

    IF number <> 0 THEN numString := OnesText[number];

  • Suggested answer
    Tina Menezes Profile Picture
    Tina Menezes 2,576 on at
    RE: Amount in words

    Hi,

    You can refer my blog on the procedure to display amount in words in a NAV report using the below link.

    https://tinamenezesdynamicsnavblog.wordpress.com/2017/09/10/procedure-to-display-the-amount-in-words-in-a-report-of-microsoft-dynamics-nav/

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Amount in words

    Sure, that is the ultimate direction to follow for full utilization of the function.

    Regards.

    Daniel

  • ManishS Profile Picture
    ManishS 78 on at
    RE: Amount in words

    Have you defined the decimal numeric description in currency master for each currency.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Amount in words

    Original code from Jonathan Archer is a master piece, but does not work with figures that have decimal places, so if i put in a non integer figure it breaks. It also does not work with values of more than 1000. Modified code, pasted above solves these mentioned issues, as well as show the decimal value in words.

    The FormatNoText function in nav does not convert the decimal places of the given value to words, only the integer value is converted to words.

  • ManishS Profile Picture
    ManishS 78 on at
    RE: Amount in words

    It better you check report 1401 Check.

    This is a standard report you can use, you just need to pass the amount which you need to be converted to words.

    FormatNoText(DescriptionLine,CheckLedgEntry.Amount,BankAcc2."Currency Code");

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Amount in words

    Refer : Mr Jonathan Archer

    community.dynamics.com/.../numbers-to-words

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Amount in words

    Check this blog

    blogs.anandnavconsultant.com/.../how-to-convert-amount-in-words-in.html

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans