Balance on OACT does not balance to transactions on JDT1

[Former Member]

Is there a utility to verify balances on OACT to transaction totals. I have an account that shows a balance on OACT but the sum of the transactions is ZERO. Something appears to have gone awry and we know we cannot fix using SQL. What are the options?

[Former Member]

Hi Gillvan........

Welcome to SAP Business One Forum......

@ Your Query: You have to check the transactions of the account in Financial> Financial Reports> Acounting--> General Ledger.

Simply select that account and check the related Transactions from date to till date........

Regards,

Rahul

[Former Member]

Thanks for response, did you mean that do that would fix something or just as a means to verify transactions?

I extracted all transactions in JDT1 for this account, with a query, and added the debits and credits and they are equal meaning that the account balance should be ZERO. This is a control account for receipts and deposits so it was easy to see that something was wrong. There is no foreign currency and SYS currency is same as transaction currency. I also added the debits and credits for outstanding balances and they are the same too, so therefore also ZERO.

It does appear that there was a glitch when updating??? But now how do we fix?

[Former Member]

This is only to verify transaction.

And during this if you find something odd in the figure you may fix that by passing the alternate transaction such as Journal Entry or any reverse document which would reverse the effect........

Regards,

Rahul

[Former Member]

Hi Rahul

I did as you suggested but found neither a single entry or a sum of transactions that equals the value in OACT balance.

This account is zero everyday, the last time it was correct was the 23rd, the balance on OACT = Sum of Transactions.

Several transactions on 24, no one for this odd value and not even the sum is anywhere close. The balance on this extract is ZERO, as it should be, but the balance on OACT is +- 15000.

No journal will correct this, so how can we fix this?

Thanks

Gill

[Former Member]

Ok........

One more option you can find out the source of sum of this figure in terms of transaction is

Open this Account in Charts of Account Window.

Then you find this 15000 balance in balance field and you find an Orange Arrow over there.

Click on that and this will give you how this sum comes and from where......

If it is due to any transaction let say GRN as it if it allocation account then when you pass AP Invoice

its balance would be nullified......

Please check as per above process and will you please know me the Account Name and related to which transaction it is mapped?

Regards,

Rahul

[Former Member]

Hi

This is where we first started and saw that there was an issue. There are a number of receipts for the day in question and then the deposits that take the balance down to 0, but the transactions are zero but not the balance on OACT?

Its a cash account... first they capture receipts and then deposit these. Every day its 0.

Does this help?

Thx

[Former Member]

Hi......

Please be sure about dates also....

If you mistakenly done any Cash entry in as odd date and trying to see in the From and To Date Range where this Date is not covered then you might be missing this entry source.

But if you still not able to find out this then you should raise a support ticket or if you have any implementation support partner you have to show it to them...........

Regards,

Rahul

[jitin_chawla]

Hi,

Can you check the following detect query and confirm whether the G\L Account mentioned by you appears in the result :

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 yes, then you need to contact your partner to open a support ticket to SAP to get the issue investigated. If you are a partner you can log the support ticket to SAP Support.

Kind Regards,

Jitin

SAP Business One Forum Team