You are running the All VAT/Sales Tax Items with Journal report, however the Net Amount (Company Currency) differs from the Tax Base Amount (Tax Return Currency).
Reproducing the Issue
- Go to Tax Management work center
- Go to List view
- Open report All VAT/Sales Tax Items with Journal
- Execute the report with the relevant selection criteria.
You'll see that for a given invoice, the Net Amount (Company Currency) differs from the Tax Base Amount (Tax Return Currency).
The invoice has been created in a foreign currency. Nevertheless, the system used different exchange rates to convert the tax base amount.
The Tax Date on the invoice has been overridden and differs from the journal entry's posting date, hence the system used the Tax Date for currency conversion on tax base amount and tax calculation. In this case, there are different exchange rates for the posting date and tax date.
The exchange rates can be checked as follows:
- Go to General Ledger work center
- Under Common Tasks, click Edit Exchange Rates
It is the designed behavior the system to use the tax date for tax currency conversions. In order to ensure that same exchange rate is used, you have to make sure that the posting date and tax date is the same
KBA , AP-PRP , Purchase Request Processing , How To