on 03-01-2011 9:05 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I run this script :
declare @num int
select @num = SumDec from OADM
select BalDueDeb,BalDueCred,* from jdt1
where
(ABS(debit) != ROUND(ABS(debit),@num) and BalDueDeb != 0)
or (ABS(credit) != ROUND(ABS(credit),@num) and BalDueCred != 0)
I have few records that appeared. I have noticed that there is differences on the decimal values
example : BalDueCred = 36010.237000 // Credit = 36010.237000 // SYSCredit=36010.240000
I have tried to adjust my decimal settings but still I have problem on reconciliation.
how can I adjust this values? Or Can I adjust this values manually?
Thanks a lot.
Edited by: Mr. Right on May 3, 2011 4:17 PM
Hi Mr. Right,
you can increase the number of decimal places, but you will not be able to reduce them again. I recommend to define the over/underpayment option as outlined in the note I reference above. The negligible difference will be posted automatically to one of the accounts you defined there & the reconciliation can be done.
All the best,
Kerstin
Hi Kerstin,
Here are the things that I did.
1. Updated the decimal places in General Settings>Display for Amounts and Prices = 6
2. Updated the Under/Over Payment Allowed = 0.009999 in Document Settings>OutGoing and Incoming Payment
3. Set GL Account in OverPayment and Under Payment in GL Account Det>Sales and Purchasing Tab.
After setting the above, I made BP internal Reconciliation, Enter the date, select all the transactions appeared, and make sure that the Totals for Debit and Credit are equal and has zero differences. But the same error message appeared on the status bar: "Reconciliation Difference must be zero before reconciling".
Did I missed any settings?
thanks.
Hi Mr. Right,
the reason I recommended to use the over/underpayment option was to avoid having to increase the decimal places & still achieve a complete reconciliation. Once they're set to 6 you will not be able to reduce them.
You'll have to restore your latest saved backup of your test system.
As for the error message, it's either a bug or the reconciliation difference is not zero. To rule out a bug you could upgrade your test system to the latest version (8.81) & check again.
Also, check the SAP notes, as Julie recommends above. Ifall that fails to resolve the issue, you might consider logging a support ticket.
All the best,
Kerstin
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is a bug related to rounding differences. If you upgrade to Sp01 latest patch it should fix itself.
Check the SAP Notes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.