Salesman Target Report
From UG
(Difference between revisions)
(→Preliminary Design: Summary) |
(→Template) |
||
| Line 19: | Line 19: | ||
=== Template === | === Template === | ||
| + | * On the report template are filters to configure the report generation. See [[#Figure 1. Monthly 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: | ||
| + | *** ''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" dropdown what contains 12 months' names, "Year" dropdown with values from 2010 to current year. | ||
| + | **** <span style="color:#008000">By default:</span> "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. | ||
| + | **** <span style="color:#008000">By default:</span> "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" <span style="color:#008000">(default)</span> 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. <span style="color:#008000">By default</span> 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 === | === Output === | ||
Revision as of 17:32, 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
- Monthly Target Report is available from Main Menu on the next path ("Acc -> Reports -> Monthly 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. Monthly Target Report Menu
Figure 1. Monthly Target Report Template
History
m2059
- [2059]
BA
- Need ability to generate reports per individual salesman see Salesman_Target_Report#Business_Needs_.26_Requirements
