Scenario: The client needs to know how many vendors are created and among that how many of them are approved within this fiscal year. That is the Conversion rate = Total number of approved vendors within this fiscal year (21)/ Total number of vendors created in this fiscal year(140). For that, I have created a… Continue reading Workbook- Formula to find the conversion rate
Category: NS Customization
All articles / code related to Netsuite customization
Log Object functionalities
NetSuite loads the log Object by default for all script types. You do not need to load it manually. However, you can choose to load it using the N/log Module, for testing purposes. log Object Members log.debug(options) log.audit(options) log.emergency(options) log.error(options) log.debug(options) Method Description Logs a Debug message.Debug messages appear on the Execution tab only if the… Continue reading Log Object functionalities
Deletion of Cash Sale Records
Client needs to delete the cash sale records
Change the Lot Numbers in Cash Sale
Client needs to change the lot numbers in Cash Sale records.
Show Custom Special Instruction on Sales Order from Customer Record
Scenario Currently there is no Special Instruction field on the Sales Order record that automatically pulls the value from the Customer record. Some companies need this field to efficiently see the additional instructions associated to the Customer. In order to achieve this, a Custom Entity Field and Custom Transaction Body Field needs to be created.… Continue reading Show Custom Special Instruction on Sales Order from Customer Record
New updates on suitescript record browser
Refer to the following sections for details on SuiteScript updates for NetSuite 2023.2: 2023.2 SuiteScript Records Browser N/crypto/random Module Alternative Character Encoding for Files in Suitelet Responses The 2023.2 SuiteScript Records Browser is not yet available. N/crypto/random Module The N/crypto/random Module provides cryptographically secure pseudorandom generator methods. This module provides the following methods: random.generateBytes(options) – Generates a cryptographically… Continue reading New updates on suitescript record browser
Delete Inventory Transfer Records
Client needs to delete the inventory transfer records.
Closing Work Orders
Client Needs To Close Work Orders Using A Scheduled Script
Advantages of Postman
Automation and efficiency: Postman allows you to automate and streamline repetitive tasks, reducing manual effort and increasing efficiency. You can create and run scripts to perform various actions in NetSuite, such as creating or updating records, performing searches, or generating reports. Easy integration: Postman supports a wide range of integrations, making it easy to connect… Continue reading Advantages of Postman
Condition to display Custom KPI Results in Trend Graphs
To display a custom saved search in a trend graph: The saved search does not contain any date fields as filters on the Criteria subtab. There must be only one field with a summary type other fields should not use any kind of summary type. A date field should be defined as an available filter… Continue reading Condition to display Custom KPI Results in Trend Graphs