How to deduct the quantity from consumable table when any item(mouse, keyboard) is consumed

Renu9
Tera Contributor

Hi All,

I am having a requirement, in a catalog item, there are variables such as what type of mouse needed, what type of keyboard needed, etc

When they select type of mouse, it should then check in the alm_consumable table which contains the name , quantity, status availability and assigned to , etc fields

If quantity is available for the mentioned type, then the quantity count has to be deducted from that record in consumable table and it has to be assigned to the user who raised the request.

If quantity is 50, then 1 has to be deducted and the quantity should gets updated as 49 and it has to get assigned to the requested for

 

In the workflow , I am writing the Run script but not sure how to get that assign to requested for and quantity updation

Please guide here

Renu9_0-1706688834655.png

 

 

0 REPLIES 0