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

Posted on by Marco Saad

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

Published by Marco Saad

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

  1. 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

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s