Purchase history by vendor
SQL query for MS Dynamics 365 Business Central (Private app)
List total purchase amount for each vendor.
SELECT Vendors.Name, SUM(PurchaseInvoices.Amount) AS TotalPurchaseAmount FROM Vendors JOIN PurchaseInvoices ON Vendors.ID = PurchaseInvoices.VendorID GROUP BY Vendors.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