Total revenue per customer
SQL query for FortNox
Calculate the total revenue for each customer.
SELECT customers.name, SUM(invoices.amount) AS total_revenue FROM customers JOIN invoices ON customers.id = invoices.customer_id GROUP BY customers.name
FortNox data model
Financialyears
Absencetransactions
Attendancetransactions
Accounts
Articles
Article Details
Company Information
Contracts
Currencies
Customers
Customer Details
Costcenters
Employees
Expenses
Incominggoods
Invoices
Invoice Details
Invoiceaccruals
Invoicepayments
Locked Period
Labels
Modesofpayments
Offers
Orders
Pricelists
Prices
Productionorders
Projects
Purchaseorders
Salarytransactions
Stockbalance
Stockpoints
Stocktaking
Suppliers
Supplierinvoices
Supplierinvoiceaccruals
Supplierinvoicefileconnections
Wayofdeliveries
Vouchers
Voucher Rows
Voucherseries
Account Charts
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