Demo 3.4: Catalog & Inventory Branch (Catalogue Management & Portfolio)

Functional Objective: Covers the central Catalogue Management System (CMS) governing 10,000+ SKUs across 7 distinct categories (FMCG Consumer Pack Toiletries, Household, General; Regulated Supplies Food & Beverages; High-Value Capital Goods Vehicles & White Goods). Manages Bank Guarantee (BG) coverage limits, Label Registration (LR) state excise permits, shelf-life monitoring, one-to-one replacements, and product discontinuation with automatic debit notes.

🎥 Video Walkthrough & Feature Tour

Master Catalogue (CMS), BG Limit Tracking & Product Lifecycle

Demonstrates 7-category index derivation, automated Bank Guarantee exposure checks, State LR excise tagging, and product discontinuation debit notes.

📋 Core Functional Capabilities

7-Category Hierarchy: Generic Code grouping (with HSN mapping) and automated Index Number generation across FMCG Consumer Pack 1-3, Regulated Supplies 4-6, and High-Value Capital Goods 7.
Bank Guarantee (BG) Guardrails: Dynamic BG limit calculation against open purchase orders; automatic ordering locks if order value exceeds BG coverage.
Regulated Commodities Label Registration (LR): Multi-state LR permit tracking (source state to destination distribution center), excise duty and local cess auto-calculation.
Lifecycle & Discontinuation: 4 discontinuation triggers (annual sales <2%, voluntary supplier withdrawal, customer quality complaints via Market Intelligence Unit, 3 consecutive delivery failures) triggering automated liquidation and F&A debit notes.

🏗️ Technical Architecture & DocType Mapping

In Business M and Framework M, this domain is powered by native, metadata-driven DocTypes, async controllers, and distributed ledger adapters:

Active Business M DocTypes

Item, ItemGroup, PriceList, ItemPrice, BankGuarantee, PriceRevisionRequest, Permit, VarianceThreshold

graph LR
    User["Stakeholder Portal / Desk"] --> Gateway["API Gateway"]
    Gateway --> Controller["Domain Controller & RBAC"]
    Controller --> DB[("PostgreSQL / RLS Master")]
    Controller --> Relay["Outbox Relay Worker"]
    Relay --> TB[("TigerBeetle Immutable Ledger")]

🧪 Verifiable Test Script (Human Review Flow)

Follow these steps in the running Business M instance to replicate the live PoC demonstration (mapped directly from end-to-end test automation):

Create Item: Herbal Public Sector Soap (HSN 330510, FMCG Consumer Pack)
Link supplier Apex Enterprise: Supplies, set stock_uom=Nos, case_pack=24
Set procurement rate ₹135,: distribution center issue rate ₹140, Retail Outlets retail rate ₹150 in PriceList
Record Bank Guarantee BG-SBI-2026: for ₹50,00,000 via BankGuarantee
Record State Excise LR: permit for regulated commodities SKU via Warehouse list
Configure shelf-life: shelf_life_days=365, alert_threshold_percent=50
Process annual price revision: via PriceRevisionRequest with MRU validation
Simulate discontinuation: review Item status in catalogue
Verify system blocks new: Purchase Orders for the obsolete item across all depots
Verify automatic debit note: created against vendor Bank Guarantee for remaining inventory