Another option (like #1) would be to only collect PO's whose state is 'on-order'. This has the added effect of avoiding "canceled" PO's.
Another option (like #1) would be to only collect PO's whose state is 'on-order'. This has the added effect of avoiding "canceled" PO's.