This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, what's the easiest way to get amounts in USD (irrespective of the transaction currency) in a Saved Search? For context - Neither the transaction currency nor the base currency of the subsidiary is USD. I tried using the CURRENCY_CONVERT function but it's not giving valid results (pretty sure I might be doing it wrong).
Any insights would be highly appreciated. Thanks!

I will use a custom field on transaction which would retrieve the conversion rate between the source currency and the dollar. So it would be enough to make a formula to calculate the amount in dollars

Yep, I thought so too. Was wondering if there was a formula handy.