SAP Business One Support and Tips

Here’s a quick tip.  Use the query below to get a nice report of one line per Group, per Business Partner of their current open Balance.  You can sign up for many tips like this at our new SAP Support Site at:

If you need help with the Query Generator, click the Chat button at the bottom of the page.


Query Generator – Summary of Business Partner Balance by BP Group Code

SELECT T0.[GroupCode], T1.[GroupName], SUM(T0.[Balance]) AS ‘Balance’
FROM OCRD T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode
WHERE T0.[CardType] =[%0]
GROUP BY T0.[GroupCode], T1.[GroupName]
ORDER BY T1.[GroupName]