Hi @chercm
What I understood is you are expecting to deduct the stock when a Catalog Task is closed.
Try creating a business rule like the one below.
Name: Deduct asset quantity from stock
Table: sc_task
Advanced: True
When to Run Section:
When: After
Insert: True
Update: True
Conditions:
Asset :: is Not Empty
Stock Room :: is Not Empty
State :: Changes to :: Closed Complete
Advanced Section:
Script:
(function executeRule(current, previous){
var almGr = new GlideRecord('alm_asset');
almGr.addQuery('sys_id', current.u_reference_1);
almGr.query();
if(almGr.next()){
var quantity= almGr.getValue('quantity');
var req_quantity= current.request_item.quantity;
try{
quantity = quantity - req_quantity;
if(quantity >= 0){
almGr.setValue('quantity', quantity);
almGr.update();
} else{
gs.addErrorMessage('Available quantity is less than the requested quantity, unable to update the stock.');
}
}catch(ex){
gs.addErrorMessage('Unexpected Error:' + ex.message);
}
}
}
)(current, previous)
Please mark my answer helpful and accept as solution if it helped you 👍✅
Thanks,
Anvesh
