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
