A QueryPlus user wanted to be able to track down Invoice Transactions that occurred long after a Policy Expiration Date, so we created a new field.

The name of the field is Invoice Transaction Days Past Policy Expiration Date.

If you put the fields below in a query, and filter that field for a number (I used 365 to identify transactions more than a year after expiration date), you should get what you are looking for:

The output will show:

Of course, this query will only identify the 'universe' of possible erroneous invoice transactions – it's up to you to decide which are in fact proper and which aren't.

Add fields from Policy, Invoice and Invoice Transaction as necessary to provide adequate information to identify individual transactions and determine if they are erroneous.