Separating in stock consumables by additional attributes

[Scott Stahr]

When we're receiving consumables into our stockrooms, they're all being grouped together based on model.  For example, if we have 50 ConsumableModel10 in stock, and then receive an additional 10 ConsumableModel10s to the same stockroom, the line will display as ConsumableModel10, quantity 60.

We're often ordering these consumables for our customers and want to separate them out by customer.  Is this possible?  The desired result would look like this:

[Amarjeet Pal]

Yes, it is possible to separate consumables by customer in ServiceNow. One way to achieve this is by using location-based inventory tracking. You can create a separate stockroom location for each customer and then track the quantity of consumables in each location separately. This would allow you to see how many ConsumableModel10s are in each customer's stockroom and track usage accordingly.

Another option is to use serial numbers or lot numbers to differentiate between consumables received from different customers. When receiving consumables, you can assign a unique serial number or lot number to each item based on the customer it is intended for. This would allow you to track individual items as they are used or transferred between locations.

Finally, you could also create a custom field on your consumable table that allows you to associate each item with a specific customer. This would allow you to filter and group items based on customer when viewing inventory levels or consumption reports.