SAP Knowledge Base Article - Public

2470780 - Tax Base Amount Differs From Net Amount in VAT/Sales Tax Items with Journal report

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

  1. Go to the Tax Management work center.
  2. Go to the List view.
  3. Open report All VAT/Sales Tax Items with Journal.
  4. 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:

  1. Go to the General Ledger work center.
  2. 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

Product

SAP Business ByDesign all versions