Symptom
Not able to define G/L Account Posting Block as 3 - No postings allowed for a given G/L Account due to error messages:
'Value XXX in setting YYY must also be entered in setting Permitted G/L Accounts by Account Type'
'Posting and A/c XXX used in a/c det; "No postings allowed" not possible.'
XXX stands for the G/L Account ID.
YYY stands for the Account Determination using the G/L Account.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to General Ledger work center.
- Go to General Ledger Accounts view.
- Find the respective G/L Account and click Edit and click Chart of Accounts.
- Change the G/L Account Posting Block to '3 - No postings allowed'.
- Click Save.
Error messages are thrown:
'Value XXX in setting YYY must also be entered in setting Permitted G/L Accounts by Account Type Posting'
'A/c XXX used in a/c det; "No postings allowed" not possible.'
Cause
The reason for the error messages is that the respective G/L Account is being used in account determination and hence postings hitting this G/L Account cannot be prohibited before it's removed from account determination.
Resolution
To be able to set the G/L Account Posting Block '3 - No postings allowed' the G/L Account should be removed from account determination.
Firstly it's necessary to check in which account determination the 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 then click Chart of Accounts.
- Select the respective G/L Account and click Where-Used List button.
- Expand Account Determination and take note of the path.
Then this account must be removed from the account determination.
Steps to follow:
- Go to Business Configuration work center.
- Go to Overview view.
- Open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
- Open the respective subledger under Account Determination section (for example, Fixed Assets).
- Navigate to the respective tab (for example, Historical Cost) and delete the assignment of the G/L Account with the Account Determination Group.
Once the changes are saved it should be able to set the posting block '3 - No postings allowed'.
Keywords
posting block; no postings allowed; account determination , KBA , SRD-FIN-GL , General Ledger , How To