AnsweredAssumed Answered

How to Replace Field Content in Portal per Line?

Question asked by starstuff on Jun 29, 2015
Latest reply on Jul 1, 2015 by starstuff

Title

How to Replace Field Content in Portal per Line?

Post

Hi All!

 

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

 

Relationship:

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?

 

Thank you!

Outcomes