1. 1. In Accounts Payable> Query.
  2. Click New, then choose a Query Type of Vendor with a format of Dynamic.
  3. On the Criteria tab, select, Summary>Total Payment amount.

    In the operator field select greater than or equal to and enter a Value (e.g., $500.00). Before closing navigate to the Filter tab, select Payment date between enter the date range 

  4. On the Output tab, click the plus (+) sign to expand Summary .
  5. Double-click Total Payment Amount and Vendor Name.
  6. On the Sort tab, choose any fields by which you would like to sort.
  7. Click Run.