Hello, how do I validate a line on a vendor bill w...
# suitescriptp
Phillip
09/10/2020, 9:56 PMHello, how do I validate a line on a vendor bill when its been added/editied for the item sublist? I only want to do the check when the user is on the item sublist
b
battk
09/10/2020, 10:04 PMwhat are you doing now? All the line validation entry points have a context object which tells which sublist triggered it
p
Phillip
09/10/2020, 10:11 PMI don't have anything yet. I would like to check when its created or editied
Phillip
09/10/2020, 10:17 PMI got the logic down. is it possible to validate on edit and create? here is my code: function validateLine(scriptContext) {
if ('item' == scriptContext.sublistId) {
var curRec = scriptContext.currentRecord
var item_id= curRec.getCurrentSublistValue({
sublistId: 'item',
fieldId: 'item'
});
log.debug({details:"item_id = " + item_id});
var iteminfo = search.lookupFields({
"type" : "item",
"id" : item_id,
"columns" : [ "custitem_pi_expenseaccounttype", ]
});
log.debug(iteminfo);
var itemexpensetype = iteminfo.custitem_pi_expenseaccounttype;
log.debug({details:"itemexpensetype = " + itemexpensetype});
if (itemexpensetype == 'Fixed Asset') {
alert('Item is a fixed asset');
return false;
}
e
erictgrubaugh
09/10/2020, 10:21 PMvalidateLinevalidateLinep
Phillip
09/10/2020, 10:24 PMthats awesome. thank you
b
battk
09/10/2020, 10:34 PMthe item filtering you are doing can be done via an item filter on the form
battk
09/10/2020, 10:34 PMthe item filter allows you to define a saved search of valid items
p
Phillip
09/10/2020, 10:37 PMthanks
3 Views