Exporting the default Commission Plan for each customer

I am interested in performing a Customer Explore and exporting the results to Excel.  The problem I'm running into is that the field 'Commission Plan' doesn't seem to be a field that I can display or export from the Customer Explore function.  I know that I can see 'Commission Plan' in the Invoice explore function, but that's not going to help me with what I need to do.

Can anyone advise of a way to export the default Commission Plan assigned to each customer?

  • 0

    Customer commission plans are stored at the address level.  You could go into customer address and get what you want there.  There is a primary address key in tarCustomer (PrimaryAddrKey) but you'd have to write your own extraction to get it (it's easy if you have SQL experience).