Cross referencing inventory list.

[rkeeleyS5869]

Can I setup inventor to reference the companies inventory(excel file ) to see if we have run out of stock? If so, can I then create an ilogic, to make a prompt to order more stock? Or, make an if/then statement, if "quantity" is greater then "stock quantity", turn part red in .idw? 

[blandb]

May want to try this is the customization forum...

[rkeeleyS5869]

Im sorry, I dont understand your reply.

[ldutkaTUZ58]

I think he's suggesting to try the "Inventor Ideas" forum..

[rkeeleyS5869]

Thanks I will try, question over there.

[blandb]

This, sorry, its the Programming forum, not customization....

https://forums.autodesk.com/t5/inventor-programming-ilogic/bd-p/120 

[Michael.Navara]

Hi @rkeeleyS5869 

If it is closed question (yes/no) the answer is YES.

But this is very complex task. Usually this is not task for CAD but for ERP. When you design the product, you are not interested about stock quantity, because it can change hour to hour but the design process can spent days or weeks. 

Change color of components in drawing is not easy also and what should happens when the quantity is changed? Better idea is to display some information message to the user without modification of data.

If you want to try some simple proof of concept in iLogic, see the GoExcel object for communication with Excel file.