6 Replies Latest reply on Dec 22, 2016 6:46 AM by gabriela..zorrilla

    Use currency rate from one DS into a second. Example attached.

    gabriela..zorrilla

      Hi there. I have one DS A with currency rates and a second DS B with the invoices. I want to convert all the invoice amount o a single currency, multiplying Amount in DS B by the rates on DS A.

       

      As i have to use a LOD on the invoice number to get it right, i'm blocked because LODs do not support secondary datasources.

       

      Is there a workaround for this?

       

      I've attached an example.

       

      Thanks!!