Getting values from a saved search formula column

Requirement Formula columns are all named the same internally, which is why you can’t directly get their values individually. For instance, if you have two Formula (Numeric) columns in your search, both internal column names will be “formulanumeric”. Therefore, using getValue(‘formulanumeric’) will get only the first formula value. Solution

Sales Order Customization

Requirement We need to create a new button in the sales order and if the user clicks the button, a new sales order will open and the body fields will be populated from the parent sales order (Except some fields like date). User will enter the item lines manually and save the child sales orders.… Continue reading Sales Order Customization

Customize Item Fulfillment Email

Requirement Need to add a field into the customize fulfillment email for eg: Tracking Numbers Solution Navigate to Setup > Accounting > Customize Fulfillment Email.  Copy the Default Text and paste it in the Customization box.  Remove {7} in the Customization box. Add the following to the Item Fulfillment codes:                 Tracking numbers:<br>                <%=getCurrentAttribute(‘salesorder’,’linkedtrackingnumbers’)%><br><br> 5. Click Save. 

Adding hyperlink in saved search column

Requirement Add a hyperlink in saved search to open the particular purchase order. Solution Following code snippet is a saved search code having hyperlink that open up a purchase order.

CSV Import of journal entry error message: The amounts of this journal entry must balance by location.

There are two possible reasons why a CSV results to an error: “The amounts of this journal entry must balance by location”. Enable the preference Allow Non-Balancing Classifications in Setup > Accounting >  Preferences > Accounting Preferences > General Tab >  Classifications. Checking this box means that the user prefers NetSuite to not require Journal Entries to balance… Continue reading CSV Import of journal entry error message: The amounts of this journal entry must balance by location.