Handheld Database Application Provides Options for Mobile Sales Forces
By Frank Yacano, Director of Business Development, SYWARE, Inc. (www.syware.com)
The ability to quickly integrate sales orders with central distribution and accounting systems is a fundamental ingredient of a successful business, allowing orders to be filled promptly and invoices to be issued in a timely fashion. Achieving this goal holds special challenges for companies with a mobile sales force that frequently do not share the same information infrastructure as the rest of the organization. When there are isolated "islands of information", the result can range from shipping delays to lost orders and cancelled sales.
Many sales personnel are still using paper forms, which then have to be re-keyed back at the office - a duplication of effort that also results in lost time and high risk of errors. Laptop PCs are an option, but they are expensive. They can also be awkward to use, especially when a salesman is on his feet.
Integrating with Corporate Databases
For companies that are still using paper forms, a transition to handheld PCs and electronic forms is easier than they might think. Contrary to popular belief, application development does not have to a huge expense requiring teams of programmers laboring for months. Intuitive "drag & drop" tools have simplified application development, allowing even small companies to have their own customized solution. This also creates new opportunities for development companies and integrators that serve this marketplace.
One company working within this space is Bravo Software (www.bravosw.com). In business since 1985, the Kilbride, Ontario, firm creates customized software solutions that help clients extend the functionality of their current business systems. One of its flagship products is RemoteDesk, a software package that manages the collection of sales information and then delivers the data to a central accounting system such as AccPack or Great Plains. A desktop PC serves as a "traffic cop" to poll inbound orders from different sources, such as from a shopping cart, remote and local desktop systems, and laptop users. It also issues periodic updates of customer and product information from a central database.
The company recently extended its RemoteDesk application to run on Windows CE handheld devices, allowing mobile salespeople to use a handheld PC to collect sales orders and customer information. At the end of the day, the sales information is automatically synchronized with the desktop system running in the central office. This can be done by dropping the handheld into its docking unit or by sending an email message with the sales data as an attachment. The RemoteDesk software then processes the sales orders together with data collected from other sources, and posts the updated tables to the central order processing system.
Sample Application: a Beverage Distributor
Today, sales order information is collected using Compaq iPAQ handhelds. In a typical scenario, a salesman walks into ABC Liquors and clicks to the customer record. The first screen contains information identifying the account and provides a window into customer status information such as total credit, current balance, and credit status. He then clicks to a "Ship To" screen to specify the shipping location and special instructions associated with the order, such as rush shipments.
He then clicks on the "Details" button, where he can specify that the customer wants three cases of vodka, ten cases of whiskey, and one case of gin, as well as the brand and the volume. Information such as brand names and quantities is already loaded into the handheld database. The salesman can select specific brands and quantities, or type in a partial name, and the software will search through the database to pull up the matching entries. The software also automatically calculates any applicable discounts based on the specified pricing structure.
After entering all details into the handheld, the salesman saves the order and goes down the street to the next customer, and repeats the process. The salesman can also print a copy of the order for the customer using a portable printer, with the connection provided through the handheld's IR port.
Synchronizing at the End of the Day
The third salesperson is based further away. Rather than make a special trip to the head office, he emails the data from his handheld device. Once orders are captured for the day, a program on the handheld creates an email message with the order information provided as an attachment. The salesman uses the handheld device to transmit the information wirelessly, using either a built-in modem or an adapter card installed in the device. He can also plug the handheld into a cell phone, which acts as the modem, and then dial through the cell phone to send the email.
The new system provides clients with much faster, more accurate access to sales information without the need to rely on someone at the head office re-keying - which could take several days, especially if the person is out sick. Response to customers is greatly improved; orders submitted electronically can be shipped the next day.
The "Meat and Potatoes" of Order Processing
"We were looking for a Windows CE tool that would allow us to build an application quickly," explains Dave Repchuk, VP of Product Development at Bravo Software. "I definitely didn't want to get involved in C++ programming. For certain types of applications C++ is a great tool, but for writing business forms it's very laborious and tedious. We prefer to spend our time addressing productivity issues rather than dealing with the fine points of a C++ application. Visual CE allows us to get right to the meat and potatoes of what we do, which is order processing."
Repchuck is also eyeing a new SYWARE product called mEnable that allows databases to be updated in real time, rather than periodic synchronizing or email updates. mEnable uses standard wireless connections to write to or read from any ODBC-enabled data source.
Bar Code Data in Handheld Forms
Vendors may have samples of hundreds of different items mounted on a wall in their trade show area, each with a bar code underneath. Perhaps 15-20 sales reps will be guiding customers around the booth, each equipped with Symbol Technologies scanning device. A centrally-located printer as well as a desktop system for data collection are shared by all users.
In a typical scenario, buyers place orders as they walk around the booth with a sales rep, who scans the item bar code to display the item number and description in a form on the screen. The rep then simply clicks the quantity ordered. They can also print the order to provide a record for the customer. At the end of the day, sales reps load their orders into the desktop database. The data is then shipped back to the head office and automatically integrated with central accounting and distribution systems.
In the past, orders would be hand-written (and there could be thousands at a busy show). This would result in a massive faxing exercise to get the orders back to headquarters where someone would have to interpret and re-type all the order data. Customers frequently had to wait for weeks before they received the items ordered. Now orders can go out the next day.
Easy Route to Integrated Solutions
Have a SMB Question?
Call a SYWARE implementation expert at 617-497-1300 or
click here to email us.