1. Create a payment query.
  2. On the Criteria tab:
In Accounts Payable, select Payment, Payment Date,
In Accounts Receivable, select Basic Payment, Payment Date
  1. ​In The Edit Field Criteria window, select an  operator of <ask>. This way every time the query is run we can enter a new Payment date.  Or select equals an enter a date for the payment.
  2. On the Output tab:
In Accounts Payable, select Payment, Payment Date
In Accounts Receivable, select Basic Payment, Payment Date, Payment amount 
  1. On the Sort tab, select fields to sort the payments.
  2. Click Run