Sunday, October 28, 2018

Add Dollar Sign on the Amount per Line Item when Viewing Transaction in the User Interface

1. Navigate to Customization > Lists, Records, & Fields Transaction Column Field > New.
2. Set Label to Amount with Dollar.
3. Set Type to Free Form Text.
4. Unmark Store Value.
5. On Applies to > mark Sale Item checkbox.
6. On Validation & Defaulting > Type-in Default Value with TO_CHAR({amount},'$999,999,999,999.99')
7. On Validation & Defaulting > Mark Formula checkbox.
8. Click Save.

Note:
1. The dollar sign will only work if the actual value of the field is less than the amount specified on the Default Value.
2. This will only work when viewing the transaction and not when printing it.

No comments:

Post a Comment