define([‘N/record’, ‘N/search’, ‘N/format’],
/**
/ (record, search, format) => { “use strict” /*
* Get sales order details.
* @returns {Array} Array of sales order details.
*/
function getSalesDetails(openBoxSNumber,openBoxDate,openBoxItem) {
try {
let salesorderSearchObj = search.create({
type: “salesorder”,
filters:
[
[“status”, “noneof”, “SalesOrd:H”, “SalesOrd:C”],
“AND”,
[“type”, “anyof”, “SalesOrd”],
“AND”,
[“custcol11”, “is”, openBoxSNumber],
“AND”,
[“datecreated”, “after”,openBoxDate ],
“AND”,
[“item”,”is”,openBoxItem],
“AND”,
[“mainline”,”is”,”F”],
“AND”,
[“cogs”,”is”,”F”],
“AND”,
[“taxline”,”is”,”F”],
“AND”,
[“shipping”,”is”,”F”]
],
columns:
[
search.createColumn({ name: “type”, label: “Type” }),
search.createColumn({ name: “internalid”, label: “Internal ID” }),
search.createColumn({ name: “custcol11”, label: “Open Box/Display Serial Number” }),
search.createColumn({ name: “datecreated”, label: “Date Created” })
]
});
let salesOrderResults = [];
salesorderSearchObj.run().each(result => {
let salesSerialNumber = result.getValue({ name: “custcol11” });
let soId = result.getValue({ name: ‘internalid’ });
let soDate = result.getValue({ name: ‘datecreated’ });
salesOrderResults.push({ soId, salesSerialNumber, soDate });
return true;
});
return salesOrderResults;
} catch (e) { log.error({title:"error in getSalesDetails",details:e});
return [];