<@U5TF1GQ20> This is in response to my earlier pos...
# suitescriptr
Rookie
09/09/2021, 9:46 AM@battk This is in response to my earlier post where I was trying to get a client script to scan through all the inventory detail subrecords and throw an error in case any record is missing bin number. You had asked for my code and somehow I had missed that comment, my apologies. Reposting as the eariler post is not visible anymore.
All I need to do here is throw an error if any of the inventory detail subrecord on the item receipt has data in status and quantity fields but has left the bin field empty, it should not allow the record to be saved (screenshot attached). The count is returning -1 every time.
Please find the code below:
/**
* @NApiVersion 2.x
* @NScriptType ClientScript
* @NModuleScope SameAccount
*/
define(['N/record','N/search','N/ui/dialog'], function(record, search, dialog) {
function saveRecord(scriptContext) {
var rec = scriptContext.currentRecord;
rec.selectNewLine({
sublistId: 'item'
});
subrecordInvDetail = rec.getCurrentSublistSubrecord({
sublistId: 'item',
fieldId: 'inventorydetail'
});
var numLines = subrecordInvDetail.getLineCount('inventorydetail');
var myInventoryNumber = subrecordInvDetail.getCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'binnumber'
});
var myqty = subrecordInvDetail.getCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'quantity'
});
var mystatus = subrecordInvDetail.getCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'inventorystatus'
});
dialog.alert({
title: 'Warning',
message: 'count ='+numLines
});
if(myInventoryNumber !== null) {
}
else {
dialog.alert({
title: 'Warning',
message: 'Cannot leave bin number empty '
});
}
}
return {
saveRecord: saveRecord
}
});
c
CD
09/09/2021, 9:59 AMThis line
if(myInventoryNumber !== null) {myInventoryNumberundefined!==nullb
battk
09/09/2021, 10:06 AMthere are a lot of weird things going on with that code
battk
09/09/2021, 10:07 AMid start with trying to use Column.isMandatory over trying to do mandatory in code
battk
09/09/2021, 10:19 AMwill involve deploying your client script on the inventory detail
r
Rookie
09/10/2021, 10:05 AM@battk I tried but column.ismandatory is not working so far, I noticed another thing after putting in debugging messages that the above script is getting executed from bottom up, is that normal? i cant seem to be able to find any related documentation
b
battk
09/10/2021, 10:07 AMwhat does your code look like now?
r
Rookie
09/10/2021, 10:17 AMsimilar to the previous one but with a lot of messages and they are getting executed backwards, for example 15 then 14ELSE, 13...
/**b
battk
09/10/2021, 10:18 AMid still go with the isMandatory attempt over your code
battk
09/10/2021, 10:19 AMbut the primary issue you are facing is that dialog.alert is asynchronous
battk
09/10/2021, 10:19 AMits also why your code is unsuitable for a saveRecord entrypoint
battk
09/10/2021, 10:19 AMyou need to return true to continue saving the record
battk
09/10/2021, 10:19 AMreturning nothing is the same as returning false
r
Rookie
09/10/2021, 10:23 AMahh, got it...apologies for all these questions as I am new to javascript. Thanks so much for your help 🙂
2 Views