Assign Positive NTOTAL Value in Mail Merges from Purchase Orders

The CRMSDK tag NLTOTAL in emails / email templates merged from purchase orders shows the Total Amount as a negative value in the email sent. To convert it to a positive value, create a custom field and use the corresponding CRMSDK tag in the email template instead:

1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
2. Enter the label XTOTAL.
3. Enter the ID XTOTAL.
4. Set the Type field to Currency.
5. Uncheck the Store Value checkbox.
6. In the Applies To tab, check Purchase.
7. In the Display tab, set the Subtab to Main.
8. Set the Display Type to Hidden.
9. In the Validation & Defaulting tab, check the Formula checkbox.
10. Enter the following in the Default Value box:

ROUND(-{total},2)

11. Click Save.
12. Navigate to Documents > Templates > Email Templates.
13. Edit the email template you wish to apply the corresponding NLTAG.
14. Change all references to NLTOTAL in the template to NLCUSTBODYXTOTAL.
15. Click Save.