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.