Hey All,

I'm pretty adept at using searches, but this one has been stumping me for a long time. Hopefully someone can help…

I am trying to create a search to show the GNRI (Goods Not Received Invoiced) cost associated with POs. The problem is that our vendor send us bills sometimes that don't include the items on an item receipt or they charge us a different item rate on the bill than on the PO.

If I limit my search criteria to only pull in the 'Bill' applying transaction type, then I miss cases where the item only exists on the receipt but not the bill.

I don't know if this is possible, but it makes sense that if I can count the number of applying transactions within the criteria and there is only one, then we should pull the item rate from that transaction. If there is an item receipt and bill, I would just take the rate from the bill.

How can I encapsulate this into a search without duplicating lines within my result? I am summing the results which throws off accuracy when there is more than one applying type present. If I could somehow take the max of these values before I sum, that would do it, but I don't know if this is possible.
This is a cached copy. Click here to see the original post.