chat of account balance is showing wrong value and Value is different from cumulative account balance

[Former Member]

Dear All,

We facing major problem in SAP business one 9.0 ,P.L 0.0.

In chat of account balance is showing wrong value  and value is different from cumulative account balance, Please check the attached image and kindly help to solve the problem.

Regards,

Rajeev.

[julie_jamieson2 · Accepted solution]

Check SAP Note 1427172, there is a detect query with it:

SELECT T0.Account, T1.AcctName, (SUM(T0.Debit) - SUM(T0.Credit)) AS
Should_Be, T1.CurrTotal
FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode, OADM T2
WHERE T2.dispposdeb = 'Y'
GROUP BY T0.Account, T1.AcctName, T1.CurrTotal
HAVING (SUM(T0.Debit) - SUM(T0.credit)) <> (T1.CurrTotal)

UNION

SELECT T0.Account, T1.AcctName, (SUM(T0.Debit) - SUM(T0.credit)) AS
Should_Be, T1.CurrTotal*(-1)
FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode, OADM T2
WHERE T2.dispposdeb = 'N'
GROUP BY T0.Account, T1.AcctName, T1.CurrTotal
HAVING (SUM(T0.Debit) - SUM(T0.Credit)) <> (T1.CurrTotal*(-1))

If the above query retrieves results, please log a support message
via the Service Marketplace referring to this note including all
relevant information.

[Former Member]

Hi Rajeev,

Check with General Ledger report. Financial --> Financial Reports --> Accounting --> General Ledger

You will get your result correctly with this general ledger report.

Thanks,

Harshal

[Former Member]

Hi Harshal,

Thank you for your reply,

General ledger report is getting prefect and correct report but problem is displaying of account balance in chat of account is showing wrong balance value,Please help to solve the problem

Thank you,

Rajeev Sindhi.

[Former Member]

Hi Rajeev,

Is this problem for this particular account only or this issue with other ledgers also ?

I think you should raise a ticket to SAP or you can upgrade to other Patch level.

Thanks,

Harshal