How to Replace Field Content in Portal per Line?
im trying to update unit prices based on the supplier of the invoice
if for example the current invoice changes the supplier, the unit price will change based on the current supplier.
the price is an auto-calc field
PRODUCTS ---------< LINE ITEM >------INVOICE >---------SUPPLIER
im able to separate the current invoice LINE ITEMS using
Go To Relaed Record [ Show only related records;
From table: "LINE_ITEMS";
Using Layout: "LINE_ITES_Table" (Line Items)]
Replace Field Contents [LINE_ITEMS::prices]
Go to Layout ["INVOICES_Detail" (INVOICES)]
the problem with the Replace Field Content is it replaces all the prices inside the portal to a single price, instead, i need to replace a line item based on the supplier's price.
How to do it?