ANS-0905 · CUSTOM FIELDS, RECORDS & FORMS
How to Add a Blank Line to NetSuite Transaction Printouts Using Custom Fields?
This guide explains how to configure a custom transaction column field to display a blank line on NetSuite transaction printouts, addressing common issues related to hidden default item columns.
Short answer
To add a blank line on NetSuite transaction printouts, create a custom transaction column field. Ensure it's configured as 'Free Form Text' with 'Store Value' set to false and applied to 'Sale Item'. If the default Item column is hidden, replace `{item}` in your formula with the custom column sourcing the item, such as `{custcol_mt_item}`, to ensure the blank line renders correctly.
Scenario
Users often seek to include blank lines on NetSuite transaction printouts for formatting or readability. When attempting to implement this using a custom transaction column field with a formula, the blank line may not appear as expected on the printouts. This issue can arise even when initial configurations seem correct, leading to a need for further investigation into field dependencies.
Solution
To add a blank line to NetSuite transaction printouts, a custom transaction column field should be created or reconfigured.
Create a custom transaction column field.
Set the field type to 'Free Form Text'.
Ensure 'Store Value' is set to false.
Check the 'Sale Item' box.
Apply the field to the relevant transaction form.If the blank line still does not appear on printouts, investigate the visibility of the default Item column. A common cause for the formula failing is when the default Item column is hidden, and its value is sourced into a custom column. In such cases, the {item} formula will not function as intended.To resolve this, replace {item} in your custom field's formula with the ID of the custom column that sources the item. For example, if the default item column is sourced in a custom column named MT Item with the ID {custcol_mt_item}, the formula should be updated to use:
{custcol_mt_item}This ensures the formula correctly references the item data, allowing the blank line to display on transaction printouts.
Expert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support
