Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Searching for Purchase Orders Pending Receipt
I am trying to write a server side script that will search for all Purchase Orders that are Pending Receipt. Any idea what is wrong with the code below. It doesn't return any results.
function po_pending_receipt()
{
nlapiSetPortletTitle( 'Purchase Orders Pending Receipt' );
nlapiWritePortletLine('',null,0);
var columns = new Array();
columns[0] = new nlobjSearchColumn( 'tranid' );
columns[1] = new nlobjSearchColumn( 'status' );
var filters = new Array();
filters[0] = new nlobjSearchFilter( 'entity', null, 'equalTo', 298, null);
filters[1] = new nlobjSearchFilter( 'status', null, 'equalTo', 'Pending Receipt', null);
var searchresults = nlapiSearchRecord( 'purchaseorder', null, filters, columns);
for ( var i = 0; searchresults != null && i < searchresults.length ; i++ )
{
var poRecord = nlapiLoadRecord(searchresults[i].getRecordType(),searchresults[i].getID() );