Tuesday, September 25, 2018

Transaction Body Field Formula to Show $ and Comma with Values over $1000

When a user prefers to have a custom field to show the Total with $ and Comma for values over 1000, here is how.

1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
2. Enter a Label for the field.
3. Set the Type to Text Area.
4. Uncheck Store Value.
5. Under Applies To tab, mark Sale.
6. Under Validation & Defaulting tab, mark the Formula field and in the Default Value box enter to_char(({total}),'$99,999,999.99').
7. Click Save.  

No comments:

Post a Comment