Month: August 2023

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

Writeback to the Source

In a custom flow to sync sales orders from Warroad to Touchstone, we need to writeback to the sales orders synced from the Warroad account mentioning that the syncing was completed successfully. For this, we need to include an extra Import as the last part of the flow Before we include the writeback the flow… Continue reading Writeback to the Source

QMS – Custom process of attaching inspection reports to records

With regards to attaching inspection pdf documents to item records, it is suggested to create a custom record where we would be able to attach files and see all the attached files as sublists. Create a subtab labeled ‘Inspection Document’ under the ‘Quality’ tab in Item Records. Here, we would be able to view all… Continue reading QMS – Custom process of attaching inspection reports to records

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

Not showing all WIP when using ADD WIP option & Duplicate WIP

RequirementInvestigate and solve the issue with the “ADD WIP” option, which is not displaying all the Work in Progress (WIP) entries. Currently, the ADD WIP option is only showing entries up to 7 June, even though the invoice date is 30 June. There are billable items after 7 June that have been approved, but they are not… Continue reading Not showing all WIP when using ADD WIP option & Duplicate WIP

Button under communication subtab in customer records.

>>Create a custom record. >>Create a new field in custom record >>Select list/record type. >>Select customer record in list/record. >>Check record is parent. >>Select communication as the subtab. >>Add the other required fields. >> save. >>You can see the created customer record as a list under communication subtab and new record button under this sublist.… Continue reading Button under communication subtab in customer records.

To create a custom free-form text field which will be used as a column in the item sublist.

Description: The goal is to add an editable custom sublist field in the Assembly Item record, which initially seemed not directly possible. To achieve It involved creating a custom record and custom field to serve as storage for the value entered by the user in the custom sublist field. When the user inputs a value… Continue reading To create a custom free-form text field which will be used as a column in the item sublist.

Hide Opportunity Field on Sales Order Form

1. Navigate to Customization > Forms > Transaction Forms.2. Customize the Standard Sales Order form.3. Click on Screen Fields tab. Result: On the Main tab the Show check box of the Opportunity field is grayed out. To hide the field from the Sales Order form, perform the following steps: 4. Click on Move Elements Between Subtabs button.5. Mark the Select check box of the Opportunity field.6. Select a Subtab which is not in use (or hidden).7.… Continue reading Hide Opportunity Field on Sales Order Form