How do I go about generating a list of vendors sorted by their payment type? I want to know which vendors I pay are paid by EFT, Cheque, etc.
How do I go about generating a list of vendors sorted by their payment type? I want to know which vendors I pay are paid by EFT, Cheque, etc.
Hello Andrew. Do you have ODBC connections or MS Query Wizard through Excel? If so, you can extract the data into a query by pulling information from the AP Master file. The field you would want to pull into your report would be "Default_Payment_Type". It will show up as either "Electronic" or "Cheque".
Hi Andrew,
One way to do this would be to go to Inquiry, Vendor Inquiries, Address/Phone List (Though most inquiries start with a list of vendors so you could really use any number of them).
Add the column for Default Payment Type and click the Export to Excel button, then use Excel to sort by payment type.
Thanks!
*Community Hub is the new name for Sage City