Symptom
Unable to change the G/L Account Type due to below error message.
Error for Account 123 in Chart of Accounts XYZ and acct det. profile PQR:
Account type DEF of acct 123 does not match usage in account determination.
Save failed
(Here 123 refers G/L account)
(XYZ refers Charts Accounts id)
(DEF refers to G/L Account Type)
(PQR refers Account Determination Profile)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Click on Overview.
- Search for the Fine tune activity - Charts of Accounts, Financial Reporting Structures, Account Determination.
- Click on Change Immediately.
- Go to the Edit Chart of Accounts view.
- Select the Chart of Accounts view and try to change the G/L Account Type DEF.
- Click Save.
Error Message shown:
Error for Account 123 in Chart of Accounts XYZ and acct det. profile PQR:
Account type DEF of acct 123 does not match usage in account determination.
Save failed
Cause
The error is due to G/L account is assigned under the Account determination. You cannot change the G/L account Type if the G/L account is still assigned under Chart of Accounts > Account determination.
First, check in which account determination the G/L account is being used.
Steps to follow:
- Go to General Ledger work center
- Go to General Ledger Accounts view.
- Find the respective G/L Account and click Edit > Chart of Accounts
- Select the respective G/L Account and click Where-Used List button
- Expand Account Determination and take note of the path.
Resolution
Remove the account from the account determination by following below steps:
- Go to the Business Configuration.
- Click on Overview.
- Search for the Fine tune activity - Charts of Accounts, Financial Reporting Structures, Account Determination.
- Click on Change Immediately tab.
- Open the respective subledger under Account Determination section (e.g. Fixed Assets).
- Navigate to the respective tab (e.g. Historical Cost) and delete the assignment of the G/L Account with the Account Determination Group.
See Also
Help Center Document General Ledger Accounts Quick Guide ->Display and Edit Chart of Accounts->Account Type.
2433095 - Acct XYZ in CoA ABC Cannot be Deleted/Changed; Transaction Data Exists
Keywords
G/L account type, error for Account in Chart of Accounts, account determination, Change of G/L account type , KBA , SRD-FIN-GL , General Ledger , Problem