al3xicon
12/13/2016, 9:41 PMfunction printPickTickets(request, response) {
var vendorID = request.getParameter('custparam_vendor');
var itemSearch = nlapiSearchRecord("item", null, [
["transaction.type","anyof","SalesOrd"],
"AND",
["transaction.shipping","is","F"],
"AND",
["transaction.taxline","is","F"],
"AND",
["transaction.mainline","is","F"],
"AND",
["transaction.status","anyof","SalesOrd:D","SalesOrd:E","SalesOrd:B"],
"AND",
["transaction.quantitycommitted","greaterthan","0"],
"AND",
["type","anyof","Assembly","InvtPart","Kit"],
"AND",
["transaction.purchaseorder","anyof","@NONE@"],
"AND",
["transaction.department","noneof","18"],
"AND",
[["vendor","anyof",vendorID],"OR",["memberitem.vendor","anyof",vendorID]]
],[
new nlobjSearchColumn("itemid",null,"GROUP"),
new nlobjSearchColumn("internalid","transaction","GROUP").setSort(),
new nlobjSearchColumn("tranid","transaction","GROUP")
]
);
var xmlString = '<?xml version="1.0"?>\n<!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">\n';
xmlString += '<pdfset>';
for (var i = 0; i < itemSearch.length; i++) {
var itemSearchResult = itemSearch[i];
var soID = itemSearchResult.getValue("internalid", "transaction", "GROUP");
var file = nlapiPrintRecord('PICKINGTICKET', soID, 'PDF', {formnumber: 101});
file.setName('pickingticket_'+i+'.pdf');
file.setFolder(1627968); // folder = "Reprinted Backorders to Delete"
file.setIsOnline(true);
var fileID = nlapiSubmitFile(file);
var fileURL = nlapiLoadFile(fileID).getURL();
nlapiLogExecution('DEBUG', 'i', i);
xmlString += '<pdf src="'+nlapiEscapeXML(fileURL)+'"/>';
if (i > 22) {
// script can only handle 23!
break;
}
}
xmlString += '</pdfset>';
response.setContentType('PDF', 'picktickets.pdf', 'inline');
response.write(nlapiXMLToPDF(xmlString));
}