Dynamic Preferred Supplier based on combination of cheapest price and stock availability
We are wasting a lot of time going through products in requisitions to see if they can be purchased cheaper from other suppliers other than the preferred one. This happens because a non-preferred supplier may be running a promo hence making them "preferred" temporarily. Since our supplier's stock and prices are automatically updated via feed, we do not always know who is cheaper unless we check manually.
Is there any way that the requisitions can pick the cheapest supplier (who also has the product in stock) automatically?