We make invoices in other currency too.
We have problem with the VAT Analytics.
Everywhere in the tables is the base amount and the VAT amount correct both in legal currency and other currency. (G/L entry table T17, Customer Ledger entry tableT21, VAT entry T254).
When we make a standard VAT Analytics report, the report does not take the legal currency amounts from the tables. It is recalculated form other currency amount with the exchange rate on the posting date.
We book the legal currency from the other currency on the VAT fulfilment date.
So there is a difference beetwen the booked VAT amount and the VAT analytics report.
Is this a customizing problem or we need to change the code of the VAT analytics report?
Thanks for every help.