Skip to Content
author's profile photo Former Member
Former Member

Problem on BP reconciliation

Hi experts, we are about to do manual BP internal reconciliation, after selecting all the debit&credit entries the amount to reconcile becomes zero (w/c is OK). I click the "Reconcile" button then error message in the status bar says "Reconciliation difference must be zero before reconciling." Do you think it is a bug? SBO 2007A PL:47.

thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 01, 2011 at 10:21 AM

    It is a bug related to rounding differences. If you upgrade to Sp01 latest patch it should fix itself.

    Check the SAP Notes

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 01, 2011 at 04:27 PM

    Hi,

    It seems from the description of the issue that there is rounding issue with the transactions as you have mentioned that the amount to reconcile becomes zero.

    I would recommend you to check the Note No. : 1318821 which mentiones a 'Automatic Reconciliation Difference' account under the G\L Determination window to be defined and then the reconciliation can be performed without the error.

    Please check.

    Kind Regards,

    Jitin

    SAP Business One Forum Team

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 03, 2011 at 10:51 AM

    Hi Mr. Right,

    one of the most common scenarios is that at some point in the past the number of decimal places has been decreased. You can check the exact amount to be reconciled in the tables with a 'select' query using the query analyser.

    If your values have more decimal places than the current setting you can increase the number of decimals to the required number. This option is unpopular because you can no longer reduce the number of decimal places.

    As a workaround, you can define over/underpayment accounts & allow for example an over/underpayment of 0.009999 in your local currency. SAP note 1321183 - How to use BSP with transactions with different decimals? outlines the process. Please note that in version 8.8 the over/underpayment definitions are set on currency definition level.

    All the best,

    Kerstin

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Do you have all the fields displayed in the Reconciliation window? I think we ran into this and while the BP currency entries balanced, I think the local/system currency values didn't... (sorry, going my memory since this is for SBO2007). Are these entries dealing with foreign currencies?

      Heather

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.