Commissions Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Hard coded conditions)
Line 23: Line 23:
=== Hard coded conditions ===
=== Hard coded conditions ===
 +
 +
[[CT#Created On Date]] must be a later or same date as [[Client_Companies_(component)#Sales_Person_Start_Day]]
=== User defined conditions ===
=== User defined conditions ===

Revision as of 22:47, 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?
    • No
  • Customer Start Date - need details.
    • answered
  • Sales person - single select?
    • multi
  • More filters?
    • no
  • If Sales = 0 do we need to list that Client on the report?
    • yes

Solution

Hard coded conditions

CT#Created On Date must be a later or same date as Client_Companies_(component)#Sales_Person_Start_Day

User defined conditions

Output

Related Client Profile functionality

See Client_Companies_(component)#Commissions_functionality

Figures

Figure 1

File:Commissions Report filters.JPG


Figure 2

File:Commissions Report xls.JPG

Personal tools