We often get the calls looking to add bar codes to Dynamics GP. Sounds like a reasonable request, but what does that really mean? Here are a few tidbits of information to take some of the mystery out of bar code technology.
Many relate a bar code to UPC manufacturer number. Because of this, many think they need some special number that is the “bar code” number for their items. Instead, think of a bar code as a font or a different language. A bar code scanner is the interpreter. When a bar code is scanned, it simply translates the bar code into text. You can bar code anything, a location name, your GP item number, a serial number, your name. There isn't a reason to create a “special” bar code number. Just use the GP item number. Of course you may have alternate item number cross references, which would then be handled by the database.
There are a couple of different ways to create a bar code. There are bar code fonts that you can purchase to use on reports. This will allow you to bar code PO Numbers, Sales Order Numbers, anything you want to be able to scan instead of type. You can also purchase bar code design and printing software packages. These range in price starting at under $300. Depending on the software, you can print bar code labels directly from excel or a database. These software packages allow you to design labels. You can add text, images, and bar codes. When designing an item label for our customers, we typically suggest they bar code the item number (which would be scanned), add the item description as text only, and bar code lot or serial numbers (which would also be scanned). Typically human readable text is part of the bar code when creating it from a software package. Many think they need more information on the label such as quantity or location. Keep in mind that most likely when you are scanning a bar code there is communication to a host database. The additional information can be retrieved from that host database and doesn't need to be included on the label itself. Plus information that may change shouldn't be included on the label (location, quantity, owner, etc.)
Let’s talk a little about the scanners. There are different types of scanning devices. The most simple is a tethered scanner you would attach to a laptop or desktop. When entering data into an application on a computer, the scanner can be used instead of manual key entry of the data from the keyboard. You need to be in the application and the appropriate field on the computer. Most of these scanners can also be programmed to append an enter or tab to automatically advance to the next field. Starting cost for these types of scanners is about $200. The biggest drawback is that scanning needs to take place at the computer, not necessarily at the point the transaction happens (such as warehouse floor or customer site).
Mobile computer devices with integrated bar code scanners will provide you the ability to carry the computer and scan items, locations, assets, etc. where they are located. With a Windows Mobile operating system, these devices have pocket word and excel. Using a scanning program, bar code data can be scanned into these standard applications. However, most likely you are looking for integration to a host database to complete transactions, not to simply record scans. This will require specialized software application that will prompt for information that needs to be captured and that has the ability to communicate back to the host database for validation and for creating or updating transactions. Our
Panatrack specializes in automated data capture (i.e. bar codes) and can be a resource for you as you explore opportunities to use the technology. Watch for my follow up blog on 1D and 2D bar codes coming soon!