1. Home
  2. Point-Of-Sale Software
  3. Moving ILC for Standard Items into Reorder Number field

Moving ILC for Standard Items into Reorder Number field

I'm using the following commands to fill the Reorder Number field on Matrix Components with the ILC from the Matrix Parent and it works well...

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

This leaves the Reorder Number field blank for all of my Standard items. What coding would I need to fill the Reorder Number field with the ILC for my Standard items?

Thanks in advance!

Reply to
Kris
Loading thread data ...

Run this query, this will change all items to have the ReorderNumber equal to the ItemLookupCode, then run your other query, that will change all Matrix Items ReorderNumber back to Matrix ILC.

UPDATE SupplierList SET SupplierList.ReorderNumber = Item.ItemLookupCode From SupplierList INNER JOIN Item ON SupplierList.ItemID = Item.ID

Rob

"Kris" wrote:

Reply to
Rob

Rob, It worked perfectly. Thank you very much!

Reply to
Kris

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.