Orders & inventory · 06 / 20
Multi-location inventory ledger
A warehouse-by-SKU stock matrix with ageing, ABC-XYZ, and a movement trail per cell.
What actually changes
Know exactly why your stock counts disagree across locations, down to the transaction.
Stock counts across five locations don't match and nobody can trace back far enough to say why.
See stock ageing by SKU and location before old inventory quietly becomes dead stock
Spot which SKUs are your true ABC-XYZ priorities instead of treating every item the same
Trace any single cell back to the exact GRN, pick, or adjustment that changed it
What was built
A ledger matrix with ageing buckets, ABC-XYZ tags, and a per-cell GRN/pick/adjust trail.
Result
5×60
location × SKU matrix
The mechanics
How this actually runs, step by step.
- 1Stock is tracked per warehouse × SKU, not as one blended company-wide number.
- 2Every GRN, transfer, pick, adjustment, and return is logged against that cell.
- 3Ageing buckets and ABC-XYZ tags are derived from the same ledger, not a separate exercise.
- 4Cycle counts are compared against system quantity to rank the highest-value mismatches.
Stock ledgerAgeing bucketsABC-XYZ