Customer incorrect account balance

[Former Member]

Hi Experts,

I have a business partner with -$2.15 but after investigation there are no open items left to reconcile on the account. The account balance should be zero. Is it a bug? Would you know why it happened? How can I fix this one?

Thanks in advance,

Maria

[Former Member · Accepted solution]

Hi Maria,

What is your B1 version/PL? How many JE related to this BP?

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

Its SAP B1 8.82 PL12 and here's the screen shot of all the transactions of this customer. No manual JE posted with this BP

Thanks,

Maria

[Former Member · Accepted solution]

4 years ago, there was no 8.82 yet. How many times have you upgraded your B1?

[Former Member · Accepted solution]

Hi Gordon,

Will there be a log in SAP wherein I can find the version history? I am not quite sure how many times it was upgraded since it was just passed on to me and document to show the version history.

Thanks,

Maria

[Former Member · Accepted solution]

It is not that important to know the entire version history. However, the problem you faced is more than likely related to previous upgrade. One solution for you is to run BP balance restore under SAP support guidance. Or first you can try on your test environment on your own.

[Former Member · Accepted solution]

Hi Gordon,

It worked for me. But how did it work? After I restore, I checked if there is a JE created to adjust the balance but there seem none. So I am just wondering how can I explain this restore BP process to our user.

Thanks so much!

Maria

[kothandaraman_nagarajan · Accepted solution]

Hi Maria,

Please check with SAP note 752031.

Thanks & Regards,

Nagarajan

[jitin_chawla · Accepted solution]

Hi,

The issue can be due to some database corruption while doing reconciliation or creation of entries. Since, the entries are old and till the year 2011, an old bug can also cause this issue to happen in the database.

You can may be run the following query to check the affected BP :

select t0.cardcode , t0.balance,  sum(t1.debit - t1.credit) from ocrd t0

inner join jdt1 t1 on t0.cardcode = t1.shortname

group by t0.cardcode , t0.balance

having t0.balance <>  sum(t1.debit - t1.credit)

Also, running Restore can resolve the issue but it should not be run without the approval of the SAP Support.

Kind Regards,

Jitin

SAP Business One Forum Team

[abdul_ranginwala]

Did you check the currency on each entry? I notice that this customer is set as Canadian Dollar and I don't know what is your local currency. Also, I don't have much experience on different types of currency but it could be currency exchange rate issue.

[kothandaraman_nagarajan]

Hi Maria,

Check you setting under Company details--->Basic initialization tab---> Display Credit Balance with Negative Sign.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Naga Rajan,

I don't think it is something related to the settings because it only occurs to 1 business partner. Instead of having a zero balance, it has a -$2.15 balance.

Thanks anyway,

Maria

[former_member186712]

Hi Maria,

What is the balance of the customer in Customer master data?

What is the balance on the ageing report?

If they are the same, maybe you have a document that is still opened.

Hope it helps,

Augusto

[Former Member]

Hi Augusto,

Here's the screen shot of the business partner balance, wherein the account balance overview (-$2.15) is different from the details and in the aging report (both has zero balance)

Thanks,

Maria

[former_member186712]

Hi Maria,

Only today I'm seeing your answer.

There's a problem in the Database and you need help from the SAP support.

They have to fix  the Database.

Augusto