web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic reporting c...
Finance | Project Operations, Human Resources, ...
Answered

Electronic reporting convert number to words

(3) ShareShare
ReportReport
Posted on by Hichem Aouini 58
greeting everyoen 
i want to cinvert number to words in ER but i have prb
the function that i use convert only numbers before ' , '
if i have real number 753.82 
he convert  tike this  ->  spt cent cinquante-trois et 82 

his not converting 82 

this is the function

numeralstotext(invoiceAccount,"FR-FR","",false,2)
Categories:
Dynamics 365 Finance
I have the same question (1)
  • Martin Dráb Profile Picture
    Martin Dráb 237,662 Most Valuable Professional on at
    Electronic reporting convert number to words
  • Adis Profile Picture
    Adis 6,025 Super User 2025 Season 2 on at
    Electronic reporting convert number to words
    Hi,
     
    When I compare the formula from learn to yours, I see that you ve chosen "invoiceAccount", I guess it should be invoiceAmount. 
    I would hard code a number first in the formular, just to check if it works and then change it to the field invoiceAmount.
     
    NUMERALSTOTEXT (1234.56, "EN-US", "", false, 2)
     
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • Hichem Aouini Profile Picture
    Hichem Aouini 58 on at
    Electronic reporting convert number to words
    in my code i put it invoiceamount
    it's wrong only here 

    and i found the solution 

    thnx 

    but this 
    NUMERALSTOTEXT (1234.56, "EN-US", "", false, 2)
    will always change the 1234 not 56
  • Adis Profile Picture
    Adis 6,025 Super User 2025 Season 2 on at
    Electronic reporting convert number to words
     
    Could you share with us your solution?
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • Verified answer
    Hichem Aouini Profile Picture
    Hichem Aouini 58 on at
    Electronic reporting convert number to words
    hi @Adis 
    this is my solution 


     
    REPLACE(
        CONCATENATE(
            NUMERALSTOTEXT(ROUND(@.invoiceAmount - 0.5, 0), "FR-FR", "", false, 0),
            " et ",
            NUMERALSTOTEXT(ROUND((@.invoiceAmount - ROUND(@.invoiceAmount - 0.5, 0)) * 100, 0), "FR-FR", "", false, 0)
        ),
        " et 00",
        "",
        false
    )



    result :

    <Amount currencyIdentifier="TND">21114.24</Amount>
    <AmountDescription lang="fr">Vingt un mille un cent quatorze et Vingt quatre</AmountDescription>

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 724 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 619 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 400 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans