I'm trying to create a transaction body field that shows the paying/paid transaction (both advanced intercompany JE). They are linked as applying and applied transaction based on the saved search. I'd like to use a formula in the field but can't pull it out using {applyingtransaction} and {appliedtotransaction}. Field not found is the error. I'm trying to avoid creating a saved search to populate the field. Thanks!

applyingtransaction and appliedtotransaction are search related columns, dont expect them to work outside of a search

I ended up using a summary saved search for the field. The paying transaction properly shows the paid transaction but not vice versa. Any thoughts? Thanks! CASE WHEN {paidtransaction} IS NOT NULL THEN {paidtransaction} ELSE {payingtransaction} END

you can probably use NVL for your formula

This is the only column in the Results tab because I'm just using this to populate the custom transaction body field on AICJE. The Available Filter is Internal ID. The Criteria are Type is Journal and Advanced Intercompany is True.

evidently paidtransaction and paying transaction are weird

CASE WHEN {paidtransaction} != '' THEN {paidtransaction} ELSE {payingtransaction} END Still not working. It's puzzling. Also used a space

what did your space formula look like

CASE WHEN {paidtransaction} != ' ' THEN {paidtransaction} ELSE {payingtransaction} END

message has been deleted

Yeah, it's working on the saved search itself but it is not reflected on the transaction body field except the first internal id in the formula.

what does the field look like

Type is Free Form Text. All boxed are F. Applies to Journal. Subtab is Main. Display Type is Inline Text. Search (Validation and Defaulting) is the saved search above. The field is populated only with the first internal ID in the formula. Otherwise, it's blank on the other AICJE. This is for AICJE btw.

What does your saved search output look like for your 2 transactions

It only shows one JE. The first internal id (paying or paid transaction). Maybe because of Maximum.

What did you want it to do, your formula is written to output the largest paid transaction or paying transaction

Yeah makes sense. It's because I am required to select a Summary Type to use it on a transaction body field. Without the summary type, I get the results I want which is to show the paying/paid transaction related to an AICJE.

you can use LISTAGG or the less supported NS_CONCAT to combine multiple rows into one