Invoices by account
SQL query for Billit
Count the number of invoices per account.
SELECT Account_Information.account_id, COUNT(invoices.invoice_id) AS num_invoices FROM Account_Information LEFT JOIN invoices ON Account_Information.account_id = invoices.account_id GROUP BY Account_Information.account_id
Billit data model
Parties
Account Information
Documents
Invoices
Invoice Lines
Products
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed