Function to check duplicate manufacturer records in NetSuite. function checkForDuplicateManufacturers(currentRecord) { try{ var catalogItemsObj = {}; var manufacturerName = currentRecord.getValue({ fieldId: ‘name’ }); var normalizedName = removeSpecialCharacters(manufacturerName); var manufacturerSearch = search.create({ type: ‘customrecord_mhi_ibs_manufacturers’,… Continue reading Function to check duplicate manufacturer records
Author: Mintu Antony
Create a Saved Search to Display Role Changes on Employees Within Specific Period
Create a saved search that will display all the role changes in a specific date period on Employee records. Navigate to Lists > Search > Saved Searches > New Search Type: Click Employee Search Title: Enter a title Example: Role Changes for Q1 2021 Click Criteria Click Standard Filters: Select Role Change Date Role Change Date: Select within Quick Filters: Select this fiscal quarter Click Set Select Role Change Role… Continue reading Create a Saved Search to Display Role Changes on Employees Within Specific Period
Avoid Mandatory Custom Field Validation on CSV Import
Solution Navigate under Setup > Import/Export > Import CSV Records Click Select button for selecting CSV file Click Next Import options (2nd step): Click Advanced Options Validate Mandatory Custom Fields: Remove Checkmark Click Next Set the Field Mapping Click Next Click Save and Run
Disable line-item inventory detail button in quotes
To disable line-item inventory detail button in quotes. The following function is used. function hideInventoryDetailButton() { try { $(‘#inventorydetail_helper_popup’).hide(); $(‘[title=”Delete”]’).hide(); } catch (error) { log.error(“Error @hideInventoryDetailButton”, error); console.log(“Error @hideInventoryDetailButton”, error.message) } }
Saved search formula to list emails with keywords “Rough-In” and “Fit-Off “
The keywords “Rough-In” and “Fit-Off” can appear in the email subject or body. The saved search to list emails where keywords “Rough-In” and “Fit-Off “are present. Select Formula(text) in criteria and give the below formula. CASE WHEN UPPER({custrecord_cslo_bie_subject}) LIKE ‘%ROUGH IN%’ OR UPPER({custrecord_cslo_bie_subject}) LIKE ‘%FIT OFF%’ … Continue reading Saved search formula to list emails with keywords “Rough-In” and “Fit-Off “
Supported Purchase Order Sublist Data Imports
The Purchase Order import supports the import of the following sublist data: If you use classes, departments, or locations, you can set these values either for an entire purchase order, or per individual item/expense lines. If the Item Options feature is enabled in your account, you can import values for custom transaction item options along… Continue reading Supported Purchase Order Sublist Data Imports
How to validate mode on saveRecord() of a SuiteScript 2.0 Client Script
User wants to validate the mode in which the record is being accessed (create, copy, or edit) in the saveRecord function of a SuiteScript (SS) 2.0 Client Script. define([], function(){ var currentMode; // declare a global variable function pageInit(scriptContext) { currentMode= scriptContext.mode; } function saveRecord(scriptContext) { if(currentMode!= ‘edit’){ } } return { pageInit: pageInit, saveRecord… Continue reading How to validate mode on saveRecord() of a SuiteScript 2.0 Client Script
Saved Search Email Alert when Bill Payment is Created from Bill
The following are the Saved Search steps to create a Saved Search Email Alert once Bill is Fully Paid: 1. Navigate to Reports > Saved Searches > All Saved Searches > New > Transaction 2. Rename the Search Title 3. On the Criteria tab, enter the following filters: Type is Bill System Notes Fields… then New Value is Paid in Full… Continue reading Saved Search Email Alert when Bill Payment is Created from Bill
Create Saved Search to Display Selection in Custom Field of List/Record Type
To create Saved Search to Display Selection in Custom Field of List/Record Type 1. Retrieve Internal ID Navigate to Customization > Lists, Records & Fields > Entity Fields Desired custom field: Take note of the Internal ID Example: custentity7 2. Create Saved Search Navigate to Lists > Search > Saved Searches > New Click Customer Search Title: Enter Title Click Results Click Columns Click Remove All Field: Note: For every required field use the drop-down menu to select it and once… Continue reading Create Saved Search to Display Selection in Custom Field of List/Record Type
Remove Tax Summary Line from an Invoice
To remove Tax Summary Line from an Invoice Navigate to Setup > Accounting > Setup Taxes Click on the tab for the country which is the location indicated in the Invoice Uncheck the Print Tax Code Summary on Sales Forms checkbox Click Save Go back to Invoice Refresh the page Click Print In the Print layout, the Tax Summary lines should no longer appear