A Stock Transfer Required 3 Phone Calls, 2 Emails, and a Prayer. The Prayer Wasn't Answered.
A building materials wholesaler in Al Quoz operated 2 warehouses 4 kilometers apart. Warehouse A held bulk stock. Warehouse B served walk in customers from a retail front. Transfers happened 3 to 5 times per week. Each transfer required 3 phone calls, 2 emails, and a prayer that someone on the other end recorded it.
How AED 75K Went Missing
The prayer usually wasn't answered. The process looked like this. Warehouse B runs low on cement bags. The supervisor calls Warehouse A. "Send 200 bags." Warehouse A loads a truck. The driver delivers. Someone at Warehouse B signs a paper slip. The paper slip goes into a drawer. Nobody enters the transfer in the system. Warehouse A's inventory doesn't decrease. Warehouse B's inventory doesn't increase. The system still shows 200 bags at A and zero at B even though the physical reality is the opposite. This happened 180 times in one year. Not all transfers were missed. But 40% were entered late, 25% were entered with wrong quantities, and 15% were never entered at all. At year end, the combined stock discrepancy across both warehouses was AED 75,000. Stock that existed in one warehouse but was recorded in another. Or recorded nowhere. The annual stocktake took 4 days instead of 2 because half the discrepancies were transfer related. The warehouse teams blamed each other. Warehouse A said "we sent it." Warehouse B said "we never received that quantity." The paper slips in the drawer either confirmed or contradicted depending on which ones you could find. Several were illegible. Two were missing entirely.
What They Tried
They tried a shared Google Sheet for tracking transfers. Both warehouses were supposed to update it. Within a month, the sheet had conflicting entries. A sent 200 bags on March 3. B received 180 bags on March 5. Nobody investigated the 20 bag difference because nobody owned the reconciliation process. The sheet became a third source of wrong data. They tried requiring the driver to carry a printed transfer form with carbon copies. One copy stays at A, one goes to B, one comes back to the office. The carbon copies were hard to read. The forms ran out after 6 weeks and nobody reordered them. The process reverted to phone calls.
What Solved It
ERPNext stock entry with material transfer type. Warehouse A creates a stock transfer in the system. The transfer specifies items, quantities, source warehouse, and target warehouse. Upon submission, inventory at A decreases and inventory at B increases simultaneously. One transaction. Both warehouses updated. No phone calls. The driver carries a printed transfer note generated by the system with a barcode. Warehouse B scans the barcode at receiving to confirm. If quantities don't match, the receiving team rejects and creates a partial receipt. The discrepancy flags immediately for investigation while the driver is still at the dock. A professional implementation configured the transfer workflow, trained both warehouse teams, and installed a barcode scanner at Warehouse B within week 2 of deployment. Total hardware investment: AED 500 for the scanner. Total process setup: 3 hours.
The Outcome
Transfer recording accuracy went from 60% to 99% in the first month. Year end stocktake discrepancy dropped from AED 75,000 to AED 8,000. The remaining AED 8,000 came from non transfer sources that were separately identifiable and correctable. Stocktake duration fell from 4 days to 1.5 days because the transfer reconciliation problem no longer existed. The warehouse teams stopped blaming each other because the system showed exactly who sent what, when, and who received it. At AED 1,999 per month, the multi warehouse module with stock transfers is a core feature. For any company operating more than one storage location, it eliminates the phone call, email, and prayer method that loses inventory in the gap between what was sent and what was recorded. Every business with multiple warehouses has a version of this story. The details change. The AED 75K changes. But the pattern is identical: transfers happen physically faster than they get recorded digitally, and the gap costs real money every single time.
Ready to run on a real system?
Book a 15 minute call. We will show you exactly how OSForBiz replaces the spreadsheet chaos.