Hi Everyone
I am facing this error when i set quan...
# suitescripta
Ahmed
05/31/2022, 5:13 PMHi Everyone
I am facing this error when i set quantity of work order completion record, This only happens when i create work order completion (with backflush) using SS 2.0 , i can successfully create work order completion (with backflush) using UI ,with exact same quantity to build. Any help would be appreciated . Thanks
{"type":"error.SuiteScriptError","name":"USER_ERROR","message":"Please enter an inventory status for each line.","stack":["anonymous(N/serverRecordService)","beforeLoad(/SuiteScripts/UE_test.js:84)"],"cause":{"type":"internal error","code":"USER_ERROR","details":"Please enter an inventory status for each line.","userEvent":"beforeload","stackTrace":["anonymous(N/serverRecordService)","beforeLoad(/SuiteScripts/UE_test.js:84)"],"notifyOff":false},"id":"","notifyOff":false,"userFacing":false}
var workOrderCompletion = record.transform({Ahmed
05/31/2022, 5:15 PM@battk Do you have any idea sir ?
b
battk
05/31/2022, 5:16 PMset the inventory status like the error is telling you to
a
Ahmed
05/31/2022, 5:18 PMI am already setting inventory detail on header level, actually this error is thrown when i set build quantity ,
This line
workOrderCompletion.setValue('quantity', qtyToBuild); //as per stack trace , error here
am i missing something ? where can i find inventory status field
Ahmed
05/31/2022, 5:20 PMWeird thing is that i dont face this error via UI ,
b
battk
05/31/2022, 5:20 PMits an inventory detail field
battk
05/31/2022, 5:21 PMthe ui will default it to the good status, scripts will not
battk
05/31/2022, 5:21 PMkeep in mind the inventory detail is at the component and body level
a
Ahmed
05/31/2022, 5:40 PMi tried to set inventorystatus but it doesnt work Actually this error is thrown even before i set inventory detail , its thrown on *workOrderCompletion.setValue('quantity',*0.4008 )
b
battk
05/31/2022, 5:40 PMwhat did the code look like
a
Ahmed
05/31/2022, 5:41 PMdefine(['N/search', 'N/record'],
function (search, record) {
function beforeLoad(context) {
try {
log.debug('beforeLoad Context Type is ', context.type);
var workOrderCompletion = record.transform({
fromType: record.Type.WORK_ORDER,
fromId: 29529,
toType: record.Type.WORK_ORDER_COMPLETION,
isDynamic: true
});
workOrderCompletion.setValue('isbackflush', true);
log.audit('workOrderCompletion ',workOrderCompletion);
//Calculate Quantity to Build and Scrap based on Parent WO ratio
qtyToBuild = '0.4008';
workOrderCompletion.setValue('quantity', qtyToBuild);
log.emergency('Quantity Value ',workOrderCompletion.getValue('quantity'));
var inventoryDetailSubRecord = workOrderCompletion.getSubrecord({
fieldId: 'inventorydetail'
});
log.emergency('Quantity Value ',inventoryDetailSubRecord.getValue('quantity'));
inventoryDetailSubRecord.selectNewLine({
sublistId: 'inventoryassignment',
});
inventoryDetailSubRecord.setCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'receiptinventorynumber',
value: '123456'
});
inventoryDetailSubRecord.setCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'inventorystatus',
value: '1'
});
inventoryDetailSubRecord.setCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'quantity',
value: qtyToBuild
});
inventoryDetailSubRecord.commitLine({
sublistId: 'inventoryassignment'
});
// log.emergency('serialLotNumberHeader ', serialLotNumberHeader);
log.emergency('qtyToBuild ', qtyToBuild);
completionNo = workOrderCompletion.save();
log.emergency('Completion ID ', completionNo);
}
catch (e) {
log.debug('Error beforeSubmit ', e);
}
}
return {
beforeLoad: beforeLoad
};
});
Ahmed
05/31/2022, 5:42 PMerror is thrown even on setValue , when i set quantity to build
b
battk
05/31/2022, 5:43 PMand the component inventory details?
a
Ahmed
05/31/2022, 5:43 PMits coming from child work orders , autopopulated
Ahmed
05/31/2022, 5:44 PMi complete child work orders and then trying to complete this specific work order
b
battk
05/31/2022, 5:45 PMset it anyways
a
Ahmed
05/31/2022, 5:46 PMsure , let me try
b
battk
05/31/2022, 5:46 PMim not even sure how you set inventory details on work orders
3 Views