NORMA Tool ๐Ÿ“Š Report Warehouse Finance

report_inventory_valuation โ€” Inventory Valuation

Total value of on-hand stock, valued at each item's cost price and rolled up by item group.

This is a Named SQL Query (SAP /SQLQueries) โ€” dynamic aggregate SQL returning per-query rows, not a fixed Service Layer entity.

Inventory-valuation report โ€” the total value of on-hand stock, valued at each item’s cost price and rolled up by item group. Returns one row per item group with group_name and total_value (sum of on-hand quantity ร— unit cost across the group’s stocked items), highest value first. A balance-sheet-style snapshot of how much capital is tied up in inventory. Only items that carry stock are included.

Try these prompts

  • “what is our inventory worth?”
  • “stock value by product group”
  • “how much capital is tied up in inventory?”
  • “inventory valuation by category”

ื ืกื• ื’ื ื‘ืขื‘ืจื™ืช

  • “ืžื” ืฉื•ื•ื™ ื”ืžืœืื™ ืฉืœื ื•?”
  • “ืฉื•ื•ื™ ืžืœืื™ ืœืคื™ ืงื‘ื•ืฆืช ืžื•ืฆืจื™ื”
  • “ื›ืžื” ื”ื•ืŸ ืชืงื•ืข ื‘ืžืœืื™?”

Arguments

No arguments.

Example result

$142k tied up in inventory. Finished Goods โ€” $96,000. Raw Materials โ€” $34,000. Packaging โ€” $12,000.

Result columns

ColumnTypeMeaning
group_nametextThe item group the stock rolls up to.
total_valuenumberOn-hand quantity ร— cost price, summed across that group’s stocked items.

Charts

  • bar: x=group_name, y=total_value, title=“Stock value by item group”
  • pie: x=group_name, y=total_value, title=“Share of stock value”
  • get_stock_coverage โ€” how long stock lasts, not its money value.
  • get_gross_margin โ€” profitability per item.