Re: Need help setting up random weight/price items


A

Antonio Mazzeo

Derek said:
I am setting up RMS for a small meat market, and I am having the hardest time
with this. They have an old Hobart scale that prints the barcode labels with
price, weight, etc., but for the life of me I cannot find the proper way to
setup items to use the info from the barcode. I have tried doing some things
with the random weight option on, but no success. I badly need this to work
asap. Any help would be greatly appreciated.
Hi Derek, In Store Operation you can use UPC/EAN random weight barcode.
You can enable the UPC/EAN from SO Manager | Settings..

Now you must change the scale labels with this information..

(EAN13)
20PLUPLpppppC

20 is the prefix for EAN13 weight code
PLUPL is the PLU of your item..
ppppp is the price
C is check digit

and into Item property the itemlookupcode field must be:
20PLUPL000000

bye
Antonio

p.s. for multi ticket I wrote a software that gets ticket from scale
(serial line, or network line) and put the ticket into ItemClass table..
and each night a batch remove the scale ticket from database
 
D

Derek

Thanks Antonio. I will give that a try. I will let you know if it works.
Thanks again.
 
Ad

Advertisements

D

Derek

Antonio, It seems like I am on the right track now, but I could not get your
suggestion to work. It may be something I need to set on the scale as you
said. The label the scale prints out has 12 digits beginning with 20, but
there is a space after 6 digits. I tried putting the 20PLUPL000000 into a new
item's ItemLookupCode field, but when I scan a barcode from the scale, all it
does is pull up the list of items. Then when I choose the 20PLUPL000000, it
asks for a price. Is it supposed to fill in the PLU of the item and its
price, or what should I expect?

Thanks again,

Derek
 
A

Antonio Mazzeo

Derek said:
Antonio, It seems like I am on the right track now, but I could not get your
suggestion to work. It may be something I need to set on the scale as you
said. The label the scale prints out has 12 digits beginning with 20, but
there is a space after 6 digits. I tried putting the 20PLUPL000000 into a new
item's ItemLookupCode field, but when I scan a barcode from the scale, all it
does is pull up the list of items. Then when I choose the 20PLUPL000000, it
asks for a price. Is it supposed to fill in the PLU of the item and its
price, or what should I expect?

Thanks again,
20PLUPL000000
In customer database:
2010001000000 <- AGLIO

20 fixed
1 department ORTOFRUTTA
0001 PLU 1 in scale

000000 must be zero

Item Type : Standard
Price: Euro 2,52/Kg

Example of ean into label:
20100101234? {? - check digit }


When the scanner read label.. into pos I have
ITEMLOOKUPCODE 2010001000000
DESCRIPTION AGLIO SECCO
QUANTITY 4,8968
PRICE 2,52
EXTENDED PRICE 12,34 {max price 999,99}

bye
antonio
 
A

Antonio Mazzeo

Derek.. Store Operation have a bug (I think from QSC 1.07c) with price
items..

When the item have a saleprice active.. The POS get the price from
label.. but It proceduce a different extended price because use always
Price to obtain the quantity..

Price Of Label / Item.Price = Quantity * SalePrice = Extended Price.

I report this bug some times, but in release 1.20 the bug is present.

Antonio
 
D

Derek

Thanks. I'll make sure weighed items aren't put on sale in SO. They usually
discount at the scale anyhow.

I might have found my problem. I'm thinking our scale prints UPC-A random
weight barcodes. That would explain the label only having 12 digits. Does
this sound right to you? If so, I should be able to leave off one "0" at the
end and it work.

Derek
 
A

Antonio Mazzeo

Derek said:
I might have found my problem. I'm thinking our scale prints UPC-A random
weight barcodes. That would explain the label only having 12 digits. Does
this sound right to you? If so, I should be able to leave off one "0" at the
end and it work.
I update PLU of scales through utility that get data from RMS db and
send to network scales...

If your scale work only with UPC, first remove a 0 digit from
itemlookupcode field.. and check that 20 is the prefix also in UPC
standard (we work with EAN13/8 and non standard code.. but always 8/13
chars)

bye
antonio
 
D

Derek

Well, it may be back to the drawing board.. I tried again using the UPC
method, but it will not even let me manually add the item at the POS screen.
When I add it, I am instantly returned to the POS screen, but the item is not
listed. This only happens when a #2 is the first digit of the itemlookupcode.
Furthermore, when I scan the barcode, it cannot find the item in the
database. This also occurs if I manually edit the item and type in the
complete barcode.

Also, today I noticed that another weighed item at the store began with 22.
I am officially stumped.

Here is a sample of the info printed on one of their barcodes:

201324 109954
0.60 LBS $16.59 $9.95
 
D

Derek

Is there any other advice anyone can give me? Or should I get a support pack?
 
G

granpicasso

I have a label with the following barcode: 2 00001 10309 4, the item lookup
code in the database I have it as 20000100000, the price of the item is
$3.09, the barcode type I used is EAN-8. The system is setup to use
RandomWeightUPC in the configuration. Nothing I did would work until I came
across this posting and I tried filling up with zeroes. I tried the label in
the POS and it worked. It picked up the price as I was expecting. Hope this
helps. Herman.
 
D

Derek

Thanks all, you have been tremendously helpful and have solved my problem. To
The RMS team at Microsoft, please provide better documentation on
configuration of the features within this software. Even the partner
implementation guide does not contain this information.
 
Z

zoostation

My scale is printing out barcodein the following format:

0 203306 304494 (0 2xxxxx 3yyyy4) x=plu y=price not sure what 0, 2, 3, 4
are

Does anyone know what format this is?

When I scan through hyper term to read it, it takes out the lead zero and
shows the remaining numbers. Can anyone tell me how to get RMS to recocnize
this format? Please!
 
J

Jeff

Zoo,

Does this do the same when scanning the item in Notepad? If so, sounds like
you need to re-program the scanner _not_ to drop the leading 0.

Look through the scanner's manual for the info or post the make and model of
the scanner and maybe someone here can help.


--
*
My scale is printing out barcodein the following format:

0 203306 304494 (0 2xxxxx 3yyyy4) x=plu y=price not sure what 0, 2, 3, 4
are

Does anyone know what format this is?

When I scan through hyper term to read it, it takes out the lead zero and
shows the remaining numbers. Can anyone tell me how to get RMS to recocnize
this format? Please!
 
H

Hayk Market

How can we get to this article. Microsoft seems like wants blood type and
urine sample to get it. Can anyone that has the ability to get to the
article post it for the rest of us.
 
R

Rob

The article is available to those individuals that have purchased the
Maintenance Agreement. It would not be fair to those that have purchased
Maintenance to post the full contents of this article.

Rob
 
J

James B.

TechKnowledge Content
Issue

How to use Random Weight (Price Embedded) EAN/UPC Barcodes in Store
Operations

Resolution

1. Price-Embedded (commonly called Random Weight) Barcodes are enabled from
the Manager in the configuration section. There are two options, 'Use Random
Weight UPC' and 'Utilize Random Weight EAN'. You need to decide which format
will be used and select one.

2. Create an Item (standard type) and place the Per Unit Cost (per kilo,
gram, pound. ounces) and the Per Unit Price in the Cost and Price fields
respectively.

3. When an Item is scanned or entered and its Item Lookup Code meets the
specified format, Store Operations will automatically compute the Weight
based on the Price embedded in the Label and the Item Price (Per Unit Price)
in the database.

The definitions of the two formats are:

Random Weight UPCs allow for 12 digits, 4 of which consist of the Price
(Items up to $99.99).

Format: 2xxxxxayyyyc

where
2 = Random Weight UPC Code Indicator
x = Item Lookup Code Prefix. The Item Lookup Code is this prefix, followed
by 00000 (actual Lookup Code = 2xxxxx00000)
a = Secondary Check Digit
y = Price of Item / 100
c = Check Digit (ignored, may or may not exist)

The entire code has 11 characters.

Example:

1. Set up an Item with an Item Lookup Code of 25772600000. Generally, the
UPC Barcode Format is used for these Items.

2. Print a Label with the Code 25772601256 (according to the format, this
should be a $12.56 Item).

3. When Item Lookup Code 25772601256 is scanned at the POS, the Item
25772600000 will appear and a Price of $12.56 will be automatically entered
on the screen.

Random Weight UPCs allow for 13 digits, 5 of which consist of the price
(Items up to $999.99).

Format: 20xxxxxyyyyyc or 02xxxxxyyyyyc

where

20 or 02 = Random Weight UPC Code Indicator
x = Item Lookup Code Prefix. The Item Lookup Code includes this prefix,
followed by 00000 (actual Lookup Code = 2xxxxx00000 or 02xxxxx00000)
y = Price of Item / 100
c = Check Digit (ignored, may or may not exist)

The entire code has 13 characters.

Example:

1. Set up an Item with an Item Lookup Code of 2057720000000. Generally, the
EAN 13 Barcode Format is used for these Items.

2. Print a Label with the Code 2057720112568 (according to the format, this
should be a $112.56 Item).

3. When Item Lookup Code 2057720112568 is scanned at the POS, the Item
205772000000 will appear and a Price of $112.56 will be automatically entered
on the screen.


This article was TechKnowledge Document ID: 26571

--------------------------------------------------------------------------------

APPLIES TO
• Microsoft Retail Management System Store Operations 1.3
• Microsoft Retail Management System Store Operations 1.2
• Microsoft Retail Management System Store Operations 1.1
• Microsoft Retail Management System Store Operations 1.0

Back to the top

Keywords: kbmbsmigrate kbmbspartner KB869705
 
Ad

Advertisements

C

Craig

I agree with Rob, I payed a couple of hundred dollars to have access to
these articles. Why should somebody not paying for it have access. It's one
thing if you have the knowledge and share it, but copying it word for word
is copyright infringement and unfair to those of us that pay.
Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top