The commission levels types are Standard, Quantity, and Seasonal.
Standard is the normal percentage paid by day of the week throughout the year, unless there is a another type.
Quantity is based on the first xx number of sales will be paid a specific percentage by based on the day of the week.
Seasonal is based on specific start and end dates.
An account can have one or many of these active at once. The priority order is below.
Quantity
Seasonal
Standard
There can be more than one "Active" Seasonal commission plan as long as the dates do not cross one another. However, there should be only one active Quantity or Standard at any one time.
Any suggestions on how to structure the custom object(s) to support the scenario above?
I appreciate your help.
3 respuestas
