Query Plastic Items with Partially Paid Commission

To query plastic items with settlement invoice where the commission is partially paid:

Invoice Field Comparison Value

Settle

=

I

FOP

=

P

CommRcvdAmount

>

0

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