Changing suppliers should be changing a match field such that your line items match to different records in your table of prices.
Either use the calculation option and refer to the correct field from that related table.
i can already match prices based on the supplier using a global field,
the problem is the when changing the price on the LINE ITEMS, all the product get the same price as the first product. Using the Replace Field Contents, it replaces all the price even though the product is different.
Do i need to use looping to process each LINE ITEMs to get the correct prices?
To repeat, Replace field contents, with the calculation option, should update each line item to a different price from your table of pricing information. The change in supplier should link the line item records to a different record with a different price for that product.
Thanks PhilModJunk, that makes it clearer, will re-check relationship and tables.