Open receivables by account

Dispensary accounts with the most money open, excluding brand partners

25 rows · rendered 2026-11-19 06:10 · garden_state · saved 2026-09-21 08:36
Show the SQL
select customer_name, round(sum(balance)) as open_balance, count(*) as invoices from v_invoices where balance > 0 and customer_name not ilike '%Kitchen Share%' group by all order by 2 desc limit 25