Total inventory value by location
SQL query for MS Dynamics 365 Business Central
Calculate the total inventory value by location.
SELECT Locations.Name, SUM(Items.InventoryValue) FROM Locations JOIN Items ON Locations.LocationID = Items.LocationID GROUP BY Locations.Name
MS Dynamics 365 Business Central 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
Purchase Invoices
Purchase Invoice Lines
Journals
Journal Lines
General Ledger Entries
General Ledger Setup
Item Ledger Entries
Currencies
Sales Orders
Purchase Orders
Inventory Posting Groups
General Product Posting Groups
Aged Accounts Receivables
Aged Accounts Payables
Dimensions
Dimension Values
Sales Credit Memos
Sales Quotes
Sales Quote 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