4 Replies Latest reply on Jul 1, 2015 8:46 PM by starstuff

    How to Replace Field Content in Portal per Line?

    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!