Symptom
For a certain G/L Account you want to define G/L Account Posting Block as 3 - No postings allowed, however upon saving the change you get the error messages Value XXX in setting YYY must also be entered in setting Permitted G/L Accounts by Account Type and 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.
Reproducing the Issue
- Go to General Ledger work center
- Go to 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
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 you cannot prohibit postings hitting this account before you remove it from account determination.
Resolution
In order to be able to set the G/L Account Posting Block 3 - No postings allowed you should remove the G/L Account from account determination.
You first need 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 > 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 you need to remove this account 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 (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
Once you save the changes you should be able to set the posting block 3 - No postings allowed.
Keywords
KBA , SRD-FIN-GL , General Ledger , How To