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.