vendor mailing labels

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (0)

Suggested answer

soma 24,406 on at

Like (0)

Report

RE: vendor mailing labels

Which report you are running?

Mostly you can get the payablestransactions list from smartlist with specific filter. First try to filter using standard Payables Transactions smartlist and get back to result.

Hope this helps!!!
callen 4,595 on at

Like (0)

Report

RE: vendor mailing labels

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')
Suggested answer

babubaskaran@outloo... on at

Like (0)

Report

RE: vendor mailing labels

Hi,

you can build refreshable excel of vendor and do all your filter condition there.