In NetSuite, some businesses requires the Preferred Vendor to be on the header of their Item Records. In this article, we'll guide you on how to do so by utilizing Custom Fields and Saved Searches:
Create the Saved Search:
1. Navigate to Reports > Saved Searches > All Saved Searches > New and click on Item
2. On the Saved Item Search, set the fields below:
- Search Title: <Input your Search Title here>
Under Results subtab:
- Sort by: Preferred Vendor: Name
- Field: Preferred Vendor : Name (Note: This is a joined field)
- Summary Type: Maximum
Under Available Filters subtab:
- Filter: Internal ID
- Show in Filter Region: Yes
Once the Saved Search has been created, we can now set this in the Custom Field.
Create the Custom Field:
On the Custom Item Field page, set the following fields below:
- Label: NSC Test Preferred Vendor
- Type: Free-Form Text
- Store Value: not checked
Applies to subtab:
Validation & Defaulting subtab:
- Search: <The Saved Search you created>
Note: Make you've unselected the values under Sourcing & Filtering.
Results:
Once done, it should now work regardless if the Multiple Vendor feature is enabled or not.
Now you know how to show the Preferred Vendor on the Main line of your Item Records. I hope this helped! 😁
Want to learn more about Customization? Visit New to NetSuite: SuiteBuilder & SuiteBundler
Do you have any feedback? Let us know in the comments!