Salesman Target Report
From UG
(Difference between revisions)
(→Template) |
m |
||
Line 15: | Line 15: | ||
=== Summary === | === Summary === | ||
- | * | + | * Salesman Target Report is available from Main Menu on the next path ("Acc -> Reports -> Salesman Target Report"). See on [[#Figure 0. Salesman Target Report Menu Item | Figure 0]]. |
* Report should be contain list of set [http://mantis.jaguarfreight.com/wiki/Salesman_Concepts#Salesman_Monthly_Target Monthly Target] and calculated [http://mantis.jaguarfreight.com/wiki/Salesman_Concepts#Salesman_Monthly_Actual Monthly Actual] values. These amounts are displayed for individual Sales Person as described in [[#Business Requirements]] during specific time frame. | * Report should be contain list of set [http://mantis.jaguarfreight.com/wiki/Salesman_Concepts#Salesman_Monthly_Target Monthly Target] and calculated [http://mantis.jaguarfreight.com/wiki/Salesman_Concepts#Salesman_Monthly_Actual Monthly Actual] values. These amounts are displayed for individual Sales Person as described in [[#Business Requirements]] during specific time frame. | ||
=== Template === | === Template === | ||
- | * On the report template are filters to configure the report generation. See [[#Figure 1. | + | * On the report template are filters to configure the report generation. See [[#Figure 1. Salesman Target Report Form (Template) | 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: | ** '''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'' <span style="color:#008000">(default)</span> - "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 and Year'' <span style="color:#008000">(default)</span> - "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: | ||
Line 38: | Line 38: | ||
== Figures == | == Figures == | ||
- | === Figure 0. | + | === Figure 0. Salesman Target Report Menu Item === |
[[File:Monthly report menu.gif]] | [[File:Monthly report menu.gif]] | ||
- | === Figure 1. | + | === Figure 1. Salesman Target Report Template === |
[[File:Monthly report template.gif]] | [[File:Monthly report template.gif]] | ||
Revision as of 19:04, 4 July 2010
Contents |
General Info
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.
- 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:
- 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.
- Time Frame - Range of the report's time frame. It is set by two filters - "From" and "To" and can be of two types:
- 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