Query to Show Open Balances by Customer (or Vendor)

Use this query to show you a list of open balances by customer group. If you would like to see

open balances by vendor, then change the Where clause to cs.cardtype = 'S'.

/* Shows the open balances by Customer Group */
SELECT gp.GroupCode, gp.GroupName, Sum(cs.Balance) 'Open Balance'

FROM OCRD cs
INNER JOIN OCRG gp ON gp.GroupCode = cs.GroupCode

WHERE cs.CardType = 'C'

GROUP BY gp.GroupCode, gp.GroupName
ORDER BY GroupName
FOR BROWSE