Skip to Content
Jan 02, 2017 at 11:14 AM

Define price of a material based on the purchase volume of the vendor

73 Views Last edit Oct 10, 2017 at 05:55 PM 2 rev

Hi experts!!

I want to achieve the following:

For a certain material and a certain vendor. Taking into account all the existing PO lines. Independently from dates .

If the sum of the quantity purchased from the vendor is less than 5000 -> Price is 10€

If the sum of the quanty purchased from the vendor is greater than 5000 -> Price is 8€.

It´s much like a scale but it does not depend on the quantity of a certain PO line but on the sum of all the quantities purchased from the vendor.

Any suggestion?

Thanks in advance.