Hello,
My organization pays commission on very few customer sales, because of that we opted out of the additional commission/compensation module. To calculate commission I have created a save search that using a custom field on the customer record returns a commission code invoice number and total invoice amount. My issue is I need also see the part number associated with the invoice. When I turn the main line on I see the total invoice amount. When I turn the main line off I see the part number but not the total invoice amount. Can anyone point me in the right direction?
I need the saved search to show
Invoice Number Invoice Date Paid Status Total amount paid Item numbers commission code (custom field on customer record)
Thank you!
Rob Spector