Has anyone created a report or search that shows vendors who have bills in prior 3 months but are missing bills in the current month? We're trying to create a report that helps with listing for accruals that will basically spit out a list of vendors that we need to check in on or accrue for that have bills in the last 3 months but no bills in the current month for close. I'm able to get the listing of summarized vendors who have bills in the prior 3 months but having trouble with getting the filter/criteria right to pull out only missing bill vendors

what are your criteria now? I'm thinking you need a Vendor (not Transaction) search. Join the Transaction Fields table. Then Summary criteria Count (prior 3 month's bills) > 0 AND Count (current month bills) = 0

Or maybe you could look at it a different way - you could use the open Purchase Order's with "Pending Bill" status (i.e. you are expecting a Bill at some point). I'm not sure of your exact scenario, so this might not be possible for you.

@Lee Hopper you reminded me of another way I did it for another client. using memorized transactions which any due and still remaining at the end of month were followed-up. This also captures annual renewals not just the 90 day window.