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
- Go to the General Ledger work center.
- Go to the Journal Entries view.
- Search and display the relevant Journal Entry for your Supplier Invoice.
- For one of the Set of Books, you notice the wrong Tax G/L Account is being determined at the Line Items level.
Or
- Go to the Supplier Invoicing work center.
- Go to the Invoices and Credit Memos view.
- Search for the relevant Supplier Invoice.
- Click on Edit tab and select View All.
- Go to the Document Flow tab.
- Click Journal Entry Icon for Supplier Invoice to open Journal Entry.
- 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:
- Go to the Supplier Invoicing work center.
- Go to the Invoices and Credit Memos view.
- Search for the relevant Supplier Invoice.
- Select the Items tab and then the Taxes sub-tab.
- 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:
- 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.
- Under Tax Codes, select Define Tax Codes.
- Sort for Country AB and find Tax Code:XX.
- Take note of the mapped Tax Event XYZ (XYZ represents the Tax Event).
To check the mapping of Tax Event and Account Determination Group:
- In Business Configuration open the Account Determination for Tax Events Fine Tune Task.
- In the task, sort for Country AB and Tax Event XYZ.
- 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:
- In Business Configuration open the Fine Tune activity Charts of Accounts, Financial Reporting Structures, Account Determination.
- Under Account Determination, select Tax.
- Select the relevant Account Determination Profile.
- Navigate to the Input Tax tab.
- Select Account Determination Group AAAA.
- 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