SAP Business One 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
Thanks to Ed Monk of SBONotes.com
This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.
« SAP Business One Alerts Check for BP Tax Codes | Home | SAP Business One Sales Commissions »
July 30, 2010
by: Wayne Schulz • Epicor, Publishers, Schulz Consulting
July 24, 2010
by: Wayne Schulz • 90minds
July 21, 2010
by: Wayne Schulz • FAQ, Sage MAS 200, Sage MAS 90, Schulz Consulting
July 20, 2010
by: Wayne Schulz • 90minds, Alnoor Cassim
July 19, 2010
by: Brett Zimmerman • Consultant, ERP, ERP Tools, FAQ, General Technology, MAS 200 Extended Enteprise Suite, Sage, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Uncategorized, add ons
July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence
July 21, 2010
by: Wayne Schulz • FAQ, Sage MAS 200, Sage MAS 90, Schulz Consulting
July 19, 2010
by: Brett Zimmerman • Consultant, ERP, ERP Tools, FAQ, General Technology, MAS 200 Extended Enteprise Suite, Sage, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Uncategorized, add ons
July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence
July 1, 2010
by: Wayne Schulz • 90minds, News, Sage, Sage MAS 90
June 24, 2010
by: Brett Zimmerman • Consultant, FAQ, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Schulz Consulting, Uncategorized
June 14, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized
July 21, 2010
by: Wayne Schulz • FAQ, Sage MAS 200, Sage MAS 90, Schulz Consulting
July 19, 2010
by: Brett Zimmerman • Consultant, ERP, ERP Tools, FAQ, General Technology, MAS 200 Extended Enteprise Suite, Sage, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Uncategorized, add ons
July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence
June 24, 2010
by: Brett Zimmerman • Consultant, FAQ, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Schulz Consulting, Uncategorized
June 14, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized
June 4, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized, jobops
Leave a Comment
You must be logged in to post a comment.