Symptom
All VAT/Sales Tax Items with Journal report (Report ID FINTAXU10_Q0001): the Net Amount (Company Currency) differs from the Tax Base Amount (Tax Return Currency).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Tax Management work center.
- Go to the List view.
- Open report All VAT/Sales Tax Items with Journal.
- Execute the report with the relevant selection criteria.
For a given invoice, the Net Amount (Company Currency) differs from the Tax Base Amount (Tax Return Currency).
Cause
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 the General Ledger work center.
- Under Common Tasks, click Edit Exchange Rates.
Resolution
It is the system designed behavior 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.
See Also
FINTAXU10_Q0001; net amount; tax base amount
Keywords
KBA , SRD-FIN-ANA , Analytics Content , How To