pen one
01/17/2022, 6:36 PM/**
*@NApiVersion 2.0
*@NScriptType ClientScript
*/
define(['N/record','N/search', 'N/ui/dialog'], function (r,search,u) {
function fieldChanged(context) {
var recCurrent = context.currentRecord;
if((context.fieldId == 'tranid')) {
var vendorinvoice = recCurrent.getValue({
fieldId: 'tranid'
});
var vendor = recCurrent.getValue({ fieldId: 'name'});
console.log(vendorinvoice);
var sv = search.create({
type: "vendorbill",
columns : [
search.createColumn({name: "internalid", label: "Internal ID"})
],
filters : [
["type","anyof","VendBill"],
"AND",
["mainline","is","T"],
"AND",
["name","anyof",vendor],
"AND",
["tranid","is",vendorinvoice]
]
});
var pagedData = sv.runPaged({pageSize: 1000});
var printOnce = 0;
for (var i = 0; i < pagedData.pageRanges.length; i++) {
// fetch the current page data
var currentPage = pagedData.fetch(i);
// and forEach() thru all results
currentPage.data.forEach(function(result) {
// you have the result row. use it like this....
var duplicate = result.getValue('internalid');
console.log(duplicate);
if (duplicate && printOnce==0) {
printOnce++;
alert('This vendor / vendor invoice combination already exists.')
}
});
}
}
}
return {
fieldChanged: fieldChanged
};
});
battk
01/17/2022, 6:56 PMbattk
01/17/2022, 6:56 PMpen one
01/17/2022, 8:02 PM