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
OR
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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article