NetSuite:How to view a Vendor List in the Employee Center
OverView
If you use Employee center Role, you can’t view a Vendor Data.
But you can show Vendor List by using Suitelet.
1.Create Vendor List
Not a required process. you use Saved Search.
The scriptid of the saved search you created is used in the suitelet.
2.Create Suitelet
This script assumes a simple list.
If you want to use joins, etc., you will need to be a little more creative.
/**
* @NApiVersion 2.1
* @NScriptType Suitelet
*/
define(['N/search','N/ui/serverWidget'],
(search,serverWidget) => {
/**
* Defines the Suitelet script trigger point.
* @param {Object} scriptContext
* @param {ServerRequest} scriptContext.request - Incoming request
* @param {ServerResponse} scriptContext.response - Suitelet response
* @since 2015.2
*/
const onRequest = (context) => {
const vendorSearch = search.load({
id: //create Vendor Search Id
});
const List = serverWidget.createList({
title: 'Vendor List'
});
const columns = vendorSearch.columns;
columns.forEach(column => {
const {id,label} = column;
List.addColumn({id,label,
type: serverWidget.FieldType.TEXT
});
});
vendorSearch.run().each(result => {
const row = columns.reduce(
(accu,column) => Object.assign(accu, {[column.id]: result.getText(column)});
,{});
List.addRow(row);
return true;
});
context.response.writePage(List);
}
return {onRequest}
}
);
3.Deploy Suitelet For Employee Center
You can’t use vendor list only create script.
You must be Deploy Script.
Don’t forget to set the execution role to “Administrator” when you do so.