SAP Knowledge Base Article - Public

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

Symptom

Merge of change project with production fails with errors in the merge report, similar to the following type:

  • Value XXX in setting Assignment of GL-Accounts must also be entered in setting General Ledger Accounts
  • Value YYY in setting Miscellaneous Ledger General Ledger Account Alias must also be entered in setting Permitted G/L Accounts by Account Type and Posting
  • Value ZZZ in setting General Ledger: Other Income must also be entered in setting Permitted G/L Accounts by Account Type and Posting

(XXX / YYY / ZZZ represent the individual values in the respective settings)

Note - The same error messages appear in multiple views. Therefore, please check the scenario and act accordingly.

Environment

SAP Business ByDesign

Reproducing the Issue

The above error appears in three different scenarios:

Scenario 1) During Merge of change project with Production system.

Scenario 2) At the time of changing G/L Account Type.

  • Go to Business Configuration.
  • Click Overview.
  • Search for the Fine tune activity - Charts of Accounts, Financial Reporting Structures, Account Determination.
  • Click Change Immediately. 
  • Go to Edit Chart of Accounts view. 
  • Select the Chart of Accounts view and try to change the G/L Account Type. 
  • Click Save. 
  • Errors:
    Value XXX in setting Assignment of GL-Accounts must also be entered in setting General Ledger Accounts
    Value YYY in setting Miscellaneous Ledger General Ledger Account Alias must also be entered in setting Permitted G/L Accounts by Account Type and Posting  

Scenario 3) Deletion of standard Account Determination Group delivered by SAP.

  • Go to Business Configuration.
  • Click Overview.
  • Search for the Fine tune activity - Charts of Accounts, Financial Reporting Structures, Account Determination.
  • Click Change Immediately. 
  • Click on Edit Account Determination Groups.
  • Go to Cost Subledger.
  • Select Groups for General Expenses
  • Select Group ID - AAA and click Delete.
  • Click Save. 
  • Error: Value AAA in setting Costs: General Expenses must also be entered in setting G/L Accnt Det. Group for Cost Accounting

Cause

Some financial accounts had been created or changed in the main workspace while the change project was open.

Resolution

Scenario 1) Please open an incident with SAP Product Support.

Development will have to take over these creations and changes manually into the change project. Afterwards, it will be possible to complete the merge successfully. You will then be able to perform the last steps to close the project.

Note: To avoid such issues in the future, we would advise to keep the lifetime of change projects short (which makes sense in general) and to avoid changes of financial accounts in the main workspace while a change project is open.

Scenario 2) You have to check if the posting is made or not on the G/L Account. If there is any posting made (Journal Entry exist) on the G/L Account, then the system will not allow you to change the G/L Account Type. It is even not possible from backend. This is a standard system behaviour.

Scenario 3) Please follow the KBA - 2882362 - Unable to Delete Standard Account Determination Group due to Error.

Similar issue can be seen while setting G/L Account Posting Block to 'No postings allowed'. This can be solved by

Removing it from the account determination section and then try to set the posting block.

The account can be maintained under Costs: General Expenses -> General Expenses.

See Also

Should the following error occur when Sales Cycle or Sales Phase on Business Configuration:

  • When you delete the sales phase under Maintain Sales Phases  the following error occurs: "Value ABC in setting Sales Cycle Phase must also be entered in setting Opportunityphase Save failed" (ABC represents the Sales Phase Code).
  • When you delete the sales phase under Maintain Sales Cycles the following error occurs: "Value XYZ in setting Assignment of Steps to Opportunity must also be entered in setting Sales Cycle Phase Save failed" (XYZ represents the Sales Cycle Code).

Please see KBA 2939381 -  Sales Phase Cannot Be Deleted in the Sales Cycles and Phases Activity

Keywords

not possible, test system, not able, perform, failing, financial accounts, workspace, changes , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions