AX / Dynamics 365 For Finance and Operations blog

AX / D365FO – Convert an amount into an amount with fixed 2 decimal places after the comma using NUMBERFORMAT() in Electronic reporting

In Electronic reporting if you want to convert an amount into an amount with fixed 2 decimal places after the comma you can use NUMBERFORMAT function

Here is an example

NUMBERFORMAT(model.Payments.InstructedAmount, "#.00")

If the amount is 12.3 then the result will be 12.30

If the amount is 12 then the result will be 12.00

More Posts

One response to “AX / D365FO – Convert an amount into an amount with fixed 2 decimal places after the comma using NUMBERFORMAT() in Electronic reporting”

  1. Ankit Avatar
    Ankit

    How can we get temp table amount in Electronic reporting. Like in vendor payment journal, i have withholding tax amount which is in temp table. I need this amount in my payment report. Any suggestions.

    Like

    Reply

Leave a reply to Ankit Cancel reply