Consumable records update in Asset Management

[Mukesh G]

Hi,

By default, ServiceNow Asset management module does not allow a consumable record to be updated either in stockroom or after it is consumed. 

We would like to know recommendations whether this should be changed or not and if yes, what are the possibilities.

Some of use cases we would like to see are if we want to transfer partial quantity of consumable from one stock room to another. OR if we want to return a consumable which is consumed by a user back to stockroom.

Thanks for you help,

Mukesh

[akash_mehta]

Mukesh:  You can use transfer orders to move consumables from one stockroom to another stockroom.  I believe you need to enable the Procurement Plugin to allow this.

https://docs.servicenow.com/bundle/newyork-it-service-management/page/product/asset-management/conce...

As far as taking something back, you will need to script this out; but it is possible.

With a simple script using background scripts I was able to take back the consumable item and place it into a stockroom...

var cRec = new GlideRecord('alm_consumable');
cRec.get('00abe08d3790200044e0bfc8bcbe5d41');
cRec.stockroom = 'eaaa2b3f3763100044e0bfc8bcbe5de3';
cRec.install_status = ‘6’;
cRec.substatus = ‘available’;
cRec.update();

You should be able to also use the Script include:  Consumables and a function called mergeConsumable to assist with this.

-Akash

[Mukesh G]

Thanks Akash! We will try this and let you know how it goes.

[rin1]

Hi Mukesh,

We got a requirement that, when a request is closed for equipment, it reduces the quantity fulfilled from the stock total against the consumable item in stockroom automatically.

Can you advise on how to achieve this?

Thanks,

Rini