Populating Reorder Number with ILC for Matrix Parent

Or would there be a way to add a column to the purchase order that shows the parent Matrix ILC? Would I need to have Microsoft customize a purchase order for me?

There is no way of adding the Matrix ILC to the PO, but you can do an SQL statement that would take the ItemClass.ItemlookupCode (Matrix ILC) and update the SupplierList.ReorderNumber.

UPDATE SupplierList SET SupplierList.ReorderNumber = ItemClass.ItemLookupCode FROM SupplierList INNER JOIN ItemClassComponent ON SupplierList.ItemID ItemClassComponent.ItemID LEFT JOIN ItemClass ON ItemClassComponent.ItemClassID = ItemClass.ID

Rob

"Kris" wrote:

Rob,

Are you having any trouble running this code?

I created earlier this week, what I thought was the same exact code for Kris as you did and when I ran it, it came back with 0 records affected. I decided to come back to it later.

Tonight when I ran your code, it did it again, 0 records. By accident, I F5'ed it again and it ran perfectly. Weird!

Maybe I'm not getting something here but why would you want a purchase order to list the same part number over and over again for different items?

"I would like to populate the Reorder Number field with the ILC for the Matrix Parent. The ILC for the Matrix Parent is the vendor part number for all of our items."

Are you saying they are all the same number? Doesn't RMS prevent you from doing this? How does your supplier tell them apart? By the descriptions?

There should only be one unique matrix code that includes all the items in that matrix. Each of the individual items has a separate supplier part number. If you enter the main matrix code in a PO it pops up a grid for you to enter quantities for each item in the matrix. Then your purchase order will list whatever items you selected along with their part numbers and yours. Won't that work for you?

Mark S

"Kris" wrote:

Mark,

In fashion retail even though a style is made up of many different items when it comes to ordering from a supplier they use the same part number.

Although you are right if you use the Style code as your Matrix code even though there are extra characters appended to the end the Supplier should be able to dicipher what part number you are ordering, then again "should" is not the same as will.

Rob

I first ran it on a couple of styles then on my entire sample db and it worked all three times. So I don't know what to tell ya. Maybe a GREMLIN. Did you feed your computer after midnight or get it wet?

Rob

I did the same. ;-(

No, but I'm about to whack it good... I've had some weirdness and need to re-install XP. I hate when that happens! ;-)

Mark S, My footwear and apparel items have a "part number" that refers to the parent item (i.e. Nike Pegasus), the individual components of the matrix are the sizes (7, 7.5, 8, 8.5, etc.). All of those sizes have the same part number, the size is what differentiates. When a customer service person enters an order, they type in one item number and then the size grid pops up for them to enter the quantities. The only unique number each of the sizes has is it's UPC, but that number isn't used as a "reorder number", in fact for most of my vendors, the UPC doesn't show up anywhere in their data entry screens.

Rob, It worked perfectly! Thanks!