The problem
When you find out you are out of stock, the customer is already on the bed.
Each branch has its own spreadsheet, the warehouse another. Nobody records what was used, so the count shows a shortage and nobody knows whether it was usage or loss.
- No view of what each branch still has
- Materials used in visits never deducted
- Batches sent that the other side never confirmed
The usual way
- 1Warehouse edits its Excel to subtract
- 2Message the branch on Zalo
- 3Branch edits its own file to add
- 4Month-end count shows a gap
- 5Go looking for who forgot
3 files, 2 people, a gap with no origin



