What Inventory looks for before creating a RFMS Created record in Products

With Version 15.1, a product record will be created  from inventory if one does not already exist at the time of receiving. An important part of this process is what Inventory looks for behind the scenes before creating that product record.  Below is a list (in order) of what inventory looks at in Products before a new record is created.

Step 1

If the Inventory record has a Product Color Sequence Number.

• Check to make sure the Color still exists
• If so, do not add RFMS product – Stop, Do not do Step 2,3

Step 2   

If Inventory has Product Sequence Number but not Color Sequence Number

• Check to make sure the Product still exists
• If so, Check to see if the Product has the same color
• If so, do not add RFMS product – Stop, Do not do Step 3

Step 3

If Inventory does not match on a Product or Color Sequence Number

• Check Products By Product Code, Private Style, and Supplier
• Loop through the results
• If we find the matching Color
• Do not add RFMS product

If all of these things are not matched, then a new product record is created for the inventory record that was entered.

Supplier information is still the same if EC or gateway

E-Commerce Records

Clients were getting new product records because the supplier name on the product record was slightly different than the supplier from the supplier file.   While this could be fixed by doing a general range edit to match the supplier in products to the supplier in the supplier file, some EC vendors are inconsistent with supplier names and this would need to be done each time the product catalog was updated.  Now, if the purchase order is pulled from an EC or Gateway record product even though supplier is different a new product record is not created during the receiving process.