Problem description

Hungary: Online invoicing system - <exchangeRate> tag’s value must report currency exchange rate from the CurrencyCode of the invoice to CurrencyCode in the TaxCode of the first tax transaction of the invoice on Date of VAT register of the invoice

Hotfix information

To resolve the issue, you need to import the following or a higher version of the ER configurations from LCS shared asset library:

  • Invoices Communication Model.version.61.xml

  • RTIR Invoice Data (HU).version.61.29.xml

  • RTIR mapping.version.61.58.xml

 

Fix downloading instructions are here:

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/download-electronic-reporting-configuration-lcs

Fix description

This hot fix provides the following algorithm of exchange rate identification:

Definitions:

A = CurrencyCode of the invoice (for example EUR or HUF)

B = CurrencyCode in the TaxCode of the first tax transaction of the invoice {it is supposed that all tax transactions by the same invoice must have the same CurrencyCode in related tax codes setup} (for example HUF)

Algorithm:

IF A = B

THEN exchangeRate = “1

ELSE exchangeRate = Currency exchange rate of the type defined as “Accounting currency exchange rate type” in the Ledger setup from A to B on the Date of VAT register of the invoice

 

With this change to avoid potential “INCORRECT_SUMMARY_DATA_INVOICE_VAT_AMOUNT_HUF” warning (p.206 of “Invoice Data Reporting, Description of the REST API Interface & Developer’s Documentation”) which is described as following:

“Issues a warning if the output VAT amount in the aggregate invoice in the invoice’s currency and the VAT amount in HUF do not correspond based on the exchange rates indicated in the line items.  Calculation: in the case of currencyCode<>”HUF”, the VAT amount in each line item (lineVatAmount) must be multiplied by the exchange rate value in the line item (lineExchangeRate), and the total of these products amounts to the invoice VAT amount in HUF (invoiceVatAmountHUF).  Tolerated deviation: 1% of the invoiceVatAmountHUF element, but at least 1 unit.”

calculation of the following tags’ values is also changed respectively:

- <lineVatAmountHUF> is calculated as <lineVatAmount> multiplied by exchangeRate

- <vatRateVatAmountHUF> is calculated as <vatRateVatAmount> multiplied by exchangeRate

- <invoiceVatAmountHUF> is calculated as <invoiceVatAmount> multiplied by exchangeRate

Be aware: reported values in <lineVatAmountHUF>, <vatRateVatAmountHUF>, <invoiceVatAmountHUF> tags may differ from the values stored in the tax transactions in some cases due to following reasons:

-          Exchange rate on transaction date and exchange rate on Date of VAT register are different.

-          Accounting currency and currency defined for the sates tax code are different and triangulation exchange rate (which used on posting: document currency > accounting currency > tax code currency) on posting moment may differ from the exchange rate from document currency to tax code currency on Date of VAT register.

These aspects should be under user control and may require corrective tax transactions.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×