Re: Need help setting up random weight/price items

Discussion in 'Microsoft Point Of Sale' started by Antonio Mazzeo, Apr 14, 2005.

  1. 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
     
    Antonio Mazzeo, Apr 14, 2005
    #1
    1. Advertisements

  2. Antonio Mazzeo

    Derek Guest

    Thanks Antonio. I will give that a try. I will let you know if it works.
    Thanks again.
     
    Derek, Apr 14, 2005
    #2
    1. Advertisements

  3. Antonio Mazzeo

    Derek Guest

    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
     
    Derek, Apr 20, 2005
    #3
  4. 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
     
    Antonio Mazzeo, Apr 20, 2005
    #4
  5. 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
     
    Antonio Mazzeo, Apr 20, 2005
    #5
  6. Antonio Mazzeo

    Derek Guest

    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
     
    Derek, Apr 20, 2005
    #6
  7. 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
     
    Antonio Mazzeo, Apr 20, 2005
    #7
  8. Antonio Mazzeo

    Derek Guest

    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
     
    Derek, Apr 22, 2005
    #8
  9. Antonio Mazzeo

    Derek Guest

    Is there any other advice anyone can give me? Or should I get a support pack?
     
    Derek, Apr 28, 2005
    #9
  10. Glenn Adams [MVP - Retail Mgmt], Apr 28, 2005
    #10
  11. Antonio Mazzeo

    granpicasso Guest

    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.
     
    granpicasso, Apr 30, 2005
    #11
  12. Antonio Mazzeo

    Derek Guest

    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.
     
    Derek, May 1, 2005
    #12
  13. Antonio Mazzeo

    zoostation Guest

    Antonio...where in RMS manager do I enable UPC/EAN? Thanks
     
    zoostation, Jan 22, 2006
    #13
  14. Antonio Mazzeo

    Rob Guest

    Look in SO Manager --> File menu --> Configuration --> Options tab

    Rob
     
    Rob, Jan 22, 2006
    #14
  15. Antonio Mazzeo

    zoostation Guest

    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!
     
    zoostation, Feb 1, 2006
    #15
  16. Antonio Mazzeo

    Jeff Guest

    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!
     
    Jeff, Feb 1, 2006
    #16
  17. Antonio Mazzeo

    Hayk Market Guest

    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.
     
    Hayk Market, Sep 23, 2006
    #17
  18. Antonio Mazzeo

    Rob Guest

    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
     
    Rob, Sep 24, 2006
    #18
  19. Antonio Mazzeo

    James B. Guest

    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
     
    James B., Sep 25, 2006
    #19
  20. Antonio Mazzeo

    Craig Guest

    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
     
    Craig, Sep 25, 2006
    #20
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.