This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm struggling how to represent currency in which user sees saved search (based on transactions) amounts. As you know or if don't, Saved search displays amount in base currency of highest subsidiary to which role has access to or with temporary Home &gt; Set Preferences &gt; Restrictions. So the problem is how to display in what currency amounts you looking right know.

actually the logic how currency for amounts is selected is even more complicated but my question stays the same. About the logic you can read here <https://netsuite.custhelp.com/app/answers/detail/a_id/9854>

just used the amount (foreign currency) field in your search instead - it is that simple

Set this to None and then use the Amount (Foreign Currency) field. Though Sam may be right and you only need to use Amount (Foreign Currency).

Setting this option to None "unconsolidates" the Amount field though if that's useful.

well foreign currency amount displays mix of all the currencies used in the transactions. So I cant use the total of such column.