Hi, this is a report modification. I need to get below bank details of DetailValue column to my ARInvoice. These information are taken from CashaccountPaymentMethodDetail DAC.

For a particular CashAccountID, Detail Value is changed based on DetailID from 4545 to 4549 as above.

ex: if DetailID=4545, Bank Name

      if DetailId=4546,  Account number….

And also it depends on the PaymentMethodID as well. If I made an expression to retrieve DetailValue Based on DetailID,  It only retrieves the first value which is the Bank Name. I need to get the DetailValue per each DetailID from 4545 to 4549. Can someone help me with a solution to do this?

Thank you.