Hello,
I try to make a save search for open BO's ( Blanket Purchase orders). I want to see all open BO's with the total quantiy and amount. But I cannot use the quantity ordered which is normally displayed in the BO.
as it is not visible in the drop down. So I did a little research and found out you can acces quantity ordered with "applying transaction -> quantity". See below the Criteria and Results:
Result:
Problem is, when I group the Blanket Orders and Sum the Quantity and Total Open Quantity, the Quantity is no longer correct. the Saved Search takes all the lines and will calculate:
quantity: 15.600
open quantity: 7.800
but the quantity in the BO is 7.800..
is there an other way to sum the "total open Quantity", so it will be correct ?
thanks in advance!