Entry 4777

QuickBooks (DataBlox) SQL - Query

Submitted by DataBlox on June 5, 2010 at 3:28 p.m.
Language: SQL. Code size: 299 bytes.

SELECT
  kEntity, sTranType, sItemType,
  COUNT(*) AS SaleLineCount,
  SUM(mAmount) AS sum_mAmount

FROM aTranLine

WHERE
  sTranType IN
    ('CashSale','CustInvc','CustChrg','CustCred')
 AND
   bDocMain = False
 AND
   sEntity2Type = 'CustJob'

GROUP BY kEntity, sTranType, sItemType

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).