How to Set Up UPC-A Barcodes in Crystal Reports in Sage 100

This blog advises how to set up certain kinds of barcodes in Crystal Reports. Sage 100 workstation setup includes an Azalea font prerequisite install for the use of changing a printed data field into a barcode, within Crystal Reports. Any field, in Sage 100, can then be printed as a barcode using Crystal Reports and the associated Azalea fonts.

You would find this in the …\MAS90\wksetup\Prerequisites\Azalea folder. You would then run the C128Tools_Setup.exe install wizard, which only takes a few minutes.

However, many businesses need to have specialized barcodes to print, especially for retail industries, to comply with various business standards. There are several types of barcodes that reflect certain data, including the UPC-A.

UPC-A Barcodes

The key roles for “UPC” (Universal Product Code) and other barcodes include product identification, inventory management, faster checkout process, E-commerce integration, supply chain efficiency and data-driven decision making.

The UPC-A is one of the most common and well-known barcode types, which is widely applied to retail in the United States. The UPC-A code and the assignment of manufacturer ID numbers is controlled in the USA by the Uniform Code Council (UCC).

The below instructions will concentrate on the UPC-A barcode, specifically, and what to do to get them to print correctly using Sage 100 and Crystal Reports. The below illustration shows how the UPC-A barcode should look and what the various bars and numbers mean.

Setting Up UPC-A Barcodes

Crystal Reports and the Azalea fonts that come with Sage 100 workstation setup do not include this barcode type. I have found that purchasing an inexpensive barcode font software is the best way to achieve the correct and scannable barcode for the UPC-A type. I’ve used IDAutomation’s UPCEANFontAdvantage. This simple software gives you the ability to set up and copy pre-setup formulas to use with Crystal Reports.

To accomplish this and after purchasing IDAutomations software, download and unzip the file.

1. Install the IDAutomation_UPCEANFontAdvantage application.
2. Find the Crystal Reports Formulas.rpt (encoder) in the integration folder and double click to open.
3. In Sage 100, open your custom Crystal Report or form.
4. Copy the UPC-A formula from the IDAutomation Crystal Report Formulas.rpt to your custom Crystal Report. Once copied, then you have the ability to edit the UPC-A formula to include the Sage 100 field you need to print as this type of barcode.
   
   
5. Right click on the formula and choose to edit. Find and change the “DataToEncode” = (Your Sage 100 data field like Item code) and replace the existing data with the field of your choice.
   
   
6. Save the formula and format this field as needed.
7. Save the report and test.

For additional assistance in processing your drop shipments in Sage 100, contact RKL eSolutions.

Want More Sage 100 Tips & Tricks?

Make sure to subscribe to our blog to stay up-to-date on the latest insights and trends. We're dedicated to providing valuable resources for businesses looking to optimize their financial management with Sage 100.

Check out these blogs to help get you started!

How to Reverse a Cash Receipt
How to Reverse an Invoice Posted to the Wrong Month
Understanding the Purchases Clearing Report
How to Setup ACH Processing in Accounts Payable