cancel
Showing results for 
Search instead for 
Did you mean: 

Problem on BP reconciliation

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

K_Pauquet
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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

K_Pauquet
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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.

K_Pauquet
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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

jitin_chawla
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

Hi Jitin, the GL you mentioned in GL Accnt Det is already filled-up.

I think we have to upgrade our version,

thanks.

Former Member
0 Kudos

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

Check the SAP Notes

Former Member
0 Kudos

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?