1. In Accounts Payable, go to Query.
2. Select New.
3. Choose Vendor for the Type and Dynamic for the Format and select OK.
4. Go to the Output tab.
5. Expand the Vendor section by clicking on the plus sign to the left of the word Vendor.
6. Double click Vendor name and Vendor ID.
7. Go to the Sort tab.
8. Expand the Vendor section, double click on Vendor name.
9. Go to the Results tab to view, print, or export to Excel.