SAP Business One in Action - Accounting - Banking and Reconciliation

This catalog is designed to aid those who sell, implement, customise and use SAP Business One. The articles in this section give an insight into the banking and reconciliation type transactions in SAP Business One. They will help you to understand the mechanism behind this functionality. Access the 'SAP Business One in Action' catalog page.

All | Banking and Reconciliation | Currency/Exchange Rates | General Finance | Reporting |

Business One in Action – 2007 A IRU Is There an Indicator In The Report Showing Than an Inconsistency Has Been Dealt with?

This article offers step-by-step instructions to 2 different approaches to determine whether Internal Reconciliation Upgrade (IRU) journal entries displayed in the Inconsistency Audit Trail window are already reconciled.04 Dec 2009

Business One in Action - A Credit Memo Has Been Manually Reconciled With The Wrong Invoice, How Can This Be Fixed?

This article explains how a manually reconciled credit memo may be dissociated from the invoice it is reconciled with, thereby changing the document status of both documents back to 'Open'.04 Dec 2009

Business One in Action - BP Balance Does Not Match Journal Entries

This article explains why the red system message 'BP Balance does not match Journal Entries' can be received when running ageing reports in SAP Business One versions lower than 2007 and how the issue is best dealt with.

04 Dec 2009

Business One in Action - How can we post bank fees and charges while posting Incoming or Outgoing Payment transactions?

This article describes a workaround to record bank charges while posting payments.14 Dec 2009

Business One in Action - How does SAP Business One Deal with Realized and Unrealized Exchange Rate Differences?

When trading internationally with foreign currency business partners, it is inevitable that fluctuations in the global currency market affect a company's accounts. This article explains in detail how SAP Business One deals with both realized and unrealized exchange rate differences using comprehensive examples.24 May 2010

Business One in Action – How to Create a Payment on Account Using BSP?

It is a common occurrence that bulk payments or partial payments are received where it is not entirely clear which invoices they relate to. Since the monetary transaction took place, the Business Partner balance in SAP Business One must reflect these received monies. If a company uses the Bank Statement Processing functionality, it is possible to create a payment on account directly from there. This article illustrates how this can be achieved.

24 May 2010

Business One in Action – How to Offset a Business Partner Who is Simultaneously a Customer and a Supplier?

This article will provide you with a simple procedure that may be employed to internally reconcile a business partner that is both customer and supplier and thus has 2 different BP codes.24 May 2010

Business One in Action - How to Select Documents that are not Included in the Proposed Postings in BSP?

Although matching criteria are defined for a company to facilitate fast and easy reconciliation of bank statement data, it can occur that the desired transaction in SAP Business One is not automatically displayed. This article illustrates the steps the accountant can follow to pull up all open documents for a particular business partner and how to apply a partial payment on a higher value invoice.24 May 2010

Business One in Action - In the Dunning Wizard Function, When Does An A R Invoice Appear As Available For the Generation of a Dunning Letter?

Tips & Tricks in SAP Business One Explanation of system behavior with regard to the Dunning functionality.

01 May 2009

Business One in Action - Is it possible to create a payment on account from the payment wizard?

Tips & Tricks in SAP Business One Explanation of system behavior with regard to the payment wizard.21 Dec 2009

Business One in Action - Voiding Cheques and their Status in the Cheque Register Report

This article describes the different void status of cheques (Void, Void – Unconfirmed, Void – Confirmed, and Void - Not Printed) in the Cheque Register Report.14 Dec 2009

Business One in Action - What is the Purpose of the Deferred Payment Account When Depositing Credit Card Vouchers

Tips & Tricks in SAP Business One. Explanation of functionality regarding payments with credit card.24 Dec 2009

Business One in Action - Where the does the default 'House Bank' come from when using 'Cheque' in the 'Outgoing Payment'?

This article describes how the system pulls the bank information into the Outgoing Payment function.14 Dec 2009

Business One in Action - Why does the warning referring to the cash account appear when making a payment?

This article explains the warning message: "A cash account is required. Choosing a different account may cause inaccuracies in the cash flow report. Continue?"01 Dec 2009