Monday, May 13, 2019

Saved Search: List of Purchase Orders not Emailed to Vendors

To have a list of Purchase Orders that have not been emailed to vendors, follow the steps below:

1. Navigate to Reports > Saved Searches > All Saved Searches > New.

2. Select Transaction as search type.

3. Under Criteria tab > Standard subtab> Filter column, enter the following:

  -- Type = is Purchase Order

  -- Main Line = is True

  -- Formula (Text), on the pop-up window > *Formula box, enter

     CASE WHEN {messages.isemailed} is  NULL THEN 1 ELSE 0 END

   and still on the pop-up window, select is on the Formula (Text) and enter 1 on the box beside it.

4. Rename the search and hit Save & Run.

No comments:

Post a Comment