Symptom
The same document is opened from Tax Management and General Ledger work centers, but different amounts are displayed.
Environment
SAP Business ByDesign
Reproducing the Issue
From Tax Management:
- Go to the Tax Management work center.
- Select the Tax Return view.
- Select the VAT Return subview.
- Select the relevant VAT return and choose Tax Event.
- Click on Details.
The document shows a Tax Base Amount in Company Currency of XXX.
From General Ledger:
- Go to the General Ledger work center.
- Select the Journal Entries view.
- Find the relevant journal entry for the same document.
The Debit in Company Currency is different from XXX.
Cause
The currency conversion performed by the tax engine differs from the currency conversion used in accounting because different currency conversion settings are maintained.
Tax Management settings:
- Go to Business Configuration work center.
- Select Overview view.
- Find activity Tax on Goods and Services.
- Open the activity and select Currency Conversion Types.
Check the maintained Exchange Rate Type and Conversion Type for the relevant document.
Journal Entry settings:
- Go to Business Configuration work center.
- Select Overview view.
- Find Activity Set of Books.
- Edit the relevant Set of Book and go to Company Settings tab.
- Note the Currency Conversion Profile
- Go to Business Configuration work center.
- Select Overview view.
- Find activity Currency Conversion Profiles.
- Choose the Currency Conversion Profile noted in Step 5.
Under Details: Currency Conv. - Bid/Mid/Ask Rates, different Exchange Rate Types and Conversion Types are maintained for the same document.
Resolution
For solving the apparent issue that the tax base amount in tax returns is different from the amount in journal entries, the following steps need to be performed:
- Go to Business Configuration work center.
- Select Overview view.
- Find Activity Tax on Goods and Services.
- Select Currency Conversion Types.
- Maintain the same entries as maintained for Journal Entry settings under Currency Conversion Profile activity.
- Cancel the affected documents and post the new document.
Note: The Reverse and Repost option does not resolve this issue because the affected items are already recorded in the tax register and are not recalculated through Reverse and Repost.
Keywords
Tax Base Amount, Journal Entry Amount, Tax Return, Tax Management, General Ledger, Currency Conversion, Currency Conversion Types, Currency Conversion Profile, Exchange Rate Type, Conversion Type, Tax Register, Tax on Goods and Services, Cancel Document, Repost Document, Reverse and Repost, Company Currency, VAT Return. , KBA , SRD-FIN-ACR , Receivables , How To
SAP Knowledge Base Article - Public