Bank Reconciliation Report in SAP Business One 9.2 v

[former_member589822]

Dear Experts,

We are using SAPB1 9.2 v India localisation. We are not able to see Bank reconciliation report in it. How to extract the same .We need a typical Bank Reco report which has following

Bank Balance as per General LedgerBook Rs.

Unreconciled transacrion

Add : cheques received but not cleared

Less: cheque issued but not cleared

Bank balance as per Bank pass book

Balance : Nil

I am not able to extract this report in SAB1 . In fact when we do reconciliation , the reconciliation is complete when balance is zero , and we could see all the above field till we click reconcile , but we are not able to print this reconciliation statement .

When we see the blog , we understand that Bank reconciliation report is available in US, UK localisation and these forms are also extended to Indian localisation , but we are not getting it in our license.

Please help us .

[Abdul · Accepted solution]

There is bank reconciliation report in system on following path Banking Reports>External Reconciliation. You can try this report

[msundararaja_perumal]

Hello,

You can try using to print the default report of reconciled and Unreconciled statement under Banking->Bank Statements and External Reconciliations->Reconciliation, select the bank G/L Account and choose reconcile.

Enable the check box Print Balancing Transactions.

Click on Print Settings button, enabled the checkbox Print Reconciliations Transactions, Unreconciled Transactions and Details Totals for External Reconciliation, return to the External Reconciliation window and Preview.

This is give out the report that you are looking for, the default PLD format may not be presentable, you need to modify them according to your need.

If need to replicate the format that Indian accountants are used to, then you need to create custom report.

Thanks.

[former_member589822]

Dear Vishwanathan

We checked . The fields are not hidden.

Regards

Yogish

[kvbalakumar]

Hi,

Check the form settings of the Main Menu whether the relevant menu is hidden or not?

Regards,

Bala