i need to view the historical excange rate that netsuite working on

AI generated answer (using internal Slack threads):

In NetSuite, the exchange rate used for transactions like Bills or Invoices is typically based on the transaction date. However, the exact rate you get will depend on the update time set on your currency page. If your update time is in the middle of the day, you could be using the previous day's rates for transactions. The default update time is usually set to 3 AM server time. To view historical exchange rates, you can use the Currency Exchange Rates page. However, this page might require you to manually enter the 'As Of' date for each day you want to view. Alternatively, you can go to Currency Exchange Rate > New > Search in the top right to create a Currency Exchange Rate search and export the rate by day. If you're seeing that the exchange rate is not changing based on the transaction date, it could be due to a few reasons. Make sure there are default exchange rates set for those dates. Also, check if there are any workflows or scripts that might be changing the exchange rate. Lastly, ensure your currency rates are set to automatically update in NetSuite. Please note that the exchange rate used in reports might differ from the transaction exchange rate. If you're seeing the same amount in a consolidated report regardless of the date it was created, it might be due to the consolidated exchange rates settings. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******