This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

This is also BAD:

Steps to round off item rate to any decimal places when printing using Advanced PDF/HTML Template:

1. Navigate to Customization &gt; Lists, Records, &amp; Fields &gt; Transaction Column Fields &gt; New
2. Fill up the values needed:
    * Label = enter your preferred label
    * Uncheck the Store Value checkbox
    * In the Applies To tab, select Purchase Item
    * You can hide this custom column field by selecting Hidden in the Display Type under the Display tab
    * In the Validation &amp; Defaulting tab, check the Formula checkbox
    * Under the Default Value field, paste the following:
        ROUND({rate},3)
        Note: Change "3" with the decimal places you want the item rate to be rounded off.
3. Click Save
4. Copy the ID of this Custom Transaction Column Field
5. Edit your Purchase Order Advance PDF/HTML Template
6. In the source code, look for the line with ${item.rate}
7. Replace this part with ${item.ENTER THE ID OF THE FIELD WE CREATED ABOVE}
    ex:
        old line item:    &lt;td align="right" colspan="4"&gt;${item.rate}&lt;/td&gt;
        new line item:    &lt;td align="right" colspan="4"&gt;${item.custcol_newrate}&lt;/td&gt;
        Note: custcol_newrate in the example above should be the ID of the field you created
8. Save