Reconciled amounts appears in vendor aging report

[former_member187989]

Dear all,

When we take report for reconciled transactions,reconciled amounts appears in

aging days(Suppose we have ap invoice in 0-30 days and payments made in 30-60 days it's

already reconciled)

Why it is showing in reconciled aging report ?

Jeyakanthan

[former_member708266 · Accepted solution]

Dear，

I would like to check how do you know the amount was reconciled? Can you find it in the banking ->bank statement and internal reconciliation window.

Kindly have a check.

Regards

Apple

[former_member187989]

yes i will check it.

Jeyakanthan

[former_member708266]

Dear，

would like to recommend you to refer to the following note： 1228363-Business Partner Balance does not match journal entries。

*************************************

In any SAP Business One version lower than 2007, 2 separate

reconciliation engines were employed. One reconciliation engine worked

on the marketing document level, where partial reconciliation was

supported & the other worked on the journal entry level, where only

complete reconciliation was supported.

This duality led in some instances to reconciliation inconsistencies

which were initially highlighted with SAP Business One version 2004

patch level 29, where the red message 'Business Partner balance does not

match journal entries' was displayed when running the ageing report by

sales documents & inconsistencies were detected.

In the year end closing guides (available for download from the

Documentation Resource Centre) SAP have always recommended to run the

ageing reports by journal posting.

In 2006, SAP published note 752261, now retired, documenting the system

behaviour & offering a series of 'Select' queries to aid in

reconciliation inconsistency analysis. These queries were an excellent

tool but now SAP can offer a faster, better & more accurate solution.

In SAP Business One 2007 A & B the reconciliation engines have been

unified & partial reconciliation on journal entry level is now fully

supported. Any database that is upgraded from a lower version undergoes

a complex series of reconciliation upgrade algorithms, where any

reconciliation inconsistency is identified & a reconciliation upgrade

(RU) journal entry is automatically created. This RU journal does not

document any accounting transaction, but simply creates an update in the

'Balance Due' column, thus notionally re-openeing previously

inconsistently reconciled transactions.

These RU journals are then available for internal reconciliation.

Please consult the 2007 Internal Reconciliation Upgrade(IRU)Landing

Page:

Channel Partner Portal -> Solutions -> SAP Business One -> Hot Topics ->

SAP Business One 2007 Information Center -> New Single Reconciliation

Engine- A single engine reconciles the difference and eliminates the

previous reconciliation issue. More

Click on 'More' to be directed to the IRU Landing Page.

Here you will find 'How-to-Guides' in all supported languages, links to

Expert Training Sessions & links to other pertinent information.

You will also find available for download 2007 A & B upgrade simulation

tools. SAP recommends to subject a database that is planned to be

upgraded

This upgrade simulation tool employs all internal reconciliation upgrade

algorithms & the application will display in the 'Internal

Reconciliation Upgrade Audit Trail Report' if a database is affected by

inconcistencies.

Hence, if the message 'Business Partner Balance does not match Journal

Entries' is encountered, proceed as follows:

Option 1:

Upgrade database to SAP Business One 2007 & internally reconcile any RU

journals.

Option 2:

Go to the IRU landing page & download the 'IRU pre-upgrade tool' either

for version 2007A or 2007B, depending on your localisation. Follow the

installation instructions & after successful installation & simulated

upgarde of the database, analyse any inconsistencies appearing with the

help of the How-to-guide. Should a type of inconsistency not have a drop

down arrow & be described as 'Balancing upgrade journal transaction',

the comapny accountant may decide to write it off, should the amount be

insignificant or, if the amount is not insignificant, please log a

support ticket with the component:

SBO-ADM-UT-IAT

Step by step detailed instructions including screenshots of how to

install the sim-tool & what it does can be found on this wiki page:

https://wiki.sdn.sap.com/wiki/display/B1/BPaccountBalancedoesnot+matc

chJournalEntries

Thanks & Regards

Apple

[msundararaja_perumal]

Hi,

Kindly go through this [document|https://websmp107.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=011000358700002498442003E] for the detailed explaination of the selection criteria used in the aging analysis reports.

Might be helpful.