SAP Knowledge Base Article - Public

2186430 - Cannot Assign G/L Account To Financial Reporting Structure - Identify Duplicate Assignments in the Structure

Symptom

You want to add a G/L account to a structure item of your reporting structure. But the G/L account is not available in the selection list.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Business Configuration workcenter go to the Implementation Projects view and select the current project.
  2. Open the Activity List and navigate to the Fine-Tune-phase.
  3. Find the Charts of Accounts, Financial Reporting Structures, Account determination task and open it.
  4. Under Financial Reporting Structures press on Edit financial reporting structures.
  5. Select the respective structure and press Edit.
  6. Now navigate to the structure item where you want to add the G/L account.
  7. Select the row and press Actions - Assign Account.
  8. In the selection list you can't find the G/L account that you want to add. 

Cause

The Financial Reporting structure is not consistent. Not being able to assign further G/L accounts to the structure is a symptom of the structure inconsistency. In most cases the inconsistency is caused by duplicate G/L account assignments:

A) Structure was created in SAP ByDesign:

Use the Check Consistency function to find a reason for the inconsistency: Press on the Check Consistency button.

An error message appears: Duplicate assignments exist in the structure.

B) Structure was created via Import from Excel:

In this case the consistency check is not reliable. It will state: Financial Structure is consistent.

It is however very likely that the reporting structure is not consistent.

Resolution

To check if there are duplicate assignments in your financial reporting structure you can export the structure to Excel. In Excel use the Duplicate Values function to identify the respective assignments:

  1. Again in the Charts of Accounts, Financial Reporting Structures, Account Determination task press on the Edit financial reporting structures link under Financial Reporting Structures.
  2. Select the respective strucure and press Export to Microsoft Excel.
  3. Save the structure locally and then open it.
  4. In Excel highlight the Items column.
  5. In the Home tab press Conditional Formatting.
  6. Select Highlight Cells Rules and then select Duplicate Values.
  7. In the little pop-up window you should see Format cells that contain: Duplicate values with Light Red Fill with Dark Red Text.
  8. Press OK.
  9. This way all duplicate values can be easily identified.
  10. You can remove the duplicate assignments either in Excel and then import the structure again* or you remove the assignments directly in Fine tuning:
    • Open the structure via Edit.
    • Find the structure item where you want to remove a duplicate.
    • Press Actions - Assign Account and deselect the account by unticking the box.

The structure should now be consistent again and it will be possible to assign further accounts.

Keywords

Cannot Assign G/L Account, Financial Reporting Structure, Identify, Duplicate Assignments,  Structure, G/L account, not available, selection list , KBA , AP-ACC , Business ByDesign: Financial Accounting , How To

Product

SAP Business ByDesign all versions