Is this possible in a saved search? I'm really having a hard time with this one. Filters: (I'm okay with this) Eliminate is TRUE (custom field) Posting is TRUE Type is Journal Results: Transacting Subsidiary A Account Amount Transacting Subsidiary B Account Amount Variance Basically, convert the AICJE lines to columns.

It’s possible but how many sub do you have ?

40+

Show me in excel file what you want to see on your saved search please

seems like you are trying to create a saved search for advance intercompany JE's. Try a transaction search, in the criteria look for "Record Type" and contains "advintercompanyjournalentry" - should work - I think 🤔