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? 

[bradeneuropeArthur]

You could link the excel file.

Or read the excel file.