SAP Knowledge Base Article - Public

2888689 - 'Item ABC has both assignments and items; children not imported' Error Message Importing Financial Reporting Structure from Microsoft Excel

Symptom

Error message is thrown upon importing a financial reporting structure from Microsoft Excel:

'Item ABC has both assignments and items; children not imported'

ABC means the financial reporting structure item.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Search and open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Click Edit financial reporting structures.
  5. Select the structure you want to update by importing an updated version from Excel.
  6. Click Import from Microsoft Excel.
  7. Browse for the xml file.
  8. Click OK.
  9. Error message is thrown:

'Item ABC has both assignments and items; children not imported'

Cause

As per the design of financial reporting structure hierarchy, assignments and items together can't be allowed under one item.

For example, in the respective xml file, Item node contain Item 'Assets' and 'XYZ' (Accounts Assignment) in same hierarchy. Due to that, system didn't allow the import.

Resolution

The item 'XYZ' should be put under proper node, and then, the Import from Microsoft Excel function should be executed again.

Keywords

financial reporting structure; import from Microsoft Excel; item; node; itemtype; assignmenttype; account , KBA , import from microsoft excel , financial reporting structure , assignmenttype , itemtype , item , node , account , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions