In saved search results I see that you can display a column for "applied to transaction" to for example see that a credit memo is applied to a particular return authorization or invoice.
However, how to you take one more jump to find out the invoice that the return authorization is applied to and then display that with the credit memo?
The situation is that we export a saved search of all invoices and credit memos as csv to a customer at the end of the month. If we use "applied to transaction" in the results they see where credit memos have been applied directly to invoices, but if they've been applied to return authorizations, they can't see which invoice that return is applied to on the credit memo.
How do we make two jumps through the applied return and then to the applied invoice on the return and bring that back to display on the credit memo record?
Do we need a custom field of some type, or is there a way to do it with a formula field in the saved search? I suppose the issue with that is it will create two columns won't it? One for the applied transaction (return) and a second for the invoice the return is applied to?
Cheers.