Outputting all decimals of an Exchange Rate

Here's a little trick for you, when outputting the Exchange Rate field in a Saved Search. Normally, if you just select the "Exchange Rate" field in a Transaction Saved Search, Netsuite will round the rate to 2 decimals.

To get ALL the decimals, just add a Formual (Numeric) field, and type "{exchangerate}" (without quotation marks) in the Formula column. VoilĂ , all your decimals are shown!

No comments:

Post a Comment