Hi,
I want to create sample list to show Sales Order Number, Sales Order Date, Sales Order Amount, Sales Order Prepayment. Sales Order Prepayment is Journal Entry transaction that related to the Sales Order by custom record. How do I create list for this situation using suitescript?
I try to create below script, but I do not know how to parse the result of the search. Anyone can help me?
/**
* @NApiVersion 2.x
* @NScriptType Suitelet
* @NModuleScope SameAccount
*/
define(['N/ui/serverWidget','N/url','N/search'],
/**
* @param {serverWidget} serverWidget
*/
function(serverWidget, url, search) {
/**
* Definition of the Suitelet script trigger point.
*
* @param {Object} context
* @param {ServerRequest} context.request - Encapsulation of the incoming request
* @param {ServerResponse} context.response - Encapsulation of the Suitelet response
* @Since 2015.2
*/
function onRequest(context) {
/*function createSearch() {
var mySalesOrderSearch = search.create({
type: search.Type.SALES_ORDER,
//title: 'My SalesOrder Search',
//id: 'customsearch_my_so_search',
columns: ['number', 'trandate', 'name', 'amount'],
filters: [
['mainline', 'is', 'T']
]
});
mySalesOrderSearch.save();
}*/
var request = context.request;
var response = context.response;
var list = serverWidget.createList({
title : 'Balance Uang Muka SO'
});
list.style = serverWidget.ListStyle.GRID;
list.addColumn({
id : 'number',
type : serverWidget.FieldType.TEXT,
label : 'SO Number',
align : serverWidget.LayoutJustification.LEFT
});
/*
list.setURL({
var output = url.resolveRecord({
recordType: record.Type.SALES_ORDER
});
})
*/
list.addColumn({
id : 'trandate',
type : serverWidget.FieldType.DATE,
label : 'SO Date',
align : serverWidget.LayoutJustification.LEFT
});
list.addColumn({
id : 'name_display',
type : serverWidget.FieldType.TEXT,
label : 'Customer',
align : serverWidget.LayoutJustification.LEFT
});
list.addColumn({
id : 'amount',
type : serverWidget.FieldType.CURRENCY,
label : 'SO Amount',
align : serverWidget.LayoutJustification.RIGHT
});
list.addColumn({
id : 'balance_amount',
type : serverWidget.FieldType.CURRENCY,
label : 'Balance Amount',
align : serverWidget.LayoutJustification.RIGHT
});
//createSearch();
var mySearch = search.load({
id: 'customsearch_my_so_search'
});
var resultSet = mySearch.run();
alert('There are ' + resultSet.columns.length + ' columns in the result set:'
);
resultSet.columns.forEach(function(col){
alert(col);
});
/*
list.addRows({
rows : [{trandate : 'value1', name_display : 'value2'},
{columnid1 : 'value2', columnid2 : 'value3'}]
});
*/
response.writePage(list);
alert('Tes');
}
return {
onRequest: onRequest
};
});