Differences
This shows you the differences between two versions of the page.
control_sql_-_payments_gl_integrity_check [2019/01/27 11:29] 127.0.0.1 external edit |
control_sql_-_payments_gl_integrity_check [2019/02/05 11:33] admin |
||
---|---|---|---|
Line 59: | Line 59: | ||
AND GL.EntryDateTime >= @StartDate | AND GL.EntryDateTime >= @StartDate | ||
GROUP BY COALESCE(DivisionID, | GROUP BY COALESCE(DivisionID, | ||
- | HAVING SUM(Amount) | + | HAVING SUM(Amount) |
) AS A | ) AS A | ||
FULL JOIN | FULL JOIN | ||
Line 70: | Line 70: | ||
TransactionID AS JTHID | TransactionID AS JTHID | ||
FROM Journal | FROM Journal | ||
- | WHERE ClassTypeID = 20001 -- AND DetailAmount | + | WHERE ClassTypeID = 20001 -- AND DetailAmount |
AND Journal.StartDateTime >= @StartDate | AND Journal.StartDateTime >= @StartDate | ||
) AS B ON A.GLGroupID BETWEEN B.StartGLGroupID AND B.EndGLGroupID | ) AS B ON A.GLGroupID BETWEEN B.StartGLGroupID AND B.EndGLGroupID | ||
Line 78: | Line 78: | ||
LEFT JOIN TransHeader ON TransHeader.ID = COALESCE(JTHID, | LEFT JOIN TransHeader ON TransHeader.ID = COALESCE(JTHID, | ||
- | WHERE COALESCE(B.JournalAmount, | + | WHERE COALESCE(B.JournalAmount, |
- | AND COALESCE(B.JournalAmount, | + | AND COALESCE(B.JournalAmount, |
ORDER BY Division, JournalDate, | ORDER BY Division, JournalDate, |