Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
joyce_liu1
Explorer
0 Kudos

When Bank Statement Processing(BSP) is activated, you can import bank statements into SAP Business One on BSP module. One scenario is that if in the statement file, a piece of text that is to be mapped in a particular field is split up between two lines, then the carridge return(\r\n) within will also be imported into SAP Business One.

Example:

Localization: DE

File format in use: SAPBPDEIB_MT940

Bank statement file sample:

- Notice bank account ‘0123456789’ is split up between two lines

Reproduction:

1.   1.Activate option Install Bank Statement Processing under Administration>System Initialization>Company Details>Basic Initialization.

 

2. Go to Administration>Setup>Banking>House Bank Accouts, make sure the checkbox in column Import Bank Statement is ticked and file format SAPBPDEIB_MT940 has been assigned to the bank code and account number obtained from the statement file.

       3. Go to Banking > Bank Statements and External Reconciliations > Bank Statement Processing, choose the corresponding house bank and bank account to import the sample statement file.

      

       4. Double click the imported record to open window Bank Statement Details. There is a blank space in the imported BP Bank Account.

      

   

Solution:

1.   1.Download format SAPBPDEIB_MT940 and open it in EFM manager.

Regarding the details you could refer to another blog: How to Change or Customize Electronic File Formats in SAP Business One(http://scn.sap.com/community/business-one/blog/2011/09/27/how-to-change-or-customize-electronic-file...)

2.Go to Field31(corresponding to ‘BP Bank Account’). Under tab Mapping enter the following in box Mapping Method:

translate(%Field31,'

','')

- Please notice that when typing you have to press ENTER to ensure carriage return is between single quotation mark.

3.Save the modified format and assign it to the house bank account under House Bank Accouts- Setup

4. Import the same bank statement file again, there is no blank space in the imported BP Bank Account any more.

For more details regarding BSP please refer to Bank Statement Processing Landing Pages at https://websmp206.sap-ag.de/~sapidb/011000358700000118382008;

For more details regarding EFM please refer to Format Definition Landing Pages at https://websmp206.sap-ag.de/~sapidb/011000358700000940822007