Commissions Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:AccReps == Gen == == Needs and Requirements == ''' Commissions Report ''' is required by Acc Dept. Purpose of the report is to calculate commissions per Client …')
(Needs and Requirements)
Line 9: Line 9:
Purpose of the report is to calculate commissions per Client Company in USD for specific Sales Person during specific time frame.
Purpose of the report is to calculate commissions per Client Company in USD for specific Sales Person during specific time frame.
-
* Do we need  
+
* Do we need html version?
-
 
+
* Customer Start Date - need details...
 +
* Sales person - single select?
 +
* More filters?
 +
* If Sales = 0 do we need to list that Client on the report?
== Solution ==
== Solution ==

Revision as of 18:41, 1 April 2010


Contents

Gen

Needs and Requirements

Commissions Report is required by Acc Dept.

Purpose of the report is to calculate commissions per Client Company in USD for specific Sales Person during specific time frame.

  • Do we need html version?
  • Customer Start Date - need details...
  • Sales person - single select?
  • More filters?
  • If Sales = 0 do we need to list that Client on the report?

Solution

Hard coded conditions

User defined conditions

Output

Figures

Figure 1

File:Commissions Report filters.JPG


Figure 2

File:Commissions Report xls.JPG

Personal tools