JC
09/03/2021, 8:37 PMname":"INVALID_FLD_VALUE","message":"Value 0.0 outside of valid min/max range for field quantity",
CD
09/03/2021, 8:39 PMJC
09/03/2021, 8:39 PMCD
09/03/2021, 8:40 PMJC
09/03/2021, 8:40 PM/**
* @NApiVersion 2.x
* @NScriptType UserEventScript
* @NModuleScope SameAccount
*/
define(['N/record', 'N/search'],
/**
* @param {record} record
* @param {search} search
*/
function(record, search) {
function beforeLoad(scriptContext) {
var recType = record.load({type: record.Type.ITEM_FULFILLMENT, id: 5679548, isDynamic:true});
var count = recType.getLineCount({sublistId:'item'});
for ( var i=0; i < count ; i++)
{
var selectLine = recType.selectLine({sublistId:'item',line:i});
var id = recType.getCurrentSublistValue({sublistId:'item',fieldId:'id'});
var fulfillmentQty = recType.getCurrentSublistValue({sublistId:'item',fieldId:'quantity'});
var nsdrReturn = recType.getCurrentSublistValue({sublistId:'item',fieldId:'custcol_delivery_routing_return_qty'});
var adjQty = fulfillmentQty - nsdrReturn;
log.debug({
title: ({title: 'new qty'}),
details: adjQty
})
log.debug(id + fulfillmentQty + nsdrReturn);
recType.setCurrentSublistValue({sublistId:'item',fieldId:'quantity',value: adjQty});
recType.commitLine({sublistId:'item'});
}
//commit the item record. The sublist will update
recType.save();
}
return {
beforeLoad: beforeLoad,
};
});
JC
09/03/2021, 8:41 PMadjQty
recType.setCurrentSublistValue({sublistId:'item',fieldId:'quantity',value: adjQty});
battk
09/03/2021, 8:58 PMbattk
09/03/2021, 8:58 PMbattk
09/03/2021, 8:59 PMbattk
09/03/2021, 9:00 PMJC
09/03/2021, 9:00 PMJC
09/03/2021, 9:01 PMJC
09/03/2021, 9:02 PMJC
09/03/2021, 9:02 PMbattk
09/03/2021, 9:06 PMbattk
09/03/2021, 9:07 PMbattk
09/03/2021, 9:07 PMJC
09/03/2021, 9:21 PMbattk
09/03/2021, 9:22 PMbattk
09/03/2021, 9:22 PMJC
09/03/2021, 9:22 PMJC
09/03/2021, 9:26 PMnsdrReturn
is set as a Text value and I just tried this:
ecType.setCurrentSublistValue({sublistId:'item', fieldId:'quantity', value: fulfillmentQty});
This works
ecType.setCurrentSublistValue({sublistId:'item', fieldId:'quantity', value: fulfillmentQty - nsdrReturn});
This errored out with the same decimal error 0.0battk
09/03/2021, 9:33 PMbattk
09/03/2021, 9:33 PMCD
09/03/2021, 9:35 PMCD
09/03/2021, 9:36 PMJC
09/03/2021, 9:48 PMJC
09/03/2021, 9:49 PMbattk
09/03/2021, 11:41 PMbattk
09/03/2021, 11:41 PMSciuridae54696d
09/04/2021, 4:56 PMSciuridae54696d
09/04/2021, 4:58 PM