[zackb22 Contributions: 0Level 1☆]

Hi Everyone,

I am having issues trying to create a search that will find purchase orders with the first email in the communications tab being outgoing and then checking to see if the vendor sent an email back. This search is supposed to show purchase orders awaiting that have not been responded to yet in a certain time period. I cannot seem to think of a way to show just purchase orders with no incoming messages. Any ideas?

Thank you,

Zack
This is a cached copy. Click here to see the original post.

[Dew Contributions: 0Level 1☆]

How about something like:

Code:
Criteria > Standard: Type is Purchase Order
Main Line is True
Date is before yesterday
Criteria > Summary: (Maximum) Messages: Is Incoming is false
Results: Date (Group)
Document Number (Group)
Name (Group)

[zackb22 Contributions: 0Level 1☆]

Hi Dew,

The issue is that we also need to check to make sure that a message has been sent out. We do not want a purchase order in the list if there is no message going out. It basically needs to check that a message has gone out and then show results if there has not been an incoming message from the vendor.

What I would like is:

Criteria is There are messages on the PO and no message is incoming.

[zackb22 Contributions: 0Level 1☆]

I seemed to have resolved this. I did a case when statement on the is incoming field in messages fields… and assigned values and summed them to get my results.

Thanks for your help!

[Author]

Posts