I got a request to see a report of exchange rates between JPY and USD for the past 90 days. Am I confused, or is the only tool to show this the Currency Exchange Rates page? That page seems pretty minimal. I would have to enter the As Of date 90 times and export each time, if I'm not mistaken. Would love to hear others' thoughts on the matter.

Would the Realized Exchange Rate Gains and Losses report help?

Honestly, I'm not sure. I'm a developer, not an accountant. I'm assuming this is a follow up request from auditors because they're not satisfied with NetSuite's consolidated sub reporting. I know they were not happy about starting balance not matching ending balance on the trial balance, and we determined that what they were asking for was an enhancement.

It's goofy structure, but if you go to Currency Exchange Rate > New > Search in the top right you do have the ability to create a Currency Exchange Rate search and export the rate by day

I know, that's so wild. @kennkerp just informed me