Query That Lists Non-Tracking Invoices and Refunds
The following example runs a query similar to a customer statement without payments; it only lists non-tracking invoices, refunds, and no voids.
-
At the top of the Invoice Edit & Query screen:
- Enter the account ID and invoice dates you want to query.
- From the Status drop-down list, select No Voids.
- In the Conditions area on the screen, select Settle from the Invoice Field drop-down list.
- Select <> (does not equal) from the Comparison drop-down list.
- Type T in the Value field.
-
Click the add condition () button.
The following information appears in the Conditions grid:
Inv.Settle<>"T"
-
Click SEARCH.
The Search Results grid lists invoices that match the search criteria.