We can set the value and store in the transaction body field in the sales order by using suitescript . try { var canadaShipCost = Configuration.get(“shipcost.canada”); var unitedStates = Configuration.get(“shipcost.unitedstates”); … Continue reading How to change the shipping cost in the order summary section and store that value in the custom field of the sales order
Tag: 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.