Automatic BOM Selection as per Stock availability

Hi...

I have a query.....How can i set an Automatic BOM selection as per stock availability

Problem is that the client is having more than 1 type of raw material which can be used, so the user needs to consume the ROH as per the stock availability, in that case he has to manualy check and amend the Production Order accordingly.

Hence, i want to set a system wherein the system would do the checking of the ROH material and then select that material and execute the production order accordinly.

Requesting your valuable inputs.

Thanks in advance,

Harris