You can enable the mail merge option for custom records in NetSuite through these steps: Navigate to Customization > Lists, Records, & Fields > Record Types.Click on the Custom Record you want to edit.Check the Enable Mail Merge box.After enabling the mail merge option, you can use the mail merge feature to create personalized letters,… Continue reading How to attach emails to custom records
Author: Derin Jose
Proposal For NetSuite Customer Portal
Proposal summary This proposal covers the implementation of the NetSuite customer portal for customers to request the creation of sales orders and view the orders created. Requirement The client wants to have a customer portal within NetSuite for the smooth creation and management of Sales Orders. The customers should be able to enter the order… Continue reading Proposal For NetSuite Customer Portal
How to create a template for custom-report export
You can create a custom template for exporting a custom report easily using a NetSuite saved search. For this, create a saved search in NetSuite with custom label names as the names required to be visible in the template. You can use any saved search but if you can use a saved search with similar… Continue reading How to create a template for custom-report export
Record.setSublistValue() Errors and Fixes
Here are some common errors that can cause while using Record.setSublistValue() function. If not handled these errors can stop the sublist values from rendering on the NetSuite suitelet page. INVALID_FLD_VALUE errorThis error can happen if the value is passed as the value parameter in the Record.setSublistValue() function. The type should match the value passed.e.g: form.subLists.custpage_sublist1.addField({id:… Continue reading Record.setSublistValue() Errors and Fixes
How to refer sublist values from a record in a workflow action criteria
We cannot directly refer to line field values from the sublist in a record inside a workflow action criteria. Recently, I had to create a workflow to hide the ‘Authorize Return’ for a user if the related invoice is having an item with a specific custom field value(‘Product type’ is ‘Premium appliance’). This custom field… Continue reading How to refer sublist values from a record in a workflow action criteria
Proposal For Digital Signing Integration with AdobeSign from Sales Web App
Proposal summaryThis proposal covers the integration of the Sales Web App and AdobeSign for the digital signing of documents from the Sales Web App. RequirementThe client wants to integrate their Sales Web App with Adobe Sign for digitally signing documents. The documents should be shared to users via email and from the Sales Web App… Continue reading Proposal For Digital Signing Integration with AdobeSign from Sales Web App
How to avoid timezone offset shift when displaying a date input value in typescript
I was using javascript to show the date field in ‘mm-dd-yyyy’ format from the date input field in typescript. But since the input date value was only having the date and not time, when using the ‘new Date()’ function time was set to 00:00:00 hours GMT. This caused date to shift a day before in… Continue reading How to avoid timezone offset shift when displaying a date input value in typescript
How to set any record fields through console using Suitescript
We can set any record fields using the internal id of the record, the internal id of the field, and the record.submitFields() from the ‘N/record’ module. Please refer to the following: require([‘N/record’], function(record) { record.submitFields({ type: <REC_TYPE>, … Continue reading How to set any record fields through console using Suitescript
CSV import – Invalid reference key issue fix
During CSV import sometimes record importing will fail with an error response message like ‘Invalid entity reference key…’This is due to the field mapped to the document row value having different value types. But in some scenarios, the value will look similar to that of the record field.To fix this issue check whether the correct… Continue reading CSV import – Invalid reference key issue fix
Workflow list-field comparison criteria fix
Workflow action criteria when comparing a value with list field values with a single value can return inconsistent boolean values. For example, I created a custom field ‘Approvers’ to store employees that has approval permission to a record. I was trying to compare this with the logged-in user to restrict the edit permissions of the… Continue reading Workflow list-field comparison criteria fix