ariel17
Level 1

Account management

I may have found a work around:

 

Go to Reports > Create a New Report > select Expenses > click Create > click Customize > search columns > select Customer drop down > check Customer Name > then search Transaction drop down > click Show All Columns > check A/P Paid > search Expense drop down > make sure to check Due Date, Transaction number, Transaction Date, Transaction Type, Amount, Vendor Name > then go up to Filter > Filter: A/P Paid , Operation: Equals , Value: Unpaid > then finally go to Group and in the drop down select Customer Name.

 

This should sort the report by customer, show unpaid bills with the vendor name, amount bill #, etc. Of course fill free to check and select all columns, filters, etc that pertain to what you're looking for!