Total sales by customer
SQL query for MS Dynamics 365 Business Central (Private app)
Get the total sales amount for each customer.
SELECT customer.name, SUM(outgoinginvoice.amount) AS total_sales FROM customer JOIN outgoinginvoice ON customer.id = outgoinginvoice.customer_id GROUP BY customer.name
MS Dynamics 365 Business Central (Private app) data model
Items
Item Categories
Customers
Customer Payments
Customer Payment Journals
Customer Financial Details
Contacts
Vendors
Company Information
Locations
Accounts
Sales Invoices
Sales Invoice Lines
Journals
Journal Lines
General Ledger Entries
General Ledger Setup
Item Ledger Entries
Currencies
Sales Orders
Purchase Invoices
Purchase Orders
Inventory Posting Groups
General Product Posting Groups
Aged Accounts Receivables
Aged Accounts Payables
Sales Credit Memos
Sales Credit Memo Lines
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