A journal entry is missing in the Account Inquiry window

(0) Share

Report

Posted on by Yash.V

220

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:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Yash.V 220 on at

Like (0)

Report
Copy link

Link copied!

Hi Richard,

Thanks for your prompt response.

But this issue got resolved, by performing the reconcile on Finance module.

Was this reply helpful? Yes No