Administrators use the File Formats – Setup window to import, update, and clear the file formats for bank payments. SAP Business One uses the assigned file formats to create electronic files for bank payments.

Before you begin make sure you have downloaded the bank payment file format from the PartnerEdge or SAP portal.

Here’s how:

Use the following steps to open the File Formats – Setup window.

1) From the SAP Business One Main Menu, choose: Administration > Setup > Banking > Payment Methods.

2) In the Payment Methods – Setup window, select Bank Transfer or Bill of Exchange as the payment means.

3) Choose Choose from list (Choose from list) next to File Format.

4) In the List of File Formats window, choose New.

In the File Formats – Setup window, use the following procedures to set up bank payment formats.

Importing bank payment formats

1) In the first blank row of the table, select Payment File for the Format Type column.

2) In the Format Type column, choose Payment File.

3) Right-click the row and select Assign Format Project…. The Open window appears.
In the Files of type field, the system automatically selects Bank Payment File Format Project (*.BPP) as the filter.

4) Select the format file that you want to import and choose Open.
In the File Formats – Setup window, the file path is displayed in the Format Project column.

5) In the File Format Name column, the application automatically retrieves the format name defined in the Electronic File Manager: Format Definition add-on. You can change the name of the bank payment format.

6) Choose Update.
You have imported the bank payment format.
The File Format Name column displays Assigned.

Updating bank payment formats

1) In the table, right-click the bank payment format that you want to update and select Assign Format Project…. The system message Format project is already assigned. Overwrite? appears.

2) Choose Yes.
The Open window appears.
In the Files of type field, the application automatically selects Bank Payment File Format Project (*.BPP) as the filter.

3)  Select the format file with which you want to replace the current one and choose Open.
In the File Formats – Setup window, the file path is displayed in the Format Project column.

4) In the File Format Name column, the application automatically retrieves the format name defined in the Electronic File Manager: Format Definition add-on. You can change the name of the bank payment format.

5) Choose Update.

You have updated the bank payment format.
The File Format Name column displays Assigned.

Note: For importing or updating bank payment file formats, in step 4, make sure that:

  • The bank payment file format is designed for the current version of SAP Business One; otherwise, a warning message is displayed.
  • This bank payment file format is designed for the localization of the current company; otherwise, a warning message is displayed.

Downloading bank payment formats

1) In the table, right-click the bank payment file format that you want to download and select Download format project….
The Save As window appears.

2) Specify the file name and the location for storing the format file, and choose Save.
You have downloaded the electronic file format to the specified location.

Clearing bank payment formats

1) In the table, right-click the bank payment file format that you want to clear and select Clear format projects….
The system message Currently assigned format project will be removed. Continue? is displayed.

2) Choose Yes.

3) In the File Formats – Setup window, choose Update.
You have cleared the bank payment file format. The row remains in the table with the format name, and the File Format Name column becomes blank. You can import the bank payment format file to this format later.