By this report you can get best price, from Production Planning Tool you can generate Material Request their is no link b/w Material Request and Supplier Quotation
i understand your issue, do you have any design for this.
not sure but if we could make a purchase order from items
In production plan tool, there would be a table that would show the required qty of item (the 1 we get in excel sheet)
With each item, there would be a link to generate purchase order.
on click, purchase order form would open which would allow only 1 item and give all available quotes for this specific item
once selected a rate, supplier would automatically be updated in supplier text box and then all that is left is to submit the order.
A new feature has just been added in the past few days for exactly this purpose. To use in your example. You would use the tool to go through each item in the quotation, then set the default supplier based on the best price for each of them. Once you’ve done that, you can create production orders by pulling in the material requests based on supplier.