Symptom
You are receiving an error while executing the Financial Statements Report (or) Trial Balance Report
Error in configuration for account 123. (Here 123 is G/L account id)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work Center.
- Go to the List view.
- Search for Report: Trial Balance (or) Financial Statement report.
- Enter the required data.
- Click Apply.
- Error message shown: Error in configuration for account 123.
Cause
You cannot delete the G/L account from backend as the General Ledger Account is still shown under Trial Balance Report (or) under Journal entries. There are line items associated with the G/L account and deleting data from the chart of accounts would not delete data that has been created as part of a journal entry. Deletion of G/L account from the chart of accounts is basically removing it from being used again in future.
Resolution
You need to add the same G/L account with Account type in the Chart of account activity and you should mark the account for No postings allowed to remove the error from the reports.
you should really mark the account for No postings Allowed rather than delete it, as deleting it will have reporting implications.
You should follow the below steps to mark the account for No postings Allowed.
- Go to the General Ledger work center.
- Go to the General Ledger Accounts view.
- Find the respective G/L Account and click Edit > Chart of Accounts.
- Change the G/L Account Posting Block to 3 - No postings allowed.
- Click Save.
Keywords
Error in configuration for account, Financial statement, Trial balance report , KBA , SRD-FIN-GL , General Ledger , Problem