BP account Balance does not match Journal Entries

baobao

Due to the duality of the reconciliation functionalities within SAP Business One in all versions prior to 2007 there was a possibility of inconsistent reconciliations. Some of these inconsistencies manifested themselves in the display of the red message 'BP account Balance does not match Journal Entries' when running the ageing report by sales documents, which was introduced with patch 29 in SAP Business One 2004:

SAP note 752261 was released in January 2006, providing a set of queries that were designed to determine the cause of the inconsistency. Now there is a better tool available, readily available & easy to use.
SAP now provides the 2007 A & 2007 B upgrade simulation tools, available for download from the SMP:
Channel Partner Portal -> Solutions -> SAP Business One -> SAP Business One Hot Topics -> SAP Business One 2007 Information Centre -> New Single Reconciliation Engine -> click on 'More'.

Download the sim tool & install it locally.
Result of the installation:
1.   An additional SBO common is created:

2.   A new shortcut appears on the desptop:
3.   Open the application with a double-click on the shortcut & select a database from the server to undergo a mock upgrade to version 2007, note that the background colour will differ from the usual SAP Business One background:

4.   Log into the database to initiate the mock upgrade. There is no need to take a prior backup.
5.   The following system message is received:

6.   Click on 'Yes' at an appropriate time, when effects on the performance of the live system are not an issue.
7.   The following window will appear:

Here enter the minimum value of an inconsistency that should be detected during the upgrade. The general recommendation is to use the value of '1' such that minimal rounding issues will not generate reconciliation upgrade journals.
8.   Clicking on 'OK' will initiate the mock upgrade. Once the upgrade is completed & reconciliation inconsistencies are indeed present in the database, the 'Inconsistency Audit Trail Selection Criteria Screen' window will open automatically. Here, the user can  filter the output of the audit trail. Note: the default background colour is yellow.

9.   Using the criteria above & clicking on 'OK' will result in the display of all inconsistencies, for this example I created an inconsistency in the database in the lower version:

10.   The 'Summary Explanation' clearly states that AR invoice (IN) 42 had been paid with incoming payment (RC) 18, but RC 18 had been reconciled with something else.
11.   Upon the upgrade to 2007 A journal entry 285 had been automatically created which notionally reopens IN 42 by opening a 'Balance Due' on the BP account balance. This journal has no credit/debit entry & does not affect the actual balance on the BP account.


12. When encountering the message 'BP Balance does not match Journal Entries, SAP recommends to upgrade to 2007 A or B & then reconcile thus generated RU journals directly from the account balance or the audit trail window with another appropriate transaction.