Skip to main content

Peliqan

Try for free
Request a demo

Inventory Value by Item Category

SQL query for Microsoft Dynamics 365 Business Central

Get the total inventory value for each item category.

SELECT ItemCategories.CategoryName, SUM(Items.InventoryValue) AS TotalInventoryValue FROM ItemCategories INNER JOIN Items ON ItemCategories.CategoryID = Items.CategoryID GROUP BY ItemCategories.CategoryName

Try this query now in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central data model

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