Profit margin on sales orders - Visma Net (Visma.net) SQL Query - Peliqan

Profit margin on sales orders

SQL query for Visma Net (Visma.net)

Calculate the profit margin for each sales order.

SELECT salesorders.orderNumber, ((SUM(salesorders.totalAmount) – SUM(salesorders.costAmount)) / SUM(salesorders.totalAmount)) AS profit_margin FROM salesorders GROUP BY salesorders.orderNumber

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.