Salesman Target Report

From UG

Contents 1 General Info 2 Business Needs & Requirements 3 Preliminary Design 3.1 Summary 3.2 Template 3.3 Output 4 Figures 4.1 Figure 0. Salesman Target Report Menu Item 4.2 Figure 1. Salesman Target Report Template 5 History 5.1 m2059 5.2 BA 5.2.1 SA

General Info

• See Salesman
• Parent Mantis: [2060]

Business Needs & Requirements

• Need new report for individual salesman. This report would be based upon the Salesman#Salesman_Monthly_Target against the Salesman#Salesman_Monthly_Actual.

• Use Bar charts or graphs for nice visualization

Preliminary Design

Summary

• Salesman Target Report is available from Main Menu on the next path ("Acc -> Reports -> Salesman Target Report"). See on Figure 0.
• Report should be contain list of set Monthly Target and calculated Monthly Actual values. These amounts are displayed for individual Sales Person as described in #Business Requirements during specific time frame.

Template

• On the report template are filters to configure the report generation. See Figure 1. These fields:
  • Time Frame - Range of the report's time frame. It is set by two filters - "From" and "To" and can be of two types:
    • Month and Year (default) - "Time Frame" is defined by two pairs "Month-Year" values of "From" and "To" filters. They are displayed on the template as two pairs of dropdown lists:
      • "Month" dropdown what contains 12 months' names, "Year" dropdown with values from 2010 to current year.
      • By default: "From" pair set to first month of current year, "To" pair set to current month of current year.
    • Date Range - Range of the report's time frame is defined by two standard dateboxes, each of which corresponds to its filter.
      • By default: "From" datebox set to first day of current year, "To" datebox set to today.
  • Currency - the currency in which should be displayed the monthly target (actual) values. It would depend upon the country in which the salesman is physically located.
    • It can take two values: "by Office" (default) and "USD". In default case the monthly target/actual amounts should be shown in the currency what is set as default for Salesman's office. Otherwise, all amounts should be recalculated to USD.
  • Sales Persons - dropdown list which corresponds to the list of Jaguar Users who are Sales Persons. By default is blank.
• Every filter is connected by AND and sub selections inside each filter combo-box are connected by OR.
• If a filter is not set, that means "all". For example, if Sales Persons filter is blank, then report will include all Sales Persons info.
• There are two buttons on the template of the report:
  • Reset Form - when click on this button, then all filters should be set to the default values.
  • Generate Result - when click on this button, then the report is generated in accordance with the filters.

Output

Figures

Figure 0. Salesman Target Report Menu Item

Figure 1. Salesman Target Report Template

History

m2059

• [2059]

BA

• Need ability to generate reports per individual salesman see Salesman_Target_Report#Business_Needs_.26_Requirements

SA

see #Preliminary Design