topic Re: Cross referencing inventory list. in Inventor Programming Forum

Cross referencing inventory list.

rkeeleyS5869 — Thu, 26 Sep 2024 14:11:49 GMT

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?

Re: Cross referencing inventory list.

blandb — Thu, 26 Sep 2024 17:51:24 GMT

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

Re: Cross referencing inventory list.

rkeeleyS5869 — Thu, 26 Sep 2024 18:04:42 GMT

Im sorry, I dont understand your reply.

Re: Cross referencing inventory list.

ldutkaTUZ58 — Thu, 26 Sep 2024 18:10:19 GMT

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

Re: Cross referencing inventory list.

rkeeleyS5869 — Thu, 26 Sep 2024 18:17:26 GMT

Thanks I will try, question over there.

Re: Cross referencing inventory list.

blandb — Thu, 26 Sep 2024 18:28:40 GMT

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

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

Re: Cross referencing inventory list.

Michael.Navara — Fri, 27 Sep 2024 08:12:02 GMT

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.