I am creating an inventory table from the task table.

[terp]

I am creating an inventory table from the task table.   I would like to have a 1:1 association with a catalog item.   When the user requests an item from the Catalog then the status in the task table would change from "available" to "on order or reserved".       Would appreciate any suggestions how to make the connection between the new "inventory" task table and the "maintain items" table.  

[Pradeep Sharma]

Hi Eric,

If you have a workflow on your catalog item then you can use the "Run script" activity on the workflow. You can GlideRecord the target table "Inventory" task table and update the values.

Please let me know if you have any questions.

[Community Alums]

Hi Eric,

I am curious about your approach here. Why did you choose to extend your inventory from task? Have you already looked at the asset and inventory capabilities we have in the platform? These allow you to create catalog items that will use the catalog tasks. When the request is made, you can choose to source the request from existing stock or proceed through a procurement process. You can then maintain your inventory in this way. Because inventory is not a task, I'm not sure the table you created would be the best approach here.

Ben

[terp]

Hi Ben,

100% agree with you. I initially started building the app out using the asset management capabilities.   Changed to building this out using the task table because, I wanted to capture the tasks associated with the workflow activity as the request went through the approval process.     I want to capture the asset items and the activities that each   assigned individual/group has to take at the product is approved for procurement, receipt, staging and shipment.   Thanks for the response.  

[terp]

For my own piece of mind:

About 5 months ago, without prior development or ServiceNow experience, I was given the task to develop a vehicle inventory and sales application in ServiceNow in 1 month.  

After many ups and downs, use of the ServiceNow community and other resources I successfully completed the custom application.   I am continuing to work with ServiceNow and seeing first hand the power out of the box functionality.

For my own personal knowledge and growth, I would like to tackle this project again and recreate this application using out of the box functionality but I need to solicit some great minds and thoughts on structure.

There were a couple of criteria:

1. The customer should be able to check for available inventory and submit an order from the inventory
2. The customer should be able to build/request a brand new vehicle
3. The inventory manager should be able to view and manage data about the inventory vehicles (costs, vehicle features,   invoice number, etc).
4. All users should be able to view the status of their order in the Supply Chain process (on order, in transit, shipped, etc)

The application could be thought of as a blend between CarMax (inventory) and a local dealership (build a new vehicle).

What needs to be captured:

1. All the attributes (specs) of the vehicle (4wd, honda, 2 door)
2. All the financial data ( vehicle cost $10,000, deprecation amount )
3. Customer info ( name)
4. Location (Maryland)

The ask:

• Which out of the box tables would you use to build this application?
• What tables would you create?
• What in-active plug-ins would you recommend using (if any)?

Planning is important and I appreciate your thoughts on how one would use the out of box ServiceNow functionality.  

Many thanks in advance.

Gentlemen, thank you for your thoughts earlier.   @Ben Sweetser,@Pradeep Sharmabsweetser