BizMagnet Logo

Inventory Tracking Reports

Variant stock as a grid, and the full history of any batch.

Variant Stock Matrix

Menu: Inventory Tracking → Reports → Variant Stock Matrix (also the grid icon on a row in Item Variants).

Shows stock of every variant of one product as a grid. Choose the product, and optionally a Branch (empty = all branches).

Variant Stock Matrix · POLO SHIRT
SMLXLTotal
Black4107223
White065112
Navy380213

Variant Stock Matrix: colours down, sizes across

Batch transactions

Where: Item Attribute Values → pick the item → Tracking → click a row of the batch table.

Every posted movement of that batch, oldest first, with a running balance. Switch on All branches to follow a batch through transfers. An Unposted tag marks the reversal of a document that was unposted. The stock that existed when tracking started shows as Opening (tracking switched on).

Batch transactions · P2610A · All branches
All branches
DateBranchDocumentPartyInOutBalance
2026-10-201001APP.PUR.PUR 231S001266
2026-10-201001APP.SAL.INV 980C045024
2026-10-211001APP.STK.TFO 77100222
2026-10-211002APP.STK.TFO 77100124

Batch transactions: purchase, sale and a transfer, followed across branches

Video coming soon

Trace a batch

This video will show: the Variant Stock Matrix of a product, and the history of one batch across branches.

Coming: batch stock across all items with branch and expiry filters, and an expiry report (batches expiring within N days).
inventory-tracking-reports | BizMagnet ERP