Developed an application for a UK-based logistics company to improve inventory control, using SQL Server CE and .NET framework, so that the application can store structured data within the handheld mobile scanning devices.
Customer Size: Medium
Solution: Net 3.5 Compact Framework, SQL Server CE
The client is a logistics company whose important task include integration of information, transportation, inventory management, warehousing and material handling.
Being a logistics company, Integration of information includes tasks such as updating goods details, delivery status, purchase orders, invoices etc. These data is used for business intelligence and decision about cost cutting, transportation mode, transportation route, cost, flow of goods etc. When done manually there is a high possibility of error that can be end up in an expensive mistake.
Hence to improve efficiency and overall profit, the company wanted a solution that could automate these tasks.
Cygnet developed a mobile solution and desktop solution for complete solution for the client.
Using .NET 3.5 CF & SQL Server CE, Cygnet developed a mobile application, which imported purchase orders and details of customers, their order etc. into hand-held barcode reader. This information was used for planning transportation routes and modes of transportation.
Inventory of the shipments was balanced by scanning the goods at warehouse and at clients' location by handheld barcode reader. Also when the mobile application was synchronized to central database via web services, it balanced stock inventory and integrated information that could be further used by accounts department to create status report, invoices, etc.
We also integrated desktop application with central database to Sage Account products for accounting purposes. Desktop application also created barcode, printed barcode and generated reports.
- Improved tracking ability for client
- Increased efficiency as errors due to manual entry were eliminated
- Improved business intelligence
- Easier data access