Adding VAT in local currency (LCY)

In some countries, it is necessary to add the VAT amount in the local currency when sending a document in a different currency.

You can calculate the VAT in local currency using the Currency Factor. Business Central stores the Currency Factor when posting the document; it has the exchange rate at the date of posting.

To calculate the Currency Factor in FORNAV, you need to add a new textbox control and add the calculation.

VATAmountLine.VATAmount / Header.CurrencyFactor

You can set the rounding using the Format String property of the text box.

The finished result looks like this:

Important note: Calculating VAT using the Currency Factor can give rounding errors in some edge cases. Always check your local legal requirements if this method is allowed. If you need the actual posted amounts, you can also get these amounts through the document VAT entries.