Total sales revenue by customer
SQL query for Visma Net (Visma.net)
Calculate the total sales revenue generated by each customer.
SELECT customers.customerName, SUM(customerinvoices.totalAmount) AS total_sales_revenue FROM customers JOIN customerinvoices ON customers.customerId = customerinvoices.customerId GROUP BY customers.customerName
Visma Net (Visma.net) data model
Accounts
Customers
Suppliers
Supplierinvoices
Supplierinvoicelines
Customerinvoices
Customerinvoicelines
Customerbalances
Customercreditnotes
Currencies
Currencyrates
Customerpayments
Customerdebitnotes
General Ledger Balance
Ledgers
General Ledger Transactions
Purchaseorders
Salesorders
Inventoryitems
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