Click a card for every PO, line, outstanding, lost and SKU detail for that platform.
Inventory vs required (45d domestic / 90d imported norm, from actual PO pace)
Value to order — by category
Still to land (Pending + Intransit, all months) by platform & status
Still to land PO-level detail
Lost (never shipped) by platform & status
Lost PO-level detail
Performance
Fill rate by month & platform
Month-over-month PO volume
SKU-wise PO vs invoiced
Platform × location → warehouse (as seen in the tracker)
PO → appointment / dispatch TAT, by platform & courier
PO-wise appointments & LR no.
Stock on hand with little/no dispatch in 30 days
Stock value — by category
Stock value — by facility (warehouse)
Stock — SKU-wise, with category, facility & cost
Build a custom report
Pick a data source, then filter by date, month, SKU, platform, warehouse — anything — using the filter box that appears above the table. Download the exact rows you see as CSV (opens in Excel).
Pick a data source above to see its columns and start filtering.
Definitions
Fill rate
Invoiced qty ÷ PO qty, measured ONLY on lines that have actually been dispatched (invoice date present, or status Intransit/Delivered). A PO not yet due is not counted as a shortfall. Always shown with "coverage %" — the share of dispatched qty that actually had an invoice qty recorded.
Still to land
Pending + Intransit POs, tracked across ALL months — this ignores whatever month you're looking at, by design.
Lost
Cancelled, Expired, RTO, No Stock, Low value, or Hold with no invoice date.
Warehouse
Derived from platform + tracker location, via the 300+ platform-DC map. Connect My B2B Mumbai, Edgistify Mumbai (Bhiwandi), Edgistify Delhi, Connect My B2B Bangalore, Max Retail Kolkata.
Month
The source tab the row came from in the PO Tracker — never derived from a date.
Value
PO value is WITH GST. Spread from the PO-level register onto its SKU lines by quantity.
Scope note
Courier invoice cost and warehousing cost are not shown here yet — those come from separate mail/sheet sources not yet synced into this database.