2985113 - Import and Export Bank Accounts: Invalid File - SAP S/4HANA Cloud Public Edition

When using the App Manage Bank Accounts selecting the option Import and Export Bank Accounts and uploading the XML file, the system returns an error that says that the file is not valid: Invalid file.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP S/4HANA Cloud Public Edition

1. Access the App Manage Bank Accounts. 
2. Click in Import and Export Bank Accounts.
3. Click in Download XML Spreadsheet Template.
4. In the Tab Import Bank Accounts.
5. Click in Import.
6. Select the file downloaded .
7. Click in Open.
8. Error is shown as: Invalid file.

The file conversion for uploading was not correctly done, hence when uploading the file the system displays error Invalid file.

Following are the resolution steps.

1. Open the Microsoft excel, go to File->Options, add Customize the  Ribbon->Developer, press “OK” button. To add customize ribbon.
   
   
   The Developer tab will show up.
   
   
   
2. Log on to the Fiori Launchpad.
   Choose Manage Bank Accounts.
   Choose “Import and Export Bank Accounts”
   
   
3. Download the template file using "Download XML Spreadsheet Template".
4. Open the exported template file using Microsoft Excel.
5. Edit Bank Account and House Bank Account data with reference to the template file.
   In all sheets for the same bank account, the ACC_ID must be the same, but there's no need to provide a real ACC_ID.
6. Export bank account data from the template file into an XML file.
7. Click the export button in the developer tab to export the bank account data to xml.
   
8. Press ‘Select File’ button to specify the file to upload.  Choose the xml file exported. It is suggested to use "Import with Test Run" first to check for any issues.
9. Then choose “Import “to upload the Bank Account.

 Further information about the file upload can be found in Import And Export Bank Accounts.

Manage Bank Accounts, Bank Accounts, File, XML, Import, Export, Import and Export Bank Accounts, Invalid, Invalid File, Bank, Accounts, Cloud, SAP S/4HANA Cloud Public Edition, F1366A, Upload, Upload file, S4_PC, FIN-FSCM-CLM-BAM. , KBA , FIN-FSCM-CLM-BAM-2CL , Bank Account Management (Public Cloud) , FIN-FSCM-CLM-BAM , Bank Account Management , Problem