I have created a custom filed in the supplier profile called "vendor type". How do i create a custom report to show all payables sorted by the vendor type?

Hi there, mlange. To view your payables sorted by the Vendor Type custom field, run the Transaction List by Supplier report. You can customize this report, apply filters, and save it as a custom report for future use.

Here's how:

1. Go to Reports and search for Transaction List by Supplier.
2. Set your desired date range.
3. Click Customize.
4. Go to the Filters section, select Account in the dropdown, and then choose Accounts Payable (A/P) in the next dropdown.
   
5. Use the Group By field to sort transactions by Vendor Type so payables are organized accordingly.
   
6. Click Save As to save the customized report for easy access in the future.

Feel free to return to this thread if you have follow-up questions.