How to Query on payments, including the associated expense account information from the Invoice record
1. Create a new payment query. 2. Select Dynamic for the format. 3. On the Criteria tab, select any desired fields.
a. For just the debits (expense side of the invoice distribution), add Invoice > Invoice Account Distribution > Distribution Type (select Debit) b. For a payment date range, select Payment > Payment Date > Operator of equals or between (and choose specific dates)
4. On the Output tab, select any desired fields, such as the following:
a. Invoice > Invoice account distribution, Account number (or description) b. Payment > Payment number c. Payment > Payee Name d. Payment > Payment Date (if not already present) 5. Select any other desired fields on the Output tab. 6. Run the query.