Points to remember
We can update the Daily currency exchange rate using Netsuite Currency Exchange rate Integration (Direct) and also update using CSV and Manual update is also possible.
The currency exchange rate will pull all the exchange rates we have updated in the system for the effective date.
But only the latest exchange rate will pull out the correct value.
We can only make new entries to update the exchange rate. Overriding (updating)the already existing once is not possible.
Better use the Currency Exchange Rates page for checking the latest exchange rate information.