Risk management consulting and training provider
Approximately 10 people
Training operations and field logistics
350+ items across distributed locations
The company runs training programs across the United Kingdom and France, managing first aid kits, simulation gear, training materials, reusable assets, and consumables.
Equipment moves between a central hub, venue storage rooms, and mobile kits used during field sessions. Interns, freelancers, and on-site staff handle day-to-day logistics while operations are coordinated remotely.
The biggest challenge was ghost inventory. Items appeared available in Excel even when the actual stock position was different, and resolving discrepancies could require a full day of manual checking.
Result: A connected inventory and logistics system where receipts, transfers, kit preparation, item conditions, and location quantities are easier to track.
In practice, that meant:
The operation relied on Excel to track equipment, locations, quantities, movements, and field usage.
As training logistics expanded, more sheets were added for available stock, transfers, received goods, and kit preparation. Every update depended on someone entering the correct quantity in the correct place.
Excel remained familiar to the team, although it could not reliably show what was available at each location. Stock conflicts, missing items, and ghost inventory required manual checks before training sessions.
The company needed a simple system with stronger structure around receipts, transfers, location quantities, and controlled updates.
Each stock record connects an item to a specific location and quantity, giving the team a clear view across the central hub, venue storage rooms, and mobile setups.
Staff confirm complete or partial deliveries through a goods receipt workflow. Once posted, AnyDB updates the location quantity, creates a traceable record, and sends notifications.
Each pick list includes the source, destination, item lines, quantities, and transfer status. Completing it deducts stock from the source and adds it to the destination.
Reusable assets can be separated by condition, including active, damaged, repairable, obsolete, expired, or waiting for pickup. Consumables remain simple to manage.
Kit components, validation rules, controlled views, and clear notifications help interns, freelancers, and occasional users complete tasks without accessing the full system.
Excel completely replaced with a custom operational system
Clearer stock visibility across hubs, venues, storage rooms, and mobile kits
Fewer ghost inventory issues and stock conflicts before training sessions
Faster confirmation of received goods through guided actions
More reliable transfer tracking through clear source and destination records
