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
- Go to the Business Configuration work center.
- Go to the Overview view.
- Search and open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
- Click Edit financial reporting structures.
- Select the structure you want to update by importing an updated version from Excel.
- Click Import from Microsoft Excel.
- Browse for the xml file.
- Click OK.
- 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