I would appreciate some help/best practices with Itemlookupcodes. We moved to RMS from ECI Advantage about three months ago and currently have 160,000+ items in our system.
We had a lot of duplicate items in our old POS/ERP system and would like to find a way to stop this problem. Would anyone recommend using UPC codes as Itemlookupcodes? We of course would keep in-house Itemlookups for any item without a barcode.
*This post is locked for comments
We have about 80,000 items and we use UPC all the time. I prefer to use the manufacturer's UPC number because I don't want to print new labels -- we use a price gun to mark each item for the price. The issue I have with using alias' is that when it comes time for inventory counting or doing a movement reports, only the ILC is available, the alias' are not readily available to see under the ILC for counting purposes. I like the fact that a UPC is unique to each vendor. In some cases though I create my own UPC code and then print UPC labels with the price on the label to stick over the manufacturer's UPC code. This would allow you to still have several manufacturers under the same UPC code. In the convention of UPC codes, the number 4 has been reserved for in-store use (so no vendor can ever use a UPC code that starts with a number 4). This means you can create a UPC that has the following convention: 4 aaaaa bbbbb where aaaaa is a unique 5 digit number that I assign to a vendor and then bbbbb is just a sequential 5 digit number starting with 00000, then 00001, then 00002 etc. The final UPC code would be: 40000000000 and let the label software create the check digit code.
I keep an excel spreadsheet on a share folder for my employees to keep track of the aaaaa number assigned to the vendor (my employees can assign this unique number and save it to this file with the vendor name etc). I created an Alpha numbering system as follows: Vendors starting with the letter A would have the vendor aaaaa number assigned 401000 (increment up from here for additional "A" vendors), then vendors with B would have the vendor number assigned 402000 and so on. The file keeps track of what vendor numbers have been used etc.
Hope this makes sense, I have had no problems using unique UPC codes.
Grier
Jeff,
Thanks so much for your reply! I think I need to clarify my situation, rereading my post I can see how it was very misleading.
We moved from ECI Advantage POS/ERP to Dynamics RMS in July of this year. Our Partner did an amazing job of moving our inventory file over. While there were a few duplicate Itemlookupcodes (due to Advantage) we easily weeded them out with SQL Queries.
Where our problem lies is that we are creating multiple inhouse Itemlookupcodes for the same item. Let's say we buy item ABCD from vendor 1234, when that item arrives it will be 1234 ABCD in our system. If the item is purchased from another vendor the 1234 would be replaced with another vendor prefix and the item would have multiple ILCs.
We basically have a problem with Item Creation Standardization and with 160K+ items in our system it is not going to get better. Moving to UPCs as Itemlookupcodes would in essence help to solve our problem.
In you example above we would add the additional UPCs as an alias or use an inhouse ILC.
I really wanted to see if there were any problems using UPC as the Itemlookupcode.
RMS does not allow for duped ILC codes, Did you import from something else? If using HQ, are you only creating items at HQ and not the stores.
I don't know if this example fits your industry, bit we sell into Bicycle shops. They all sell a 20 x 2.125 tube that they can buy from numerous distributors, Each has its own UPC code for essentially the same item
If they used the UPC from each disty, they could have 6-10 UPC codes for the same item. Instead they create an in-store ILC and put the disty's UPC in the Alias section. Now when they buy this tube, they order from who they want and then sell the internal ILC using whosever UPC they have in stock.
Thanks for your replies!
Jeff,
We are currently using internal SKUs and they are causing a lot of problems as items are duplicated. Item look ups also are a drag on the system having to load the Item table.
What would you say are the serious Cons in using UPCs as our Itemlookupcodes. We are trying to measure the Pros and Cons here and we can't fin many cons.
Our idea would be to use the full UPC as the Itemlookupcode, Model/Vendor Stock Number/Item Characteristics as the Description and additional Information as the Extended Description, finally Sub Description1 would be used for the Manufacturer of the item.
I would not use the UPC as ILC.
Use a 6-7 random number easy to remember if needed.
Use the UPC as an Alias number that refers back to your ILC. That way one can use the internal ILC number for similar items. The UPC refers to only that item from that manufacturer.
Chazh345,
Thank you for your post.
I would recomend using the UPC codes as the Itemlookupcodes. This will allow you to set up barcodes and scan the correct item.
Thanks,
Nicole
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156