A journal entry is missing in the Account Inquiry window

(0) Share

Report

Posted on by Yash.V

210

Hi All,

There is an urgent live issue. And this needs to be fixed to perform month end closing. And hence it is currently required on priority.

A journal entry was made for a IV adjustment.

And when checked for the corresponding credited account in the "Detail Inquiry" window, it is listed in the details section. But it is not being summed to the account balance.

Upon a quick check we found that all the journal entries posted on that particular day are having the same issue.

I've checked from SQL server using the below query, but it seems to be fine (as it doesn't list any accounts here).

select JRNENTRY, sum(DEBITAMT) - sum(CRDTAMNT) from GL20000, GL00100 where ACCTTYPE = 1
group by JRNENTRY having sum(DEBITAMT) - sum(CRDTAMNT) <> 0

Any ideas would be highly appreciated. Many thanks in advance.

Categories:

Financial Management

All responses (2)

Answers (0)

Suggested answer

Yash.V 210 on at

Like (0)

Report

RE: A journal entry is missing in the Account Inquiry window

Hi Richard,

Thanks for your prompt response.

But this issue got resolved, by performing the reconcile on Finance module.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: A journal entry is missing in the Account Inquiry window

What does this show you for one of your journal entries? Are all the ACCTTYPE's 1?

select JRNENTRY, DEBITAMT,CRDTAMNT,ACCTTYPE

from GL20000 t1

inner join GL00100 t2 on t1.actindx=t2.actindx

where JRNENTRY=XXXXX