This is what I did to get the report with the open invoices, vendor and customer.
This will sort by customer.
Reports:
Transactions by Account
All dates (adjust to however you process AP)
Customize
Rows/ Columns
Group by: Customer
Select the following: Date, transaction type, number, name (vendor), account number, memo/description, amount(you can adjust these if needed to fit your needs)
Remove: Split
Filter:
Transaction Type- Bill in the drop down
A/P Paid- Unpaid in the drop down
Hope this helps someone!
