Hi,

Can you help me for Purchase_Part_Supplier Data Migration. We don’t want to write for all rows in excel for column “LINE_NO”. We can arrange it with a select statement but I couldn’t do it. This doesnt work.

(select

MAX(line_no)+1 FROM PURCHASE_QUANTITY_PRICE pps
WHERE CONTRACT = pps.contract
AND VENDOR_NO = pps.vendor_no
and PART_NO = pps.part_no)

Thank you.

I attached a similar problem from community as well.

Excel migration issue with update of purchase_quantity_price | IFS Community