My requirement is to pull the values of Note fields (Type,Memo,Title etc.) of a purchase order and need to concatenate all the Note fields and set them into field on purchase order form.Please let me know how should proceed?
Solutions tried by me :1.i created userevent on edit of purchase order and i m pulling all notes field values by creating saved search in script itself,but problem cmes when directly persong add new notes and edit any previous note script is not gettin fired .To prevent this ,i deployed my script on note instead of purchase order but in this case search filter of saved search is not working in which i m picking usernotes of particular purchase order by using internal id of particular PO.
Please let me know if i am implementing something wrong.
Below is the code used by me :
function afterSubmit(type)
{
nlapiLogExecution('debug','Entered inside function body');
if (type =='create' ||type == 'edit'||type == 'xedit')
//if (type !='delete')
{
try
{
var purchaseOrder = nlapiGetNewRecord();
nlapiLogExecution('debug','purchase order',purchaseOrder);
var purchaseOrderid = nlapiGetRecordId();
nlapiLogExecution('debug','purchase order id',purchaseOrderid);
nlapiLogExecution('debug','Entered inside try body');
// Define search filters
var filters = new Array();
filters[0] = new nlobjSearchFilter('internalid', 'transaction', 'anyof', purchaseOrderid);
nlapiLogExecution('debug','filter 0',filters[0]);
//filters[1] = new nlobjSearchFilter('number','transaction', 'noneof', '@NONE@');
//nlapiLogExecution('debug','filter 1',filters[1]);
filters[1] = new nlobjSearchFilter('name','transaction', 'noneof', '@NONE@');
//filters[3] = new nlobjSearchFilter('name','transaction', 'noneof', '@NONE@');
filters[2] = new nlobjSearchFilter('type','Transaction', 'anyof', 'PurchOrd');
nlapiLogExecution('debug','filter 1',filters[2]);
//filters[4] = new nlobjSearchFilter('mainline','Transaction', 'equalto', 'yes');
//nlapiLogExecution('debug','filter 1',filters[2]);
var columns = new Array();
columns[0] = new nlobjSearchColumn('author', null, null);
nlapiLogExecution('debug','filter 1',columns[0]);
columns[1] = new nlobjSearchColumn('note', null, null);
nlapiLogExecution('debug','filter 1',columns[1]);
columns[2] = new nlobjSearchColumn('type','transaction', null);
nlapiLogExecution('debug','filter 1',columns[2]);
columns[3] = new nlobjSearchColumn('number','transaction', null);
nlapiLogExecution('debug','filter 1',columns[3]);
var searchresults = nlapiSearchRecord('note',null, filters, columns);
nlapiLogExecution('debug','search statement executed');
nlapiLogExecution('debug','search results',searchresults);
for ( var i = 0; searchresults != null && i < searchresults.length; i++ )
{ // access the values of modified & created voucher fields
nlapiLogExecution('debug','search results',searchresults.length);
nlapiLogExecution('debug','search results',searchresults);
var author = searchresults[i].getValue('author');
nlapiLogExecution('debug','author',author);
var note = searchresults[i].getValue('note');
nlapiLogExecution('debug','note',note);
//var snfield = searchresults[i].getValue('type','transaction');
//nlapiLogExecution('debug','snfield',snfield);
//var snoldvalue = searchresults[i].getValue('number','transaction');
//nlapiLogExecution('debug','snoldvalue',snoldvalue);
var setValue =new Array();
setValue[i]=(author +note);
nlapiLogExecution('debug','setValue[i]',setValue[i]);
purchaseRec.setFieldValue('custbody_rcrejectionnotes',setValue[i]);
nlapiSubmitRecord(purchaseRec,true);
}
}
catch(e)
{
nlapiLogExecution('Error', 'Approver Comments', e.toString());
//nlapiSendEmail('shivali.ahuja@simplion.com', 'shivali.ahuja@simplion.com', 'Error in comments', e.toString());
//exit script
return;
}
}
}