Author: Hari Krishnan

Case is Always Tagged as Anonymous in an Online Case Form

This is a workaround to Enhancement 71363 Online Case Form: Please search on Contact Email rather than Company email on Select Fields: Search. Solution Edit the Online Case Form Navigate to Set Up > Support > Online Case Forms Click Edit on the Online Case Form Online Case Form:  Click Set Up Workflow Create Customer as Companies: Enter Checkmark Handle Duplicate Records: Select Update the first record… Continue reading Case is Always Tagged as Anonymous in an Online Case Form

Restrict Case Creation through Email Case Capture

When an email is sent to your NetSuite account’s Inbound Email Address, it will always create a case via Email Case Capture and we don’t have an option in the UI to prevent the case from being created. Solution You may talk to your email administrators to setup a filter wherein certain email addresses or… Continue reading Restrict Case Creation through Email Case Capture

Use of currentrecord.commitLine(Options) Method with the currentrecord.setCurrentSublistValue(Options) Method via SuiteScript 2.0 Client Script

User would like to set a sublist field’s value on a List Type Sublist using the currentRecord.setCurrentSublistValue(options) method and setting the ignoreFieldChange option to true. There are no errors encountered on the script but the sublist field’s value is not reflected correctly to the UI. The reason for this behavior is because the line item… Continue reading Use of currentrecord.commitLine(Options) Method with the currentrecord.setCurrentSublistValue(Options) Method via SuiteScript 2.0 Client Script

Substring Function in Advanced PDF Templates

For example, The user has a free-form text custom column field (id: “custcol5”) storing the specially calculated value with the value being 14.5555555555555555 and has to print this value using the Advanced Printing form but only with 2 digits after the period. Use the “substring” and “index_of” functions, built-in features of Advanced Printing.  Sample Code This will… Continue reading Substring Function in Advanced PDF Templates

Display Custom Field Checkbox Blank or Null if Not Checked

A user wants to display a Custom Checkbox as Null or Blank on Transactions sublist under the Sales subtab on Customer Records if the Checkbox is not checked or set to False. Solution Create a Custom Transaction Body Field Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New Label: Enter LabelExample: CF Checkbox ID: Enter _checkbox Type: Select Checkbox Store Value: Enter Checkmark Click Applies To Sale: Enter Checkmark Click Save… Continue reading Display Custom Field Checkbox Blank or Null if Not Checked

Set Minimum and Maximum Character Length of Custom Zip Code Field Using Workflow

Setting a maximum character length on a Free-Form Text field can be configured under the Validation & Defaulting tab of the field setup, but setting a minimum character length is currently not an option. As a workaround, create a workflow that will return a user error if a field’s minimum character length is not met.… Continue reading Set Minimum and Maximum Character Length of Custom Zip Code Field Using Workflow

Convert Total to Words in PDF

Solution Create a custom text field and apply formula for converting the amount to wordsThe formula is given below CASE WHEN {total}=0 THEN ‘ZERO’ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC({total}, 0)),’J’),’JSP’) || ‘ ‘ || ‘AND ‘ || (CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”))) = 1 THENTO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”), 0)*10),’J’),’JSP’) || ‘ ONLY’ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”), 0)),’J’),’JSP’) || ‘  ONLY’END)END Then… Continue reading Convert Total to Words in PDF