inventory-valuation-report

Generates inventory valuation reports by SKU and category with optional GL reconciliation.

1|Updated Jun 21, 2026
One-click install
npx skills add https://github.com/tapway/shogun-os --skill inventory-valuation-report-tapway
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: inventory-valuation-report
Source: https://github.com/tapway/shogun-os/tree/main/skills/procurement/inventory-valuation-report
Command: npx skills add https://github.com/tapway/shogun-os --skill inventory-valuation-report-tapway

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve? Finance and procurement teams need an accurate, on-demand snapshot of total inventory value for period-end close and executive reporting, but manually computing stock value across hundreds of SKUs and reconciling it against the general ledger is slow and error-prone. ## Core Features & Use Cases - Per-SKU and Category Valuation: Reads all inventory items from the gbrain procurement source and computes total stock value as sum(current_stock × unit_cost), with a category-level breakdown and top-10 SKU ranking. - GL Reconciliation: When ENABLE_ACCOUNTING_SYNC=true, compares the computed valuation against the GL Inventory Asset balance via acct_get_balance_sheet and flags variances beyond configurable tolerances. - Standalone Script & Cron Support: Run scripts/inventory_valuation.py directly, via the /inventory-valuation slash command, or on a weekly Friday cron; reports are archived to procurement/reports/ and delivered to Slack. - Use Case: A CFO requests the current inventory value before month-end close. The procurement-manager agent runs the script, produces a formatted MYR valuation report, confirms GL reconciliation passed, and posts it to #procurement. ## Quick Start Ask the procurement-manager agent to generate the inventory valuation report for today and deliver it to the procurement Slack channel.

Frequently Asked Questions about inventory-valuation-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate an inventory valuation report by SKU and category?

Run scripts/inventory_valuation.py directly or trigger the /inventory-valuation slash command on the procurement-manager profile. The script reads all inventory items from the gbrain procurement source, computes sum(current_stock × unit_cost), and prints a per-SKU table with a category breakdown.

How does inventory valuation reconcile against the general ledger?

Set ENABLE_ACCOUNTING_SYNC=true and the report compares the computed stock valuation against the GL Inventory Asset balance from acct_get_balance_sheet. Variances beyond the tolerance (default MYR 500 or 1%) are flagged; otherwise reconciliation shows PASSED.

What happens when the inventory source is empty?

The script prints the report header with a 'No inventory items found' message and exits with code 0. It never crashes on an empty gbrain procurement source, so cron jobs remain safe.

Does the valuation include inactive inventory items?

No. Items with status set to inactive are skipped during computation and do not contribute to the total valuation, SKU count, or category breakdown.

When should I not use the inventory valuation report?

Do not use it for reorder alerts or dead stock analysis. Use reorder-alert-watchdog for replenishment triggers and dead-slow-stock-detector for identifying slow-moving inventory instead.