Inventory Performance & Control

Source quantities and values are loaded with their original signs. Missing UOM and other row issues are flagged without rejecting the workbook. Analysis alone computes issues, returns, net consumption and allocations. Quantity: negative = issue; positive = return. Ledger amounts retain their original signs. Analysis classifies issue and return values by Transaction Type and uses their magnitudes; source ledger amounts are never recalculated from unit cost. Net consumption = issues less returns. Fast-moving rankings count issue transaction rows within the selected activity period; they do not add incompatible UOM quantities.

Age is measured from Creation Date (Oldest) to the selected stock date. Aged values use exact lot or compatible unique scope cost, then a weighted pool cost for multiple costs with matching item, business unit, organization, subinventory and UOM. Supported allocations are totalled even when some rows remain unmatched; unmatched results display 0 with an explanation. See Calculation Rulebook. This date does not establish the age of every unit.

Category on issuance rows is matched from a unique item / business-unit category in the selected stock and valuation reports. The supplied issuance report has no organization or subinventory fields: applying those filters excludes transactions without those fields. No stock location is inferred for consumption.

Stock cover and replenishment review use complete selected consumption coverage and an explicit lead-time / safety-days policy. These are planning scenarios: open POs, reservations, criticality and future project demand must be checked before ordering. Financial turnover and inventory days remain unavailable pending costing reconciliation. Missing periods are not filled with zeros. Movement residual assumes opening + receipts + signed issues = closing; verify adjustments and signs before interpreting it.

Imports are stored in the selected local inventory-db.json file. Export backups to retain a separate copy. Older imported data is preserved during migration. Current folder permission may require renewal after reopening in desktop Chrome or Edge.