SAP Knowledge Base Article - Public

2900727 - Wrong Tax G/L Account Determination for Tax Line Item of a Supplier Invoice

Symptom

In a Supplier Invoice Journal Entry you notice that the derived G/L Account is wrong for the Tax Line Item.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General Ledger work center.
  2. Go to the Journal Entries view.
  3. Search and display the relevant Journal Entry for your Supplier Invoice.
  4. For one of the Set of Books, you notice the wrong Tax G/L Account is being determined at the Line Items level.

Or

  1. Go to the Supplier Invoicing work center.
  2. Go to the Invoices and Credit Memos view.
  3. Search for the relevant Supplier Invoice.
  4. Click on Edit tab and select View All.
  5. Go to the Document Flow tab.
  6. Click Journal Entry Icon for Supplier Invoice to open Journal Entry.
  7. For one of the Sets of Books, you notice the wrong Tax G/L Account is being determined at the Line Items level.

Cause

You have not assigned the desired G/L account to the Account Determination Group assigned to the derived Tax Event.

Resolution

The following steps explain how to configure/check the desired Tax G/L Account - Account Determination assignment:

For this you need to

  • first identify the Tax Event assigned to the derived Tax Code,
  • then check which Account Determination Group is assigned to the Tax Event,
  • Check/maintain the G/L account assigned to the identified Account Determination Group.

To identify the used Tax Code in the Supplier Invoice:

  1. Go to the Supplier Invoicing work center.
  2. Go to the Invoices and Credit Memos view.
  3. Search for the relevant Supplier Invoice.
  4. Select the Items tab and then the Taxes sub-tab. 
  5. Take note of the used Tax Code XX (XX represents a Tax Code) and Tax Country: AB (AB represent the Tax Country). 

To check the Tax Code-Tax Event mapping:

  1. In Business Configuration open the Tax on Goods and Services Fine Tune task (either via Overview or from the Activity List of your Implementation Project. 
  2. Under Tax Codes, select Define Tax Codes.
  3. Sort for Country AB and find Tax Code:XX. 
  4. Take note of the mapped Tax Event XYZ (XYZ represents the Tax Event).

To  check the mapping of Tax Event and Account Determination Group:

  1. In Business Configuration open the Account Determination for Tax Events Fine Tune Task.
  2. In the task, sort for Country AB and Tax Event XYZ.
  3. Take note of the Account Determination Group AAAA assigned (AAAA represent the Account Determination Group) to the Country - Tax Event combination.

To check the G/L Account assigned to the Account Determination Group:

  1. In Business Configuration open the Fine Tune activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  2. Under Account Determination, select Tax.
  3. Select the relevant Account Determination Profile.
  4. Navigate to the Input Tax tab.
  5. Select Account Determination Group AAAA.
  6. Here, ensure the desired the G/L account is assigned to Account Determination Group AAAA. 

Keywords

Wrong Tax G/L account, Account determination is wrong, wrong account determination in Supplier invoice journal entry, , KBA , wrong tax g/l account determination , input tax g/l account is wrong , account determination picking wrongly , wrong g/l supplier inovice journal entry , account determinaiton group for tax , SRD-FIN-TAX , Tax Management , Problem

Product

SAP Business ByDesign all versions