cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Bank Statement Processing.....

Former Member
0 Likes
3,529

Dear All,

I am facing the Problem regarding Bank Statement processing.

I check (Install Bank Statement Processing) in company details.

(I am In Testing Database)

When I am doing Manual Reconciliation at the time will get the Follwoing Error Massage.

[Bank Pages Add-on is Not available for a house bank account when bank statement Processing is enabled (massages 3542-11) ]

my Live database if i want to un-tick the option from Company details (Install Bank Statement Processing) but its Disable.

Please Guide Me.

Regards

Mangesh Pagdhare.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Likes

Hi!

It is a Irreversable Tick.

If u have a backup of your db before doing the check means Restore that.

give ur mail iid, i wil tell u a other suggestion

Former Member
0 Likes

This message was moderated.

K_Pauquet
Product and Topic Expert
Product and Topic Expert
0 Likes

Dear Mangesh,

the tick is irreversible, as the system message informs the user. In order to inactivate BSP you need to either roll back to a backup of the productive database before you initiated the setting or you need to log a support ticket with SAP. If you are an end customer, please contact your partner to log a support ticket for you or to assist in restoring an older backup.

All the best,

Kerstin

Former Member
0 Likes

Hi sir,

I am Yuvaraj i am also facing this issue kindly give me any solution about this and i am installed in live DB .

Answers (5)

Answers (5)

Former Member

Its is not possible to untick the BSP enabled check box in company details.

To get it unticked,,put the message on sap support.

DavidAndrusko
Product and Topic Expert
Product and Topic Expert
0 Likes

Hello,

As regards to the assumed irreversible nature of Bank Statement Processing (BSP), allow me to provide you with more information that might help you more in some concrete situations, but not for all:

The initialization of BSP is done in Company Details on the Basic Initialization tab.

  • This step is irreversible once it is activated and transactions have been processed, that is, any statements have been finalized.
  • Its activation will also remove the Import Bank Statement function supplied by the Payment Engine add-on. The Export function will remain.
  • Cash and Bank function which is a part of the Payment Engine will also be removed.
  • This step should normally take a few seconds. It creates new tables (in addition to OBNK: OBNH, BNK1, BNK2, OBTC) and fields, and a couple of new menu options in Setup and Banking.

Now, if no legacy SAP Business One functionality (such as Process External Bank Statement) for handling statements has been used in the database (most probable cases are new implementations) and if only drafts have been saved or imported via the activated BSP functionality, and absolutely none of those for any of the banks have been finalized, once they are removed via the application interface (namely, via the Bank Statement Details window), then yes, it is still possible to uncheck the Install Bank Statement Processing checkbox.

To check if there have been any statements finalized ("E" refers to executed status, but "D" for "draft" only, which are still removable), it is also enough to inspect the records of the following queries:
SELECT * FROM "OBNK";--this may contain results from the previous functionalities, in that case not possible to deactivate
SELECT * FROM "OBNH";
SELECT * FROM "BNK1";
SELECT * FROM "BNK2";

I hope this helps you to clarify the issue further.

Regards,
David Andrusko
SAP Business One Support

Tonekaboni
Explorer
0 Likes

Hi

I think the BSP is reversible and you cannot to uncheck the field and you can restore backup or package to do that

about the error that you mentioned you cannot add the account in house bank and use it in the bank statement process and you should change the account in house bank form to use in BSP.

I hope that helps,

JesperB1
Product and Topic Expert
Product and Topic Expert
0 Likes

Hello Christine,

To the best of my knowledge there are no predefined formats for the US and they would have to be created per bank and per format.

If you want more detailed information about that contact your partner or if you are a partner contact your LPE (Local Product Expert)

You can also see the help file for the Electronic File Manager which needs to be used to create the format.

https://help.sap.com/saphelp_sbo92ao/helpdata/en/0d/32697f6eb54bc18763c073692a3c44/frameset.htm

It should be said that creating the formats from scratch requires previous experience in this area.

I hope that helps,

Jesper

JesperB1
Product and Topic Expert
Product and Topic Expert
0 Likes

Hello,

Make sure to not process any bankstatements or external reconciliations and contact SAP Support.

Jesper

former_member702411
Discoverer
0 Likes

Could you please tell me how to set up the BSP for the US I can't seem to figure out to get the file format correct?