Hi, we have a suitelet that pulls transaction lines (Consolidation Exchange Rate: NONE). However we would like to be able to pull in that consolidation exchange rate as a field on the suitelet. We are able to back into the rate if we run a save search with the Exchange rate set to Per-Account, but I am not sure how to go about pulling that into the suitelet. I was thinking of running another search with the type of PerAccount (but that would probably be too much data since the searches are now 2x) or if a nested search against the consolidated rate table is possible

what would your 2 searches look like