Differences

This shows you the differences between two versions of the page.

--- control_sql_-_gl_balance_integrity_checks [2019/01/27 11:28]
127.0.0.1 external edit
+++ control_sql_-_gl_balance_integrity_checks [2019/02/05 11:27] (current)
admin
@@ Line 81: / Line 81: @@
            'A/P Balance' AS Comparison,
            (SELECT -SUM(amount) FROM GL WHERE GLAccountID = 22 AND COALESCE(GL.DivisionID, 10) = Division.ID) AS DetailTotal,
-           (SELECT SUM(BalanceDue) FROM TransHeader WHERE TransactionType = 8 AND StatusID  9 AND COALESCE(TransHeader.DivisionID, 10) = Division.ID) AS DetailTotal
+           (SELECT SUM(BalanceDue) FROM TransHeader WHERE TransactionType = 8 AND StatusID <> 9 AND COALESCE(TransHeader.DivisionID, 10) = Division.ID) AS DetailTotal
            FROM Division