Separate available, reserved, and expected stock
An illustrative warehouse may physically hold an item that is already reserved for a job, while another unit is still on order. Those quantities answer different questions. Define item identifiers, units, locations, transaction dates, and adjustment authority so a team can understand what it can actually promise.

