Amount Field in Search Column
While making a search on sales order record for one client, I came across a scenario where I had to display amount field in a search column. I have added this field but it shows the different amount than sales order amount. I diagnosed this behavior and found that the client had the Multiple Currency Feature in his NetSuite account and its default/base currency was USD and order was created in CAD currency.
After some searching I found that a field named Amount (Foreign Currency) which shows the amount in the currency in which the order was created.
So the conclusion is that in transaction search columns Amount fields represent the amount is base currency of account and Amount (Foreign Currency) shows the amount in Order’s currency.