In NetSuite, some companies requires their custom currency fields to have a dollar ($) sign. In this article, we will guide you on how to achieve this by using a formula.
Scenario:
On your Customer record, you're sourcing the Deposit Balance and you wanted to have the Dollar (&) sign to be included. However, it's just showing the number itself as seen below:
Change the Formula on your Custom Field:
Navigate to Customization > Lists, Records, & Fields > Entity Fields
On the Custom Entity Fields page, click on your Custom Field (In this case, it's NSC Test Dollar sign)
On the Custom Entity Field page, make you you have set the values below:
- Type: Free-Form Text
- Store Value: Unchecked
Validation & Defaulting subtab:
- Default Value: CONCAT('$',{depositbalance})
- Formula: Checked
Results:
Once done, a dollar sign should now be added in front of your custom field as seen below:
Now you know how to add a dollar ($) sign to your Custom Fields! I hope this helps! 😁
Want to learn more about Customization? Visit New to NetSuite: SuiteBuilder & SuiteBundler
Do you have any feedback? Let us know in the comments!