Month: January 2022
Project Status Field Update by Scripts NCPS-70
Project Status Filed Update Using Map Reduce Script.
Custom Role is missing in View All Roles page
Custom Role is missing in View All Roles page
Create and edit pivot tables
Pivot tables help you summarize data, find patterns, and reorganize information. You can add pivot tables based on suggestions in Google Sheets or create them manually. After you create a pivot table, you can add and move data, add a filter, drill down to see details about a calculation, group data, and more.Examples– Summarize thousands… Continue reading Create and edit pivot tables
Function to add the URL after validation to the image URLs List
Add the URL after validation to the image URLs List
Creating users in integrator.io
Add a new user Sign into integrator.io and click the avatar icon in the upper right. Click My account (or My profile if you are an administrator). Select the Users tab, and click + Invite user Enter the new user’s email address, and configure the permissions. Click Save. The user receives an email with a confirmation link. Remove a user Log in to… Continue reading Creating users in integrator.io
Points should consider for a field creation(Text field/Numeric field /Date field)
Text Field1. Minimum Input Length2. Maximum Input Length3. Accepts Special Characters4. Accepts Numeric/ Alpha-numeric/ Character Input respect to type of field5. Can user Paste into the field6. Can the user can Copy the field.7. Can Delete / Edit the TextNumeric1. Accepts Positive Input2. Accepts Negative Input Values3. Accepts Alphabets Character Input4. Accepts Special Symbols5. Max… Continue reading Points should consider for a field creation(Text field/Numeric field /Date field)
Map-Reduce script example
Map/Reduce scripts in NetSuite is a scheduled script type that can work on large set of data. It is intended for parallel bulk data operations. They offer more power and benefits over the standard Scheduled scripts.This is a sample code of a map-reduce script for sending emails to all customers with pending invoices that are… Continue reading Map-Reduce script example
Field Type Conversions
NetSuite supports field type conversions for some custom field types. After you have created a custom field, you can edit the type definition to change the Type field to another supported field type. Earlier if you convert one custom field into any other type, the data will be lost. NetSuite now supports field type conversions… Continue reading Field Type Conversions
Search to get inventory details of Lot Numbered Inventory Items
/** * function to search inventory details of lot numbered inventory items */ function invtDetailSearch(itemArray) { //An array of lot numbered item is passed as argument to this function. try { var searchResultArray = []; var JJ_invtDetailSearch = search.create({ type: “inventorydetail”, filters: [ [“item.internalid”, “anyof”, itemArray], “AND”, [“expirationdate”, “after”, “today”], “AND”, [“itemcount”, “greaterthan”, “0”], “AND”,… Continue reading Search to get inventory details of Lot Numbered Inventory Items