Inbuilt Table in ServiceNow for handling Parts ( consumable IT asset)

Shubham_1120131
Tera Contributor

Hello Everyone, 

 

I would like to know if there a preexisting table in ServiceNow that is designed for handling Part (consumable IT asset). 

Allow me to further explain myself by what does a Part means. Part is something that once is received is not tracked like Asset which have unique identifier like Serial Number, Asset Number. We don't have anything like that for the parts. 

 

My use case is I want to find all the Asset and Parts that were purchased under one Purchase Order number or Invoice Number (Purchase Order is the parent for Invoice Number). So currently we use alm_hardware where we track all the Assets with there cost and Purchase Order. I wonder if there is a preexisting table in ServiceNow, which I can use for doing the same for the Parts where I only want to inventory the IT equipment by there quantity and not any other unique identifier. 

I really appreciate anyone taking their time for answering my question. 

Thank You!!

1 ACCEPTED SOLUTION

Amitoj Wadhera
Kilo Sage

Hello @Shubham_1120131 ,

 

In ServiceNow, there isn't a specific out-of-the-box table exclusively designed for tracking consumable IT parts (those without unique identifiers such as serial numbers or asset tags) in the same way that assets are tracked. However, there are a few ways you can manage this requirement using existing tables and possibly some customization.

  1. alm_asset Table: The alm_asset table can be used for general asset management, and it is possible to utilize this table to track consumable parts by not assigning unique identifiers to them. You can categorize these items differently to distinguish them from traditional assets.

  2. cmdb_ci Table: The cmdb_ci table is used for configuration items and can also be extended or customized to handle different types of assets, including consumable parts. You might need to create a specific CI class for consumable parts.

  3. alm_stockroom and alm_stockroom_item Tables: These tables are part of the ServiceNow Asset Management module and are designed to track inventory items in stockrooms. While primarily intended for spare parts and inventory management, they can be adapted for consumable parts. You can track the quantity of items in stock without requiring unique identifiers.

    • alm_stockroom: This table manages the locations of stockrooms.
    • alm_stockroom_item: This table tracks the items within a stockroom, including quantities.
  4. Custom Table: If none of the existing tables perfectly fit your requirements, you can create a custom table to manage consumable parts. This table can have fields for quantity, part number, description, purchase order number, and invoice number.

Steps to Manage Consumable Parts in ServiceNow

  1. Using alm_stockroom_item Table:

    • Define Stockrooms: Set up stockrooms where the consumable parts will be stored.
    • Add Items: Add consumable parts to the alm_stockroom_item table with details like quantity, part number, description, and purchase order number.
  2. Customizing or Creating a Table:

    • Extend an Existing Table: You can extend the alm_asset table or the cmdb_ci table to add specific fields relevant to consumable parts and remove fields that are unnecessary.
    • Create a New Table: Define a new table, perhaps named u_consumable_parts, with fields such as part number, quantity, description, purchase order number, and invoice number.
  3. Relate to Purchase Orders and Invoices:

    • Ensure that there are fields in your chosen table to reference the purchase order (proc_po) and invoice (proc_invoice) tables.
    • Create relationships between these tables to allow for queries that can find all assets and parts associated with a specific purchase order or invoice number.

Example Custom Table Structure for Consumable Parts

 

Table: u_consumable_parts
Fields:
- Part Number (u_part_number)
- Description (u_description)
- Quantity (u_quantity)
- Purchase Order Number (u_purchase_order_number)
- Invoice Number (u_invoice_number)
- Cost (u_cost)
- Stockroom (Reference to alm_stockroom)

 

 

Querying Data

You can use ServiceNow's reporting and querying capabilities to find all assets and parts associated with a particular purchase order or invoice number by joining the alm_asset, alm_stockroom_item, and proc_po tables.

 

If you find my response helpful, please consider marking it as the 'Accepted Solution' and giving it a 'Helpful' rating. Your feedback not only supports the community but also encourages me to continue providing valuable assistance.

 

Thanks,

Amitoj Wadhera

View solution in original post

1 REPLY 1

Amitoj Wadhera
Kilo Sage

Hello @Shubham_1120131 ,

 

In ServiceNow, there isn't a specific out-of-the-box table exclusively designed for tracking consumable IT parts (those without unique identifiers such as serial numbers or asset tags) in the same way that assets are tracked. However, there are a few ways you can manage this requirement using existing tables and possibly some customization.

  1. alm_asset Table: The alm_asset table can be used for general asset management, and it is possible to utilize this table to track consumable parts by not assigning unique identifiers to them. You can categorize these items differently to distinguish them from traditional assets.

  2. cmdb_ci Table: The cmdb_ci table is used for configuration items and can also be extended or customized to handle different types of assets, including consumable parts. You might need to create a specific CI class for consumable parts.

  3. alm_stockroom and alm_stockroom_item Tables: These tables are part of the ServiceNow Asset Management module and are designed to track inventory items in stockrooms. While primarily intended for spare parts and inventory management, they can be adapted for consumable parts. You can track the quantity of items in stock without requiring unique identifiers.

    • alm_stockroom: This table manages the locations of stockrooms.
    • alm_stockroom_item: This table tracks the items within a stockroom, including quantities.
  4. Custom Table: If none of the existing tables perfectly fit your requirements, you can create a custom table to manage consumable parts. This table can have fields for quantity, part number, description, purchase order number, and invoice number.

Steps to Manage Consumable Parts in ServiceNow

  1. Using alm_stockroom_item Table:

    • Define Stockrooms: Set up stockrooms where the consumable parts will be stored.
    • Add Items: Add consumable parts to the alm_stockroom_item table with details like quantity, part number, description, and purchase order number.
  2. Customizing or Creating a Table:

    • Extend an Existing Table: You can extend the alm_asset table or the cmdb_ci table to add specific fields relevant to consumable parts and remove fields that are unnecessary.
    • Create a New Table: Define a new table, perhaps named u_consumable_parts, with fields such as part number, quantity, description, purchase order number, and invoice number.
  3. Relate to Purchase Orders and Invoices:

    • Ensure that there are fields in your chosen table to reference the purchase order (proc_po) and invoice (proc_invoice) tables.
    • Create relationships between these tables to allow for queries that can find all assets and parts associated with a specific purchase order or invoice number.

Example Custom Table Structure for Consumable Parts

 

Table: u_consumable_parts
Fields:
- Part Number (u_part_number)
- Description (u_description)
- Quantity (u_quantity)
- Purchase Order Number (u_purchase_order_number)
- Invoice Number (u_invoice_number)
- Cost (u_cost)
- Stockroom (Reference to alm_stockroom)

 

 

Querying Data

You can use ServiceNow's reporting and querying capabilities to find all assets and parts associated with a particular purchase order or invoice number by joining the alm_asset, alm_stockroom_item, and proc_po tables.

 

If you find my response helpful, please consider marking it as the 'Accepted Solution' and giving it a 'Helpful' rating. Your feedback not only supports the community but also encourages me to continue providing valuable assistance.

 

Thanks,

Amitoj Wadhera