Support Spotlight: Bank Statement Processing – what is new in SAP Business One version 10.0 FP 2011?

In this blog post we want to introduce you to four new features in Bank Statement Processing. SAP Business One version 10.0 FP 2011, comes with enhancements that will surely help users save valuable time. Among them you will see improvements for Distribution Rules, Control Account flexibility, Sales/Purchase Orders, Down Payments and the final validation.

Distribution Rules 

With the posting method Business Partner from/to Bank Account, in the Bank Statement Row – Details Expanded window, it is now possible to work with Distribution Rules.

In this window, for bank statement rows whose posting method is Business Partner from/to Bank Account, you can now define Distribution Rules.

A payment document created in this manner will have the Distribution Rule on the document line.

Control Accounts 

Now the option of selecting the Control Account in the Bank Statement Details window is available when using posting method Business Partner from/to Bank Account. This is used to create a Payment on Account. The previous behavior resulted in transactions being posted to the default Control Account.

The Control Account field which displays the default value for the Business Partner becomes editable upon selecting the Cleared/Selected checkbox and choosing Yes to the system message depicted above.

The selected Control Account will be used in the payment created upon finalizing the bank statement.

Sales and Purchase Orders 

In the Bank Statement Details and Bank Statement Row – Details Expanded windows, for bank statement rows where the posting method is Business Partner from/to Bank Account, in addition you also have the option to choose Sales Orders and Purchase Orders as posting proposals. The system will automatically create Down Payment Invoices or Requests based on the orders upon finalizing the bank statement.

To enable Sales/Purchase Orders as proposals, you first must select a value in the Create Down Payment in Bank Statement Processing dropdown list for Sales Order and Purchase Order in the Per Document tab of the Document Settings window.

No Starting or Ending Balance

You no longer have to manually key in the Starting and Ending Balances in the Bank Statement Details window if your bank statements are processed without keeping a record of these balances.

In the House Bank Accounts – Setup window there is a new checkbox – No Validation for Starting/Ending Balance.

When this is selected, it is possible to finalize the bank statement even if the difference does not equal zero. The Starting Balance of the current bank statement can be different to the Ending Balance of the previous one as displayed below.  

Summary

This concludes our blog on the improvements to Bank Statement Processing in SAP Business One version 10.0 FP 2011. If you would like to review some additional documentation, please check the sources below.  

SAP Notes  

2980038 – Bank Statement Processing (BSP) Enhancements 

2093263 – Troubleshooting – Bank Statement Processing – Candidate Documents Are Not Proposed for Reconciliation / Matching 

2075202 – Troubleshooting – Bank Statement Processing – Issues When Finalizing Draft Bank Statements 

SAP Training Material  

Bank Statement Processing – BSP: The Working process 

Support Spotlight Series  

We hope this read has been informative and beneficial. For more blog posts and tips from the SAP Business One Support team, please visit our space on the communities: https://blogs.sap.com/tag/b1-support-spotlight/ 

For questions about SAP Business One, please submit your question here.