Automatic bank reconciliation

[Former Member]

Hi Experts,

We are using SAP B1 PL8, can any one help me how to use automatic reconciliation.

I selected the "Install Bank Statement processing" in administration module. Also in Banking module "Bank Statement Processing" is appearing. I am unable to use this statement and in "Reconciliation" the external statement is not appearing any values.

Kindly let me know is there any Add-on require to use this facility.

[K_Pauquet · Accepted solution]

Hi Vinoth,

BSP is one of the major enhancements in version 2007 & a completely new functionality that requires some set up. Please refer to the document ' How to use Bank Statement Pocessing in 2007' within the DRC for 2007.

All the best,

Kerstin

[Former Member · Accepted solution]

Hi Kerstein,

Thanks. Kindly let me know where can I find the document.

Sreenivas

[Former Member · Accepted solution]

Hi Kerstin

Can you explain where the document available.

Thanks & Regards,

Sreenivas

[Former Member]

Hi Vinoth......

As you install Bank Statement processing you have process external bank statement in Banking module. Now you need to import the bank statement over there and once you done you will h=get all your records on right hand side of reconciliation window. Now you click on automatic recon. and while you for every SAP transaction there is some check no. or ref. no. so you need to put the same ref. no. in the bank statememnt template so that system will recognize the ref no. Now when you click on automatic recon then select Total with restriction option button and then check the reference check box. Once your ref. no. will be matched it will perform recon automatically.......

Regards,

Best Rahul

[Former Member]

Hi Rahul,

First thanks for your answer. But I strucked importing bank statement.

I would like to inform that we are using SAP B1 2007B with PL15.

Kindly let know how to import the bank statement.

Project is in live stage. I will be waiting for your reply.

[Former Member]

Hi...

You can import it through DTW and its template is readily available in SAP as BankPages.........

Regards,

Rahul