1978575 - Different Amounts for Same Document from Different Work Centers

SAP Knowledge Base Article - Public

1978575 - Different Amounts for Same Document from Different Work Centers

Symptom

You open the same document from Tax Management and General Ledger, however, the document shows different amounts.

Reproducing the Issue

From Tax Management:

  1. Go to Tax Management work center.
  2. Select Tax Return view.
  3. Select VAT Return subview.
  4. Select the desired VAT return and choose the Tax Event.
  5. Click on Details.

You can find the document has Tax Base Amount in Company Currency as XXX.

From General Ledger:

  1. Go to General Ledger work center.
  2. Select Journal Entries view.
  3. Find the relevant Journal Entry for the same document.

You can find the Debit in Company Currency is different from XXX.

Cause

The currency conversion from tax engine is different from the currency conversion done in the accounting because of the different settings available for both the currency conversions.

For Tax Management:

  1. Go to Business Configuration work center.
  2. Select Overview view.
  3. Find activity Tax on Goods and Services.
  4. Open the activity and select Currency Conversion Types.

You can see a particular Exchange rate type and Conversion Type maintained for this type of document.

For Journal Entries:

  1. Go to Business Configuration work center.
  2. Select Overview view.
  3. Find Activity Set of Books.
  4. Edit the relevant Set of Book and go to Company Settings tab.
  5. Note the Currency Conversion Profile
  6. Go to Business Configuration work center.
  7. Select Overview view.
  8. Find activity Currency Conversion Profiles.
  9. Choose the Currerncy Conversion Profile noted in Step 5.

Under table Details: Currency Conv. - Bid/Mid/Ask Rates you can see different Exchange rate type and Conversion Type 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:

  1. Go to Business Configuration work center.
  2. Select Overview view.
  3. Find Activity Tax on Goods and Services.
  4. Select Currency Conversion Types.
  5. Maintain the same entries as maintained for Journal Entry settings under Currency Conversion Profile activity.
  6. Cancel the affected documents and post the new document.

NOTE: The Reverse and Repost option do not work in this case as the affected items are in tax register which would not be recalculated on Reverse and Repost.

Keywords

KBA , SRD-FIN-ACR , Receivables , How To

Product

SAP Business ByDesign all versions