How to update purchase order when item receipt is created or update
Hi, I am new to the SuiteScript. I have created User Event Script to update Item Received quantity on PO. Every single time when item receipt is created I have to go back to PO and click edit and save. Wondering if anyone know how to write back/update PO automatically when we receive Item/Item Receipt is created.
Thank you!
Chandan_007
/**
* @NApiVersion 2.x
* @NScriptType UserEventScript
*/
define([],
function () {
function beforeSubmit(context) {
try {
var totalQuantity = 0;
var totalQuantity_rec = 0;
var po = context.newRecord;
var itemCount = po.getLineCount(‘item’);
for (var i = 0; i < itemCount; i++) {
lineLevelQuantity = po.getSublistValue(‘item’, ‘quantity’, i)
if (lineLevelQuantity != ” && lineLevelQuantity != null) {
totalQuantity += parseInt(lineLevelQuantity);
}
}
for (var j = 0; j < itemCount; j++) {
lineLevelQuantity_rec = po.getSublistValue(‘item’, ‘quantityreceived’, j)
if (lineLevelQuantity_rec != ” && lineLevelQuantity_rec != null) {
totalQuantity_rec += parseInt(lineLevelQuantity_rec);
}
}
po.setValue(‘custbody80’, totalQuantity);
po.setValue(‘custbody81’, totalQuantity_rec);
} catch (e) {
log.debug({
title: ‘Error Details’,
details: e
})
}
}
return {
beforeSubmit: beforeSubmit
};
}
);