Scenario: If we want to get the exact line from which the item in Item Fulfillment is selected (mostly required if same items are added multiple times in Sales order) we can use of ‘orderline‘ field in IF record and ‘line‘ field in SO record. The line field value in SO will be populated in… Continue reading NetSuite IF & SO connecting field for Item Sublist in script
Author: Swapna Lazar
Avoiding Duplicate Numbering on allowing override of Auto generated Document numbers.
Overriding preferences in NetSuite: we can allow overriding the auto-generated transaction number on Setup > Company > Auto-Generated Numbers > Document Numbers > Allow Override. The main issue raised on overriding the document number is Duplicate Numbering. Scenario: Duplicate numbering happens on the following scenarios: a. When users creates a same transaction (e.g. Invoice), and the Duplicate… Continue reading Avoiding Duplicate Numbering on allowing override of Auto generated Document numbers.
Inventory Count Record
The Inventory Count feature supports improved tracking of inventory and tighter control over assets. When this feature is enabled, you can enter regular periodic counts of on-hand item quantities to maintain inventory accuracy. Keeping an accurate item count can help reduce required safety stock, which lowers your overhead costs. We can create an inventory count… Continue reading Inventory Count Record
Scheduling Emailing Reports In NetSuite
Requirement: Client needs to send email to a sales rep on every Monday at 8.00am with the report generated. Steps: 1. In report view, click on the clock icon located in the bottom right of the page. 2. Enter a name and date for your report. a. Schedule Name field: Enter a name for the… Continue reading Scheduling Emailing Reports In NetSuite
Modifying Address Sub record In NetSuite
Addresses are saved as sub records in NetSuite. The sublist is called “addressbook” and is indexed by “addressbookaddress”.Here are the standard fields in the sublist for “addressbook”. Label – not unique and if omitted becomes Address Line 1defaultbilling – must be unique to one addressdefaultshipping – must be unique to one addressisresidential – can apply to any or all addresses… Continue reading Modifying Address Sub record In NetSuite
Creating a Custom List Page with SuiteScript 2.x
The following screenshot displays a list page created by a Suitelet. Steps for Creating a Custom List Page as above with SuiteScript 2.x: Create a Suitelet, and add the required JSDoc tags. Add the define function to load the N/ui/serverWidget Module module. To enable a Submit button, create an onRequest function. In the onRequest function create an… Continue reading Creating a Custom List Page with SuiteScript 2.x
Setting Field Values Using the Date JavaScript Object
Scenario:A developer uses the JavaScript Object new Date() when setting date field values via SuiteScript and is uncertain of the timezone being used by the API. Solution: The date and time that is set to fields accepting new Date() varies depending on the current timezone set on the local computer it is running on. So in order… Continue reading Setting Field Values Using the Date JavaScript Object
Inline Editing (xedit) as a User Event Type
To set a user event script to execute in response to an inline edit field change or a mass update, specify xedit as the type argument in your script. The xedit type can be specified in beforeSubmit or afterSubmit user event scripts. The following sample shows a user event script that will execute when a user inline edits a record, or… Continue reading Inline Editing (xedit) as a User Event Type
Using the Sent Email List
The Sent Email List provides a view into all outgoing email sent from an account. You can view email that was delivered successfully as well as email that was not delivered to the recipient. By default, the Sent Email List and search capabilities are only accessible to users with the Administrator role. You have several… Continue reading Using the Sent Email List
Rectify issue in image URL
While copying and pasting the URL path for image, some time the script may show error “expected ; after c;”. To rectify this type of error replace “&” in URL with “&“ sample URL encountered error: https://sysytem.app.netsuite.com/core/media/media.nl?id=3832128&c=4976925_SB1&h=Rx6_HaBOhJh08szddls0FQCHh5RWLyaWg_5FFEQD5ARDr61T Rectified URL:https://system.app.netsuite.com/core/media/media.nl?id=3832128&c=4976925_SB1&h=Rx6_HaBOhJh08szddls0FQCHh5RWLyaWg_5FFEQD5ARDr61T