Hello everyone,
I've been working on this script a long time, it is currently working on Quotations, Sales Orders and Invoices. However, after I deployed it to Return Authorizations and Credit Memos, it doesn't seem to work.
I checked the Execution log when editing a sales order and it executed, when I create a new Return Auth/Credit Memo, there is no execution log for those.
They are deployed and released. The code I am using is below, do I need to pull the returns and credit memos differently?
/**
* @NApiVersion 2.1
* @NScriptType ClientScript
* @NModuleScope SameAccount
*/
define(['N/currentRecord','N/record','N/log'], (currentRecord,record,log)=>{
const CommLoad = (context)=>{ //edit mode load
var currRecord = context.currentRecord,
lines = currRecord.getLineCount({ sublistId: 'item' });
for(let i=0; i<lines; i++){
const lineNum = currRecord.selectLine({ sublistId: 'item', line: i });
log.debug('lineNum',lineNum);
var name = currRecord.getCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'item'});
var lAmnt = currRecord.getCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'amount'});
var lCost = currRecord.getCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'costestimate'});
var GP = Math.trunc(((lAmnt-lCost)/lAmnt)*100); GP = GP.toFixed(2);
if (GP === 'NaN') { GP = '0'; }
var PO = currRecord.getCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'createpo'});
var itemType = currRecord.getSublistValue({ sublistId: 'item', line: i, fieldId: 'itemtype'});
var CommLoaddata = 'name='+name+',lAmnt='+lAmnt+',lCost='+lCost+',GP='+GP+',PO='+PO+',itemType: '+itemType;
log.debug('CommLoaddata',CommLoaddata);
//if(itemType === 'Group' || itemType === 'EndGroup' || itemType != 'InvtPart')
if(itemType PO === 'SpecOrd' || PO === 'DropShip') {
currRecord.cancelLine({sublistId: 'item', line: i});
return true;
}
/*
if (PO === 'SpecOrd' || PO === 'DropShip') {
currRecord.cancelLine({sublistId: 'item', line: i});
return true;
}
*/
if (GP <= 14.99) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: 1
});
}
if (GP >= 15.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: 2
});
}
if (GP >= 20.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: 3
});
}
if (GP >= 25.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: 4
});
}
if (GP >= 30.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: 5
});
}
if (GP >= 35.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: 6
});
}
if (GP >= 40.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: 7
});
}
if (GP > 45.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: i,
fieldId: 'custcol3',
value: ''
});
}
} //end for
log.debug('commission updated',true);
}
const CommValidate = (context) =>{
var currRecord = context.currentRecord,
name = currRecord.getCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'item'}),
lineNum = currRecord.getCurrentSublistValue({ sublistId: 'item', fieldId: 'line' }),
lAmnt = currRecord.getCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'amount'}),
lCost = currRecord.getCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'costestimate'}),
GP = Math.trunc(((lAmnt-lCost)/lAmnt)*100); GP = GP.toFixed(2);
var PO = currRecord.getCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'createpo'});
var itemType = currRecord.getCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'itemtype'});
var CommValidatedata = 'name='+name+',lAmnt='+lAmnt+',lCost='+lCost+',GP='+GP+',PO='+PO;
log.debug('CommValidatedata',CommValidatedata);
if (GP <= 14.99) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: 1
});
}
if (GP >= 15.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: 2
});
}
if (GP >= 20.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: 3
});
}
if (GP >= 25.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: 4
});
}
if (GP >= 30.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: 5
});
}
if (GP >= 35.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: 6
});
}
if (GP >= 40.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: 7
});
}
//if (GP > 45.00 || itemType != 'InvtPart') {
if (GP > 45.00) {
currRecord.setCurrentSublistValue({
sublistId: 'item',
line: lineNum,
fieldId: 'custcol3',
value: ''
});
}
log.debug('item line '+lineNum+' updated', true);
return true;
}
const CommFChange = (context) =>{
}
return {
pageInit: CommLoad,
validateLine: CommValidate,
fieldChanged: CommFChange
};
});