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

I was hoping nlapiExchangeRate(sourceCurrency, targetCurrency, effectiveDate) would handle that for me.

It turns out you can only convert to your accounts base currency which is f-ing useless in my scenario

you may want to try experimenting with <https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_n1409190.html|Consolidated Exchange Rate Types for Transaction Searches> using a <https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_1536244919.html|search.Setting>