Entry 3816

DataBlox QuickBooks

Submitted by Scott Treseder on May 12, 2010 at 2:53 p.m.
Language: SQL. Code size: 462 bytes.

select cCustJob.nKey,
  sFullName, mBalance, sum(aTranLine.mAmount) as SumOfmAmount,
  mBalance - sum(aTranLine.mAmount) as Difference,
  count(aTranLine.mAmount) as CountOfmAmount

from cCustJob inner join aTranLine
on cCustJob.nKey = aTranLine.kEntity

where (aTranLine.kAcct in (
    select nKey from aAccount where sAcctType = 'AcctRec'
    ))
  and
    aTranLine.bNoPost = False

group by cCustJob.nKey, sFullName, mBalance
order by sFullName

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).