A leading medical and pharmaceutical supplier required a highly reliable, mobile-first inventory validation system to eliminate order picking errors without exposing their live production Firebird database. Mismatches were going undetected because staff had no fast way to verify that what had been picked and packed actually matched what the order required. Manual cross-checking was slow, inconsistent, and impossible to scale, so they needed a mobile-first verification solution that worked seamlessly with their existing Zebra scanners. To design and build it, they partnered with Artesian Software Technologies.
We delivered a highly secure, three-phase warehouse verification system. First, we established a secure, read-only data mirror from their Firebird database into Microsoft Dataverse using a custom .NET 8 application. Next, we built a WinUI 3 Windows desktop app that prints a verification dispatch slip for each job, listing everything expected to be picked, with a QR code for fast scanning. Finally, we deployed a custom Power Apps Canvas mobile app tailored for their Zebra scanner devices. This allows warehouse staff to instantly validate each scanned item against target quantities in real time, drastically improving order accuracy and operational speed.
