SAP Knowledge Base Article - Public

2985113 - Import and Export Bank Accounts: Invalid File

Symptom

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."

Environment

SAP S/4HANA Cloud

SAP S/4HANA

Reproducing the Issue

  1. Acces 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.

Cause

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

Resolution

Following are the resolution steps.

  1. You need to Open the Microsoft excel, go to File->Options, add Customize the  Ribbon->Developer, press “OK” button. To add customize ribbon.
    MS Excel_DeveloperOption.png

    The Developer tab will show up.
    Developer-tab.png

  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.
    You don't need to provide a real ACC_ID but the ACC_ID in all sheets for same bank account must be same.
  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.
    Import-Export.png
  8. Press ‘Select File’ button to specify the file to upload.  Choose the xml file exported. We suggest you should use “Import with Test Run” first to check whether there are issues.
  9. Then choose “Import “to upload the bank account.

 

See Also

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

Keywords

Manage Bank Accounts, Bank Accounts, File, XML, Import, Export, Import and Export Bank Accounts, Invalid, Invalid File, Bank, Accounts, Cloud, S/4HANA Cloud, 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

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions

Attachments

Import or export Bank Accounts..docx