Description |
We need to add a check to the recalc routine to see if all transactions are balanced before the recalc is completed - There is no sense running the recalc if there are out of balance transactions-
* If a transaction is not in balance per the below check we should
** Raise a warning "Please call support on following transactions"
** Show a list of the transactions
SQL Query for audit check below:
select strTransactionId,sum(dblDebit-dblCredit)
from tblGLDetail
group by strTransactionId
having sum(dblDebit-dblCredit)<>0
|