SAP Knowledge Base Article - Public

2770675 - How the System Determines the Import Format for an Inbound Bank Statement File

Symptom

You want to know how the system proposes the Import Formats when creating a new Inbound Bank Statement file.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the File Management view.
  3. Go to the Inbound Files subview.
  4. Click New.
  5. Select Inbound File.
  6. Enter the relevant data in the fields File Type, Company and Bank ID.
  7. Display the Import Format drop down menu.
    Note: The system shows one or two different options depending on the data entered on Step 6 above.

Cause

The maximum number of options that the system will display under Import Format drop down menu when creating a new Inbound Bank Statement is two.
The Import Format options will be proposed depending on the settings in the Business Configuration activity called ''Automatically Generated Bank Statements''.

Resolution

  1. The first Import Format shown in the drop down menu when creating the Inbound Bank Statement, will be proposed according to the Import Format with the highest priority set up in the activity ''Automatically Generated Bank Statements''> ''Assign import formats for bank statements'' for the Company and Bank ID selected, this is, the Import Format with the highest Sequence Number for the Company and Bank ID selected.
  2. The second Import Format shown in the drop down menu when creating the Inbound Bank Statement, will be proposed according to the Import Format maintained in the activity ''Automatically Generated Bank Statements''>''Assign custom bank statement format'' for the Country Code maintained.
  3. If no entry has been maintained with the selected Country Code in the activity ''Automatically Generated Bank Statements''>''Assign custom bank statement format'' then the system will only show one option as Import Format, which is the one according to Point 1 above.

Keywords

Bank Statement; Incoming, Inbound, New, Import Format, Liquidity Management, File, Upload , KBA , bank statement file format not found for , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions