First, create a query for all open or unpaid invoices:
  1. In Accounts Payable, navigate to Query
  2. Click New
  3. Select Invoice for the Query Type
  4. Select Dynamic for the Query Format
  5. Click OK
  6. Expand on the Summary section and select Remaining Balance
  7. In the next window that opens, select Greater Than for the operator.
  8. Enter $0 for the value
  9. Click OK
  10. Expand on the Invoice section and select Deleted
  11. In the next window that opens, select Equals for the operator
  12. Select No for the value
  13. Click OK
  14. Click Save and enter a name for the query
Next, run the Invoice Expense Allocation Report:
  1. Navigate to Reports > Invoice Reports
  2. Select Invoice Expense Allocation Report
  3. Click New
  4. On the General tab, enter the appropriate invoice and post dates or leave it set to Include All Dates
  5. On the Filters tab, change the Invoices filter selection from All to Selected
  6. Select the radio button for Query
  7. Click the binoculars
  8. Click Find Now to locate the query created in the above steps
  9. Select the appropriate query and click Open
  10. Click OK
  11. Click Preview to run the report