I dumped a PLU flat file from an old S4 Software database that only supported
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
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. snipped-for-privacy@gisimplement.com
+632(811-2000) extn 2310Go here:
They have what u are look> I dumped a PLU flat file from an old S4 Software database that only supported
Have something to add? Share your thoughts — no account required.
Ask the community — no account required