The Vendor Activity report can be sorted to include just the Vendors listed as 1099 Vendors.
1. In the Accounts Payable module select Query from the navigation bar. 2. Choose New and select Query type: Vendor and Query format: Dynamic > Click OK 3. On the Criteria tab, expand the Vendor menu and double-click 1099 Vendor 4. Choose Operator: equals and Value: Yes 5. Click OK 6. Save and Close 7. Click Reports from the navigation bar > choose Vendor Reports 8. Highlight Vendor Activity Report and select new 9. Click on the Filters tab > choose selected for Vendor > choose the Query radio button 10. Click on the binoculars next to Query name and select the correct query > click OK 11. Click Preview 12. Save and Close the Report