BlogInventory
Real-time inventory: how to know what’s in stock without counting.
Real-time inventory is accurate only if every movement is recorded where it happens, as it happens. Software is needed, but recording discipline matters more.
What “real-time inventory” means
Real-time inventory means the number on screen matches what’s on the shelf, without waiting for the end of the day or month.
It matters for three questions asked every day. Can we promise this order? Do we need to buy material? Where is the stock?
If the answer needs a call to the warehouse or a look at three files, your inventory isn’t real-time.
Real-time doesn’t have to mean sensors and automation. In a small or mid-sized company it means a record made straight away, by the right person.
For example, a sales rep sees stock on their phone while with a customer and promises a date without calling anyone.
Why the spreadsheet always lags behind
In Excel, stock is updated when someone sits down to enter the movements. Usually in the evening, on Friday, or when they remember.
Hours pass between the goods and the record. Meanwhile sales sells something already shipped, and purchasing orders something that has already arrived.
- A delivery sits on the dock but hasn’t been booked in.
- Material was taken for production but not issued.
- A shipment has left but isn’t recorded.
- Scrap was thrown away but still counts as stock.
Each of these delays is small on its own. Together they make the spreadsheet number approximate and the decisions based on it risky.
The result is familiar: calls to the warehouse, checks “on the spot” and promises that later get cancelled.
Which movements must be recorded
Stock is the result of movements. If one door of the warehouse isn’t tracked, the number will drift.
- Receiving a delivery from a supplier.
- Issuing material to production.
- Booking in finished goods.
- Shipping to a customer.
- Returns from customers or to suppliers.
- Transfers between warehouses or zones.
- Scrap and adjustments after a count.
Check: walk through every door of the warehouse in your head. For each one you should know who records the movement and when.
The most often forgotten are scrap and transfers between warehouses. They don’t involve money straight away, so they seem unimportant.
For manufacturers, issuing materials is the hardest part. Decide whether material is issued by recipe when output is reported, or by the quantity actually taken.
Record it where the goods are
The further the record is from the goods, the bigger the delay. So the movement is entered by the person doing it, not by a colleague in the office.
In practice that means a phone or tablet in the warehouse and a simple screen. Scan a code, enter a quantity, confirm. If recording takes more than a minute, people will put it off.
Better still, the movement is created from a document that exists anyway. For example, shipping issues the goods from the order, with no separate entry.
Not everyone in the warehouse likes screens. So the screen should show only what’s needed: item, quantity, location.
If a step needs a paper signature, keep the paper, but enter the movement right after the signature.
On hand, reserved and available stock
The number “we have 100” isn’t enough. For sales, what matters is how many are available.
For example, there are 100 on the shelf. 60 are reserved for confirmed orders and 30 are arriving on Thursday. Available for a new customer today: 40, rising to 70 by Friday.
- On hand: how many are on the shelf.
- Reserved: how many are promised on confirmed orders.
- Available: on hand minus reserved.
- Projected: available plus what’s on order from suppliers.
Without reservations, two sales reps can promise the same 40 units to two different customers.
Projected stock helps with delivery promises. If the customer can wait until Friday, you can sell more than you have today.
Example: one day in the warehouse
For example, in the morning there are 500 rolls of film on the shelf. The numbers are hypothetical.
- At 9:00, 200 rolls arrive. The storekeeper receives them against the purchase order and stock goes to 700.
- At 10:30, the shop floor takes 150 rolls for a work order. They are issued as they are taken and stock is 550.
- At 13:00, a sales rep confirms an order for 400 rolls. They are reserved and 150 remain available.
- At 15:00, the first 100 rolls on that order ship. There are 450 on the shelf, 300 of them reserved.
If another customer asks for 200 rolls at 14:00, the rep sees straight away that 150 are available. Without real-time records they would see 500 and promise.
How to start, and what to avoid
The opening count is the most important step. Without a correct starting point, every later movement just carries the old error forward.
Start with one warehouse or one group of items. Once the numbers there are right, expand.
To keep the number right over time, add regular cycle counts. How to do that without stopping work is in the article on cycle counting.
While you build the new routine, avoid four common mistakes:
- Correcting by overwriting the number, with no document or reason.
- Recording movements in a batch at the end of the shift.
- One shared login for the whole warehouse, so nobody knows who did what.
- Goods that are physically in the warehouse but “haven’t gone through” the system yet.
Each of these looks like a time saver. Later it costs hours of hunting for differences.
If you recognise two or more, start there before you think about new software.
How we approach it
In Leanovix, goods are received against the purchase order, in full or in part, and stock goes up right away. Stock is kept by warehouse or location, and an approved order reserves the quantity it needs. More on the inventory module.