3683096 - Unable to create Cash Flow Financial Statement Through Import

When trying to upload a Financial Reporting Structure, nothing happens.

SAP Business ByDesign

1. Go to Business Configuration - Overview.
2. Open Charts of Accounts > Edit Financial Reporting Structures.
3. Click on Import from Microsoft Excel.
4. Select the related file.
5. Nothing happens.

In the file provided by the customer, opening it as an XML it shows a structure similar as of below:

<FinancialStructure>
 <header>
   <FSTRUCTURE>ABC</FSTRUCTURE>
   <StructureType>X</StructureType>
   <COA>XYZ</COA>
   <Description>ETC</Description>
 </header>
</FinancialStructure>
 
Which is only the header. XML tags from Structure is missing.

Checking on the file through Excel, it is noted that the Tab STRUCTURE is missing.

(ABC stands for the Financial Structure ID, X for the type, XYZ for the Charts of Accounts and ETC represent the description)

1. Go to Business Configuration - Overview.
2. Open Charts of Accounts > Edit Financial Reporting Structures.
3. Click on Export to Microsoft Excel.
4. Opening the file in Excel we can see two tabs:
   STRUCTURE
   HEADER
    
5. Edit data on the Header and Structure tab as needed.
6. Save the file as XML Data.
7. Then repeat the process to Import the Financial Structure.
8. This time, Financial Reporting Structure will be created.

Import, Financial Reporting Structure, XML , KBA , SRD-FIN-ANA , Analytics Content , How To