Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    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 comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Julie, I have upgraded my version from SP00 PL47 to 2007A SP01 PL13 but still the same problem occurs. Do you have other suggestions?

  • 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 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 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