Dynamics GP - Script to set all item engineering items to "Made" once a BOM exists for the item - "This is not a made item"

--Sets Items to "Make or Buy" and fulfil method "Make to Stock"
----------------------------------------------------------
update IVR10015 set EFFECTIVEDATE_I = '2017-01-01', ITEMSTATUS_I = 1, MAKEBUYCODE_I = 2, ITEMFULFILLMETHOD = 1 WHERE ITEMNMBR IN (SELECT ITEMNMBR FROM BM010415)