A warehouse is deceptively simple. From the outside it is just a big room where goods come in and go out. It seems any attentive person with an Excel spreadsheet could keep track of it. And while the warehouse is small, that is true. The storekeeper knows every box by sight, remembers that those three pallets arrived on Tuesday and the last pack of screws is on the top shelf on the left. Then the company grows. There are thousands of items, three storekeepers, two shifts, twenty suppliers. And one Friday evening a salesperson sells a customer a hundred units of a product that, according to the spreadsheet, the warehouse holds a hundred and twenty of, while in reality there are thirty. Where the other ninety went, nobody knows.
WMR, a system for organising warehouse accounting, appeared at Ingello precisely as an answer to Fridays like that. Today it is the warehouse accounting section of Forma, but the idea behind it has not changed, and I want to talk about the idea, because it will serve You with any system.
A warehouse is a city
I like to compare a warehouse to a city. A small village needs no addresses: everyone knows where the blacksmith lives and where the baker is. In a city of a million people, without streets and house numbers, the post would never arrive anywhere. A warehouse goes down the same path. While it is small, the storekeeper's memory is enough. When it grows, it needs addresses: every bin, every shelf, every storage location gets its own code, and every unit of stock in the system is tied to a specific address.
Addressed storage sounds bureaucratic, but it changes everything. A new employee finds goods on the first day without asking the old hands. A picker does not wander the warehouse searching, he follows the optimal route the system has built from the addresses. Stocktaking turns from an annual all-hands emergency into a calm section-by-section check. And when something goes missing, You can see at which address and after which operation the discrepancy began.
The life cycle of an item
A warehouse accounting system controls an item's path from receipt to shipment, and every step has its own traps.
- Receiving. The wrong item arrived, or the wrong quantity, or the wrong quality. If receiving is not checked against the purchase order, the supplier's mistake becomes Your mistake, and You find out about it when it is too late to file a claim.
- Putaway. The goods were placed "wherever there was room", while the system lists them somewhere else. This is the main source of "missing" stock.
- Batches and serial numbers. For products with an expiry date, electronics and spare parts, You need to know not only how many but which batch exactly. Otherwise the fresh stock ships and the expired stock rots in a corner.
- Transfers and write-offs. Between warehouses, into production, as defects, as samples. Every movement without a document is a hole in the books.
- Shipping. Picked, checked, shipped, and the balance drops at that very moment, not in the evening when the storekeeper remembers to enter the data.
Why Excel stops working
I have nothing against Excel, it is a wonderful tool. But a warehouse in Excel breaks not because the spreadsheet is bad but because the spreadsheet knows nothing about the process. It does not stop two people from writing off the same last box at the same time. It does not check that the item being sold actually exists. It does not remember who changed a number and when. It is not connected to sales, purchasing and accounting, so data is moved by hand, and every move is a chance for error.
A warehouse in a spreadsheet shows what should be on the shelves. A warehouse in a system shows what is actually there, and why the two numbers diverged.
On one project we ran the first stocktake after introducing the system, and the discrepancy with the spreadsheet was so large the owner did not believe it at first. We counted again. The numbers held. It was not theft, it was an error accumulated over years: unrecorded returns, undocumented write-offs of defects, goods "temporarily" moved and forgotten. Each mistake was small. Together they had distorted for years the picture the company used to buy and sell.
The warehouse as part of the system
The greatest value of warehouse accounting shows up when it is connected to the rest of the company. A salesperson sees the real balance while placing an order. A buyer sees that stock is running out before a customer asks. Production knows which materials are available. Accounting receives stock movements without anyone sending files around. That is exactly why in Forma warehouse accounting and stocktaking live in one data model with sales, purchasing and transit: an item that arrived from a supplier, went to an address, passed a count and left for a customer is one record with a full history.
Where to start
Run a small experiment this week: pick Your twenty fastest-moving items, count them by hand, then compare with what Your records show. If there are no discrepancies, Your warehouse is in good shape and You can sleep well. If there are discrepancies on even three items, it is time to think about a system. You can start with addresses: label the racks and tie the goods to storage locations. That alone often removes half the problems. After that comes a system that tracks every movement, so there are no more Friday surprises. Order in Your warehouse, colleagues.
