NetSuite: How to export complete currency exchange rates table?

You can not do this as usual. You need to do the following hack.

  1. Click on “New” under Lists > Accounting>Currency Exchange Rates
  2. Click on “Search” to the upper left corner of the screen
  3. Click “Create Saved Search”
  4. On the Criteria, add the Effective Date with conditions “within” for FX between two dates or select “on or after” etc as per your need
  5. In the results, select the Base Currency/ Transaction Currency/ Effective Date and the Exchange Rate
  6. Save and Run

 


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>