Peliqan Logo
Login
Request a demo

MS Dynamics 365 Business Central (Private app)

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

Try this query now in MS Dynamics 365 Business Central (Private app)

MS Dynamics 365 Business Central (Private app) data model

MS Dynamics 365 Business Central (Private app)
Table Items

MS Dynamics 365 Business Central (Private app)
Table Item Categories

MS Dynamics 365 Business Central (Private app)
Table Customers

MS Dynamics 365 Business Central (Private app)
Table Customer Payments

MS Dynamics 365 Business Central (Private app)
Table Customer Payment Journals

MS Dynamics 365 Business Central (Private app)
Table Customer Financial Details

MS Dynamics 365 Business Central (Private app)
Table Contacts

MS Dynamics 365 Business Central (Private app)
Table Vendors

MS Dynamics 365 Business Central (Private app)
Table Company Information

MS Dynamics 365 Business Central (Private app)
Table Locations

MS Dynamics 365 Business Central (Private app)
Table Accounts

MS Dynamics 365 Business Central (Private app)
Table Sales Invoices

MS Dynamics 365 Business Central (Private app)
Table Sales Invoice Lines

MS Dynamics 365 Business Central (Private app)
Table Journals

MS Dynamics 365 Business Central (Private app)
Table Journal Lines

MS Dynamics 365 Business Central (Private app)
Table General Ledger Entries

MS Dynamics 365 Business Central (Private app)
Table General Ledger Setup

MS Dynamics 365 Business Central (Private app)
Table Item Ledger Entries

MS Dynamics 365 Business Central (Private app)
Table Currencies

MS Dynamics 365 Business Central (Private app)
Table Sales Orders

MS Dynamics 365 Business Central (Private app)
Table Purchase Invoices

MS Dynamics 365 Business Central (Private app)
Table Purchase Orders

MS Dynamics 365 Business Central (Private app)
Table Inventory Posting Groups

MS Dynamics 365 Business Central (Private app)
Table General Product Posting Groups

MS Dynamics 365 Business Central (Private app)
Table Aged Accounts Receivables

MS Dynamics 365 Business Central (Private app)
Table Aged Accounts Payables

MS Dynamics 365 Business Central (Private app)
Table Sales Credit Memos

MS Dynamics 365 Business Central (Private app)
Table Sales Credit Memo Lines

SQL - Combine data

Magical SQL for MS Dynamics 365 Business Central (Private app) with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

  • PBI LogoCreated with Sketch. Power BI
  • Metabase
  • Tableau

Let AI do the work for you

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Overview

Ready to get instant access to
all your company data ?

Book a demo