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.