SAP Knowledge Base Article - Public

2316367 - G/L Account Posting Block Cannot Be Changed Due to Error: 'Value XXX in setting YYY must also be entered in setting Permitted G/L Accounts by Account Type'

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

  1. Go to the General Ledger work center.
  2. Go to the General Ledger Accounts view.
  3. Find the respective G/L Account, click Edit and click Chart of Accounts.
  4. Change the G/L Account Posting Block to '3 - No postings allowed'.
  5. 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:

  1. Go to the General Ledger work center.
  2. Go to the General Ledger Accounts view.
  3. Find the respective G/L Account, click Edit then click Chart of Accounts.
  4. Select the respective G/L Account and click Where-Used List button.
  5. Expand Account Determination and take note of the path.

Or:

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Click Edit chart of accounts.
  5. Select the G/L Account and click Where-Used List button.
  6. Expand Account Determination and take note of the path.

Then this account must be removed from the account determination.

Steps to follow:

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Open the respective subledger under Account Determination section (for example, Fixed Assets).
  5. 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'.

See Also

2868075 - Error When Changing G/L Account Posting Block: No postings allowed

2918894 - Error when Merging Change Project: "Value XXX in setting Assignment of GL-Accounts must also be entered in setting General Ledger Accounts"

Keywords

posting block; no postings allowed; account determination , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions