Bank Statement Processing

[Former Member]

Dear All,

I am trying to import Bank Statement file into SAP B1 but I got error, can anyone help me to import the Bank statement. Here I have attached the error message for reference.

Thanks in advance

Regards

Neslin

[jitin_chawla · Accepted solution]

Hi,

What is the SAP Business One Version and patch?

Are you using any add on? If yes, what add on is used?

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

I didn't use any add-on, my SAP b1 version is 9.0 and Patch level 09.

Regards

Neslin

[jitin_chawla · Accepted solution]

Hi,

Can you share the example content of the file which are uploading without the balances if possible?

It could be possible that it could be an application error in Version 9.0 PL09 (PL09 is latest patch)

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

Please find the bsp file format and my bank statement file for your reference.

Thanks

Regards

Neslin

Bank Statement.txt.zip

[former_member196081 · Accepted solution]

Hi Neslin

first try to import the same statement in EFM addon. and click on Data preview.

[Former Member · Accepted solution]

Deepak,

I have checked in the data preview. I didn't get the any data in the preview. Can you please help me further to achieve this.

Thanks

Regards

Neslin

[former_member196081 · Accepted solution]

It means either your format or your bank statement is not correct.

start with below links...

[Former Member · Accepted solution]

Hi Deepak,

I have done all the corrections and still getting an error messages. I have attached the error log files.

Thanks

Regards

Neslin

[former_member196081 · Accepted solution]

As per your log file, Its showing error related to Bank Account.

Check below setting in banking set up

[Former Member · Accepted solution]

Thanks Deepak.

Regards

Neslin

[kothandaraman_nagarajan]

Hi,

Please refer SAP note:

1835789 - BSP_Cannot Import Bank Statement Files  

Thanks & Regards,

Nagarajan

[Former Member]

Thanks Nagarajan for your quick response, but I have done all the configurations, settings and formatting as mentioned in the SAP Notes. Still I'm facing the same problem.

Regards

Neslin

[kothandaraman_nagarajan]

Hi,

It is an application error in 9.0 version. Better check with SAP support.

Thanks & Regards,

Nagarajan