Query of Non-Paid Customer Service Fees

You can search based on Commission Received and Customer Received fields. Below is an example.

To query service fees a client has not paid:

Invoice Field	Comparison	Value
CustRcvdFlag	=	N
RevType	=	M

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