Query can be used to create a list for only active vendors in Accounts Payable.
1. In Accounts Payable, select Query. 2. Click New. 3. Select vendor as the query type and dynamic as the query format. 4. Click OK. 5. On the Criteria tab, expand Vendor, double click Status. 6. At the Edit field criteria window, for Operator, select Equals and for Value, select Active. 7. Click OK. 8. Select the Output tab and select any additional information to view in the results. 9. Select the Sort tab and select the field and method by which to sort the active vendor results. 10. Select the Results tab to view results.
Note: To suppress duplicate vendor records, click on tools, query options, and mark suppress duplicate rows.