When trying to isolate auto-process transactions that were successfully processed, failed transactions are being brought in as well. When an auto-process transaction fails, it first creates a Payment/Recurring Gift first. Then it creates a disbursement entry to show that it failed. These initial transactions are being pulled in when they should not be.
This was resolved in the 7.18.0 release on 11/22/2015.
Steps to Duplicate
Click the Queries button on the menu bar
Select a category that you want to store this query in (Ex: Base)
Click New Query under the Tasks menu
Name the query Successful Auto-Process Transactions
For Starting Criteria, choose Category: Base Query: All Constituents- A
Set the Data Return Type to Journal Entries
Select All of My Criteria under MATCH
Select Journal from the Available Fields drop down box
Select Transaction Auto Process Status from the list of links
Select the Succeeded value
Click Save And – Preview
Check each result
Notice that some may say they have an Offsetting Transaction above the Date field (have to be in the transaction entry). This is an indication that the transaction actually failed to process and was not successful