custom transaction body feild

Creating a custom field that pulls results from a saved search in NetSuite

First, we need to create a saved search that the field uses for the results. And then we will create a custom transaction body field on a Sales Order to show the total of quantity of all the items that is on that Sales Order. To create a saved search, we navigate to List> Search>… Continue reading Creating a custom field that pulls results from a saved search in NetSuite

Convert Amount to Words

Create a Transaction body field and uncheck the store value check box In the Validating & Defaulting Add the Formula in the Default Value column by checking the formula checkboxFormula : CASEWHEN {payment} = 0 THEN ‘ZERO’ELSECASEWHEN FLOOR({payment}) = {payment} THENTO_CHAR(TO_DATE(TO_CHAR(TRUNC({payment}, 0)), ‘J’), ‘JSP’) || ‘ ONLY’ELSETO_CHAR(TO_DATE(TO_CHAR(TRUNC({payment}, 0)), ‘J’), ‘JSP’) || ‘ AND ‘ ||TO_CHAR(FLOOR({payment}… Continue reading Convert Amount to Words

The custom transaction body field is not showing in the Sales order record in Netsuite.

This article covers the solution for displaying the custom transaction field created for sales orders not showing in the sales order record even after checking the Applies to “Sales” checkbox. After this setup, still not showing in the sales order record. Then check these steps: Go to the sales order record. Click customize button on… Continue reading The custom transaction body field is not showing in the Sales order record in Netsuite.