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.

It's only fair to share...Tweet about this on TwitterShare on LinkedInShare on Google+Share on Facebook

Zeeshan Ahmed

Leave a Reply

Your email address will not be published.