Comments
For further clarifying please refer to the below comment:In standard D365FO, when creating a purchase requisition, D365FO selects prices based on trade agreements with the lowest unit price without considering available discounts. If there are two purchase price journal trade agreements with prices of 20 USD (vendor 1) and 15 USD (vendor: Vendor 2) respectively. Additionally, there are two line discount trade agreements offering discounts of 50% (vendor 1) and 10% (vendor 2). The system currently selects vendor Vendor 2 with a unit price of 15 USD for the purchase requisition. However, considering potential discounts, vendor Vendor 1 offers a better net amount as its unit price after applying a discount would be 10 USD (20 – (50% * 20)). Desired Behaviour: The system should retrieve and apply prices based on both unit prices and any available discounts to determine and select the lowest net amount.