35
I am getting an unbalanced trial balance. the debits and credits are off by the net change. I have narrowed it down to the exact date but unable to fix it. Any suggestions?
*This post is locked for comments
If you answer following questions regarding your issue, I`ll be in a position to trace your problem exactly and suggest a solution:
1, What report/window are you using to check trial balance??
2. Are you selecting trial on posted transactions only or including un-posted transactionsas well??
In addition, below given SQL statement can also pull up problematic Journal Entries for you if there are any.
-----------------------------------------------------------------------------------------------------
SELECT JRNENTRY, SUM(DEBITAMT) DR_Sum , SUM(CRDTAMNT) CR_Sum, SUM(ORDBTAMT) OR_DR_Sum, SUM(ORDBTAMT) OR_CR_Sum
FROM GL10001
GROUP BY JRNENTRY
HAVING SUM(DEBITAMT) <> SUM(CRDTAMNT) OR SUM(ORDBTAMT) <> SUM(ORDBTAMT)
UNION ALL
SELECT JRNENTRY, SUM(DEBITAMT) DR_Sum , SUM(CRDTAMNT) CR_Sum, SUM(ORDBTAMT) OR_DR_Sum, SUM(ORDBTAMT) OR_CR_Sum
FROM GL20000
GROUP BY JRNENTRY
HAVING SUM(DEBITAMT) <> SUM(CRDTAMNT) OR SUM(ORDBTAMT) <> SUM(ORDBTAMT)
-----------------------------------------------------------------------------------------------------
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (