Hi everyone,
When I started with NetSuite, the Consolidated Exchange Rate field in saved searches confused me. I am sharing what I learned in simple words, in case it helps other new users.
Where to find this field
- Open or create a transaction saved search.
- Go to the Results tab.
- Look for the Consolidated Exchange Rate dropdown.
What is this field for?
If your company works with more than one currency, NetSuite has to convert foreign currency amounts in your search results. This field lets you choose which exchange rate NetSuite uses for that conversion. Choosing it correctly helps your saved search numbers match your consolidated reports and any KPIs or scorecards built on those searches.
The 4 options
Option | Which rate is used |
|---|
Average | The average rate of the period when the transaction happened |
Current | The rate for the date or period you select in the search filter. If you select none, the rate of the day you run the search |
Historical | The rate that was valid when the transaction happened |
Per-Account | The rate type set on each transaction’s account (average, current, or historical). This is the default |
Simple example
You created a USD 100 invoice in January. Now it is November and you run the search:
- Historical shows the back monthrate.
- Current shows the current month rate.
- Average shows the old month period’s average rate.
- Per-Account depends on how each account is set up.
Important points to remember
- The default is Per-Account, so you may not have chosen anything yourself.
- With Per-Account, one search result can use different rate types on different rows. This is normal, but it can confuse you when you check the numbers.
- If your search total does not match your financial report, check this field first.
- Use the same rate type across searches and KPIs that you compare with each other.
Tip for beginners: If your search and your report show different amounts, don’t panic. Check the Consolidated Exchange Rate setting before anything else.