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.
Thanks in advance.