ACF Environmental is a leading supplier of geosynthetic solutions for the construction industry. They have many locations spanning several states along the east coast. ACF has a large legacy system which handles their inventory and sales processes. ACF had two specific necessities that their systems just could not provide because they were not available or just too expensive to deploy.
First, they desired a way to provide up-to-date sales information to their managers located in various sales offices. This feature would significantly improve sales operations. They were using emails with attachments to send the sales team daily reports about their sales activities. Unfortunately, these reports were static and didn’t give the sales managers the ability to query the information they were searching for. They had to peruse the entire report to find the information and this took time. They also lacked strategic reports to help them evaluate their own performance.
They also desired a better way to generate and track their shipping information to improve accuracy and cost of shipping. There was no system that provided this capability so the entire process was managed and tracked on paper.
The ACF sales system was a form based management system that does not provide API features. It does provide limited ODBC access to its database. We determined the best solution was to extract sales data nightly and port it into a much more robust SQL Server database. This database acts as the back end to a dynamic website that allows the sales team to access critical sales information.
A secure, login based, website containing several webpages was developed to provide necessary data to all the sales managers, giving them access to critical information necessary to manage their sales teams. These web pages provide ad hoc search capabilities that allowed the managers to get to the information quickly from their laptops or desktops.
The managers now have easy access to quotes, sales orders, and customer contact information. They were also provided a dashboard showing each sales manager’s performance data. The site also supports print features so they could reprint quotes and sales documents without requesting them from corporate.
We also provided a shipment management system as a separate website that provides the logistics team with the ability to create and track all their shipments. The site also includes audit functions used by ACF to validate shipping records. A variety of shipping and auditing reports were provided to allow ACF to monitor their business.
The final result was that ACF was able to augment their legacy system and provide additional capabilities to field sales personnel and in house shipping personnel to improve customer service and sales without replacing any major systems or spending astronomical amounts of money.
Arkay Packaging is a package production company with a long tradition of excellence. They provide the highest quality folding cartons to some of the most recognized companies in the world.
Arkay necessitated the mobilization of their warehouse inventory system to better track inventory coming off of their factory floor and within their warehouse. The system needed to track the creation, release and removal/shipping of these items.
Arkay already had a system that was capable of tracking their warehouse inventory, but this system was not capable of utilizing mobile devices. We augmented the Arkay system by implementing a turnkey solution that included a wireless network within their warehouse facilities along with truck and handheld mobile devices that performed inventory functions through a mobile website. The mobile website utilized a MySQL database. This database was seamlessly integrated with the Arkay system database, sharing many of the tables in that system. Information that defined each product was brought across from the Arkay system along with other data necessary to track and manage inventory in the same manner already performed in the Arkay system.
Mobilization of the inventory management system allowed Arkay to move to the inventory rather than move the inventory to a desktop or write down information and carry that back to the desktop. This made them significantly more efficient and also improved accuracy as barcoding was introduced to minimize manual key entry of data.
Additional features were also included in the solution to provide better inventory auditing and reporting.
Wake Radiology is a leading provider of outpatient medical imaging in the research triangle. Wake desired to replace their paper forms, which were faxed into a central scheduling center, with an automated web based system.
Journey Software designed a flexible and configurable system to allow the health care providers to access the various medical imaging request forms online. The system allows the health care providers to create a request, review it, approve it and submit it for scheduling. The system maintains a history of every form submitted for scheduling. Wake can reconfigure the forms at any time, adding or removing tests or options. The system maintains a history of every version of the forms. The system insures that the doctors electronically sign the forms or allows them to be printed and signed. It interfaces to their existing scheduling center interface so that no changes were required to the scheduling center.
Virginia Tech, a leading university in engineering and business as well as many other academics, needed to replace its aging system used by the Fixed Assets and Inventory Services department. The system was used for asset tracking, verification and reconciliation and interfaced with their Banner system. It ran on a very old handheld computer which was no longer supported by the manufacturer. Virginia Tech needed a ruggedized handheld computer with bar code reading capability and an interface with Banner.
We provided a mobile application that runs on a ruggedized Motorola handheld computer with a built in barcode scanner and an import/export program that interfaces with Banner. The mobile system has a database that contains all the expected assets for each location defined in the system. This allows the mobile system to be used without network connectivity. The mobile application tracks what is in each location so as the user inventories a location it can be reconciled against what is expected to be there at the time of inventory. We replaced the aging system but also provide a system that is flexible and extendable. The system can be configured to change the screens or process flow as needed for future requirements. The mobile application is also designed with the ability to run on a Windows desktop, laptop or tablet computer.
© 2019 Journey Software