Announcements
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.
Hi Richard,
Thanks for your prompt response.
But this issue got resolved, by performing the reconcile on Finance module.
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156