Commission Report part and profit based

Is there a way to set up a commission report that is part based (only on new parts for a limited time) and margin based? We are looking to pay commission only on new parts and only on parts that has a ACTUAL profit of the a certain %. Also taking into account if payment is paid within a certain time of the due date. Has anyone had any success with setting this up for E10? We are in the process of upgrading and looking to change our commission structure at the same time.

If this is not something you have been able to do, do you have any other suggestions for commission structures that work well with E10 that encourage profits, sales and collectability?

I know this could be done with a dashboard, but not sure it can be accomplished properly with the CommissionAmt1-5 fields…