Show and print Custom Field with dollar Symbol

Scenario: You have created a custom field which can be set to print on invoice and sales order forms; however, the field displays the currency value only without a currency symbol.

Below are the steps to insert a currency symbol before the actual balance amount on invoices and sales orders:


1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New or you can Edit the existing body field.
2. Provide a label.
3. Set Type to Free-Form Text.
4. Unmark the Store Value checkbox field.
5. Click the Validation & Defaulting tab and insert this expression on the Default Value field: TO_CHAR({balance},'$999,999,999.99')


6. Make sure the Formula checkbox is checked.
7. Click Save & Apply to Forms.
8. Make sure all Show checkboxes are unchecked.
9. Mark the Print checkbox corresponding to the forms being used in your account.
10. Click Save.

If you refresh your transaction / record, you would notice the field with the dollar symbol

 

And the same will be reflected on your output PDF

 

Did this help? If not, try contacting us Submit a request

Comments