AR: Replicate Products Update Query
This is an older method of replicating products.
Assumptions...
- Two Digit Plant Numbers with 1 character delimiter
- Copy all products from one plant to another
- G/L will be updated independently
NOTE: Make sure to review current field list for any essential fields that could be missing!
INSERT INTO artprod ( PRODUCT_CODE, BASE_PRODUCT , PLANT_NO , UNIT_OF_MEASURE , DESCRIPTION_1 , DESCRIPTION_2 , LOCATION , SALES_GL , STOCKED , TAX_CODE , LINK_PRICE_PRODUCT , COSTOFSALES_GL , APCLEAR_GL , INVENTORY_GL , PRODUCT_CLASS , LAST_MONTH_QTY_SOLD , MTD_QTY_SOLD , YTD_QTY_SOLD , MTD_SALES , YTD_SALES , YTD_GROSS_PROFIT , WORK_FIELD , PRODUCT_TYPE , EXPORT_FLAG , ROLLUP_FLAG , SELLABLE_FLAG , VENDOR_NO , VENDOR_PART_NO , LIST_PRICE , STANDARD_COST , MINIMUM_QTY , QTY_ON_ORDER , LAST_RECEIVED_DATE , WEIGHT_UNIT , CUBE_UNIT , QUANTITY_UNIT , STD_PCT_DISC , AUTO_QTY , DEFAULT_QTY , ALT_UMS , ALT_UMS_RATIO , PURCHASE_UMS , PURCHASE_UMS_RATIO , QTY_PRICE_METHOD , NOTES_1 , NOTES_2 , NOTES_3 , NOTES_4 , IMPORTED_FLAG , LAST_CHANGE_DATETIME , LAST_CHANGE_USER , ACTIVE_FLAG ) SELECT substr(product_code,1,strlen(product_code)-2)||'20', substr(product_code,1,strlen(product_code)-3), '20', UNIT_OF_MEASURE , DESCRIPTION_1 , DESCRIPTION_2 , LOCATION , SALES_GL , STOCKED , TAX_CODE , LINK_PRICE_PRODUCT , COSTOFSALES_GL , APCLEAR_GL , INVENTORY_GL , PRODUCT_CLASS , LAST_MONTH_QTY_SOLD , MTD_QTY_SOLD , YTD_QTY_SOLD , MTD_SALES , YTD_SALES , YTD_GROSS_PROFIT , WORK_FIELD , PRODUCT_TYPE , EXPORT_FLAG , ROLLUP_FLAG , SELLABLE_FLAG , VENDOR_NO , VENDOR_PART_NO , LIST_PRICE , STANDARD_COST , MINIMUM_QTY , QTY_ON_ORDER , LAST_RECEIVED_DATE , WEIGHT_UNIT , CUBE_UNIT , QUANTITY_UNIT , STD_PCT_DISC , AUTO_QTY , DEFAULT_QTY , ALT_UMS , ALT_UMS_RATIO , PURCHASE_UMS , PURCHASE_UMS_RATIO , QTY_PRICE_METHOD , NOTES_1 , NOTES_2 , NOTES_3 , NOTES_4 , IMPORTED_FLAG , LAST_CHANGE_DATETIME , 'HIT' , ACTIVE_FLAG WHERE (artprod.plant_no = '12');