I would like to run labels on active vendors that I have issued a check for in the last two years. Is there a way to filter the selection beyond just active? When I run my current report it gives me all vendors active - far too many that I want to mail letters to.
*This post is locked for comments
You need to create a custom list using SmartList Designer or a SQL query. You'll need to use something like select [Vendor ID], [Vendor Name] from Vendors where [Vendor Status] = 'Active' and [Vendor ID] in (Select distinct [Vendor ID] From PayablesTransactions where [Document Type] = 'Payment' and [Document Date] >= '2013-01-01')
Hi,
you can build refreshable excel of vendor and do all your filter condition there.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
