Upgrading from 12 digit PLU system

Posted by dh on November 24, 2005, 4:40 pm

Please log in for more thread options

I dumped a PLU flat file from an old S4 Software database that only supported
12 digit barcodes. When I imported them into RMS, they don't work (b/c of
the check digit).

Example: Vegeterian Cracker UPC is 8-934878-08128-6
In the S4 databse, is was 8-934878-08128, and that is the ItemLookupCode in
RMS.
When I scan the item, it doesn't work.

Is there a way to automate the appendage of the check digit? I have 26,539
items in the database, and about 16,000 items have this problem.

David Hoang

Posted by Darren Martin on November 24, 2005, 9:38 pm

Please log in for more thread options

For EAN/UCC use Modulo-10 algorithm to compute for the check digit.

Here's an example on how to compute UPC Code : 893487808128
Step 1 : Add the numbers in Position two, Four, Six, Eight, Ten, Twelve
(9+4+7+0+1+8) = 29
Step 2 : Mulitply the result of step 1 by three (29 x 3) = 87
Step 3 : Add the numbers in Position one, three, five, seven,nine, eleven
(8+3+8+8+8+2) = 37
Step 4: Add the result of step two and step three (87+37)= 124
Step 5. The check digit is the smallest number needed to round up the result
in step 4 to a mulitiple of ten.

In our example the smallest number to be added to 124 so that it can be in
multiple of ten is 6. The check digit is 6.Therefor the complute PLU now be
8-934878-08128-6.

You can create a small application to automate these using your database.
Goodluck. I hope I have asisted you on these matters.

Regrads

Darren Martin E. Dimaguila
Microsoft RMS-Program Manager
Global Implementation Services, Inc.
darren.dimaguila@gisimplement.com
+632(811-2000) extn 2310

> I dumped a PLU flat file from an old S4 Software database that only

supported

> 12 digit barcodes. When I imported them into RMS, they don't work (b/c of

> the check digit).

> Example: Vegeterian Cracker UPC is 8-934878-08128-6

> In the S4 databse, is was 8-934878-08128, and that is the ItemLookupCode

> RMS.

> When I scan the item, it doesn't work.

> Is there a way to automate the appendage of the check digit? I have

26,539

> items in the database, and about 16,000 items have this problem.

> David Hoang

Posted by Derek on December 4, 2005, 9:08 pm

Please log in for more thread options

Go here:

http://jeanholland.com

They have what u are looking for!

"dh" wrote:

> I dumped a PLU flat file from an old S4 Software database that only supported

> 12 digit barcodes. When I imported them into RMS, they don't work (b/c of

> the check digit).

> Example: Vegeterian Cracker UPC is 8-934878-08128-6

> In the S4 databse, is was 8-934878-08128, and that is the ItemLookupCode in

> RMS.

> When I scan the item, it doesn't work.

> Is there a way to automate the appendage of the check digit? I have 26,539

> items in the database, and about 16,000 items have this problem.

> David Hoang