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
Thanks to Ed Monk of SBONotes.com
Comments for SAP Business One: New Jersey, NJ Open Balances by Customer
There are no comments yet.