At 08:20 PM 2/16/2005, John Engwer wrote:
I have an application where I need to create UPC codes (11 digits + check).
Question:
Is there a way to have R:Base create the check character when you enter the
first 11 digits so that I can store the full 12 digit code?
Since R:Base will create the check character when you print a UPC barcode,
I suspect that there is a way to do this.
John,
Of course there is a way to do this!
First, let me explain all details about the UPC-A.
All-in-one next generation R:BASE 7.x and V-8 "Turbo" includes built-in
industry standard barcodes in Report Designer, with UPC (Universal
Product Code) bar code of choice for the retail industry.
UPC option in R:BASE 7.x and V-8 "Turbo" is designed to uniquely identify
a product and its manufacturer. The actual UPC code is a 10-digit code:
the first five digits represent the manufacturer, the next five as a
unique product identifier code assigned by the manufacturer. This 10-digit
code is preceded with a "number system" digit and followed by a check digit.
Thus the UPC-A bar code encodes 12 digits of data.
When you apply for a UPC manufacturer number, the UCC (Uniform Code Council)
assigns you a six digit number; the first digit is a "Number System" digit
from 0 to 9. The meanings of each of these digits is listed below. The next
five digits is your actual manufacturer number.
The Number System assignments are as follows:
0 - 92,000 manufacturer identification numbers; 8,000 locally assigned numbers
1 - Reserved
2 - Random weight consumer packages
3 - Drug products
4 - In-store marking without format
5 - UPC coupons
6 - 100,000 manufacturer identification numbers
7 - 100,000 manufacturer identification numbers
8 - Reserved
9 - Reserved
And, here's how it do it:
01. While in Report Designer, place a DB Barcode control on [^D] Detail Band.
02. Right-click on DB Barcode control and select "Configure..."
03. Select the following options:
Type: UPC-A
Orientation: Left to Right
Bar Width: Leave the default as 0.013
Wide Bar Ratio: Leave the default as 3
Add On Code: your add on code
Calculate Check Digit: Checked (true)
Click on [Apply] button
That's all there is to it!
Let me know if you need more details or a few samples.
Very Best R:egards,
Razzak.
