Query of Invoices by Payment Status

To query items that the customer has not paid in full:

Invoice Field	Comparison	Value
CustRcvdFlag	=	N

To query paid Tracking Items:

Invoice Field	Comparison	Value
Settle	=	T
CommRcvdFlag	=	Y

For step-by-step instructions, see Query to Include ARC and Invoice Items.