Description |
This query below showed all transactions that are not balanced when unposted from AR.
Requirements:
* Find the issue creating the problem
* After you've verified that the we have a program fix for the issue found...
* Delete all ysnISUnposted from AR ONLY.
select intTransactionId, sum(dblDebit - dblCredit) from tblGLDetail
inner join tblGLAccount on tblGLDetail.intAccountId = tblGLAccount.intAccountId
where strAccountId like '1040-000'
and dtmDate > '2014-12-31 00:00:00.000'
and ysnIsUnposted = '1'
group by intTransactionId
[~liz.dorado] [~jeffrey.trajano] This might be a good opportunity also to verify all ysnISUnposted = 1 in Fort Books to verify that Debit = Credit. If not, determine where the problem is and fix.
|