Journal Entries Debit Credit Variance with General Ledger (Not Tally) : QNE Software Sdn. Bhd.

Journal Entries Debit Credit Variance with General Ledger (Not Tally) Print

Created by: Cheng Kah Poh

Modified on: Thu, 27 Jul, 2023 at 11:56 AM

Scenario :

As you can see both Journal Entries and its posting happen extra 1 cent, this is due to currency rate issue, mostly we can resolve by create again in Latest version issue will resolve.

BUT there is so many transaction How can we find all Specific Scenario transaction?

Solution :

select GL.DocumentCode, SUM(gl.Credit) As GLCredit,Sum(gl.Debit) as GLDebit,Sum(Gl.Credit)-Sum(JD.CreditLocal) as CreditVariance,Sum(Gl.Debit)-Sum(JD.DebitLocal) as DebitVariance,SUM(JD.CreditLocal) as JournalCredit,SUM(JD.DebitLocal) as JournalDebit from JournalDetails JD

Join Gltransactions GL

ON GL.TransactionId = JD.Id

group by Gl.documentcode

having Sum(Gl.Credit)-Sum(JD.CreditLocal)<>0

Sum(Gl.debit)-Sum(JD.DebitLocal)<>0

Run this Script, Management studio will assits to list out all same Scenarion transaction.

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

Cheng is the author of this solution article.

Did you find it helpful? Yes No

Journal Entries Debit Credit Variance with General Ledger (Not Tally) Print

Related Articles