Is it possible to only show a transaction on a sav...
# general
g
Is it possible to only show a transaction on a saved search result if NONE of the items have backordered on it? formula's I've tried and don't work are: formula numberic equal to 0 {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) OR {quantity}-{quantitycommitted} - this shows all other lines transaction than the backordered Whilst I want to only display the transaction if none of them have a backorder against it..
a
Yes, do a summary filter on sum of {quantity}-nvl({quantitycommitted},0)=0. Group your search on document number. This will return only sales orders that have 0 backorders.
g
nope doesn't work... have it as both part of criteria and summary and it still doesn't work.. getting transactions where 1 line is backordered regardless