Inventory valuation
SQL query for Cin7 Omni
Calculate the total value of inventory items in stock.
SELECT SUM(inventoryitems.unitPrice * inventoryitems.quantityInStock) AS inventory_valuation FROM inventoryitems
Cin7 Omni data model
Adjustments
Branches
Branch Transfers
Bom Masters
Contacts
Credit Notes
Payments
Products
Product Categories
Production Jobs
Purchase Orders
Quotes
Sales Orders
Serial Numbers
Size Ranges
Stocks
Users
Vouchers
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