SAP Knowledge Base Article - Public

2470780 - Tax Base Amount Differs from Net Amount in VAT/Sales Tax Items Report

Symptom

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

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

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 General Ledger work center
  2. Under Common Tasks, click Edit Exchange Rates

Resolution

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

Keywords

KBA , AP-PRP , Purchase Request Processing , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP Business ByDesign 1702