We can create an Invoice query to filter this report to only display invoices that are not yet paid or have the status of Pending.
  1. Go to Query and click New
  2. Select Invoice for the query type and Dynamic for the format
  3. Click OK
  4. On the Criteria tab, expand on the Invoice section
  5. Select Invoice Status
  6. Select equals for the Operator and Pending for the value
  7. Click OK
  8. Save the query and enter a name for it
  9. Go to Reports > Invoice Reports
  10. Select Invoice Expense Allocation Report and click New
  11. Enter the appropriate date range on the General tab
  12. On the Filters tab, change the Invoices filter from All to Selected
  13. Select the radio button for Query at the top
  14. Click the binoculars to search for the query that was saved in step 8.
  15. Click OK
  16. Click Preview to view the report