Decimal places for combined field

Mindie

On the Sales Invoice there is a field defined as:

'$' + FORMAT(TempSalesInvoiceLine."Amount Including Tax")+ ' '+CurrencyPrefix

This ignores the decimal properties setup for the field. Because it is the total field for the sales invoice it needs to have a fixed length 2 decimal places (2:2). The field is currently acting like a 0:2. It is not showing the decimal places for whole number.

How can I correct this?

Thanks in advance

Xypher

'$' + FORMAT(TempSalesInvoiceLine."Amount Including Tax",0,'<Sign><Integer Thousand><Decimals,3>')+ ' '+CurrencyPrefix

If you don't want the amount displaying a comma ',' if the value exceeds 3+ digits just replace <Integer Thousand> with <Integer>

Mindie

Thank you. That worked perfectly!