Author: Sreelakshmi R

Handling Matrix items – Netsuite Saved Search

1. Create an item saved search that excludes parent matrix items and includes all other inventory types and child matrix items. 1. Navigate to Lists > Search > Saved Searches > New > Item 2. Under Criteria tab > Standard subtab, add the filter:    • Matrix Item = False 3. Hit Save & Run.… Continue reading Handling Matrix items – Netsuite Saved Search

Compare Address Fields on Entity and Transaction

Use case: This Solution can be used when we cannot get an exact match between Address text (Ship To address as referred here) in both transaction and customer, but can essentially compare between the address fields in the subrecord. Sample Scenario: When creating a Customer record, we often enter a default address. This default address is… Continue reading Compare Address Fields on Entity and Transaction

“RECALC” Replaced by “SUBLISTCHANGED”

Before we wrap up, there is one important change to SuiteScript 2.0 Client Scripts that impacts how we work with sublists. In 1.0 Client Scripts, there is an event called recalc. This event fires whenever a change has been made to a sublist that impacts the total of a transaction. Let’s say you are editing a… Continue reading “RECALC” Replaced by “SUBLISTCHANGED”

Points to Note While using Sourced Fields in Other Customizations

Saved Search Case – A field made in a record that is sourced from another search not shown in another Saved search of the same record: A body level field (Free-from text) made in a transaction which is sourced from another search based on line fields join fields which fetches the items record’s field which… Continue reading Points to Note While using Sourced Fields in Other Customizations

Working with Address Override

A user may want to set a default value, whether marked or unmarked as default, for the Override box in the Address field of their transaction recordsSolution:For transactions that will be created manually in the NetSuite UI. the default value of the Override box in the Address field of transaction records depends solely on the default value set on the Address field in the Customer/Vendor records.For instance,… Continue reading Working with Address Override

Add Hyperlink as a NetSuite Saved Search Formula Field

NetSuite Standard Detailed Output  Saved Search Use this snippet to effectively pop open a new window when you click on the “Link”. NetSuite Group By Summary Output  Saved Search Use this snippet for summary fields and make sure you select “Group” for your summary type.