Home Screen: Difference between revisions

From Accelerator for SageCRM
No edit summary
No edit summary
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
Clicking the Home icon will bring you to the dashboard screen.  
Clicking the Home icon will bring you to the dashboard screen.  


This by default containers
This by default contains


1. An activity graph
1. An activity graph
2. Opportunity pipeline
2. Opportunity pipeline
3. Cases pipeline
3. Cases pipeline


Line 12: Line 14:


*Activity graph
*Activity graph
This is a graph showing your activity in CRM for the last 365 days. This uses communications created, opportunities and cases created by the user.  
This is a graph showing your activity in CRM for the last 365 days. This uses communications created, opportunities, and cases created by the user and scores them points (communications get 1 point and cases and opportunities get 10) to show how active you have been on CRM in these areas.  


*Opportunity pipeline
*Opportunity pipeline
This matches your pipeline that you have in CRM itself.
This matches the pipeline that you have in CRM itself.
You are presented with a graph and you click the button to view the list of opportunities
You are presented with a graph and you click the button to view the list of opportunities


Line 21: Line 23:


*Cases pipeline
*Cases pipeline
This matches your pipeline that you have in CRM itself.
This matches the pipeline that you have in CRM itself.
You are presented with a graph and you click the button to view the list of cases
You are presented with a graph and you click the button to view the list of cases


Line 28: Line 30:
**Customising
**Customising


You can add in a custom page to the dashboard so that it has its own tab.  
You can add a custom page to the dashboard so that it has its own tab.  


To do this create a new menu in
To do this create a new menu in
Line 40: Line 42:
[[File:home4.jpg]]
[[File:home4.jpg]]


Edit this then to add in a menu item.
Edit this to add in a menu item.
For example  
For example  


Line 51: Line 53:
*This is a sample file only
*This is a sample file only


The restart Outlook or reload the screen. Click Home and you will see the tab.  
Then restart Outlook or reload the screen. Click Home and you will see the tab.  


[[File:home6.jpg]]
[[File:home6.jpg]]


Technically
Technically the url is structured as
 
  https://crm.yourserver.com/CRM/CustomPages/sagecrmws/ac2020/sage300overview.asp?SID=584334583611&F=&J=sagecrmws%2Fac2020%2Fsage300overview.asp&app=ac2020
 
----
Example SQL for Sales Pipeline
 
  SELECT COUNT(*) AS Qry_Count, AVG(Capt_Order) AS Qry_Order, Oppo_Stage AS Qry_Stage,
  SUM((Oppo_Forecast/Curr_Rate) * 1.000000) AS Qry_SumForecast,
  SUM(((Oppo_Forecast/Curr_Rate) * 1.000000) * Oppo_Certainty)/ 100 AS Qry_WeightedForecast,
  SUM(Oppo_Certainty) AS Qry_SumCertainty
  FROM vListOpportunity LEFT JOIN Currency oppo_forecast_Currency ON Oppo_Forecast_CID = Curr_CurrencyID
  LEFT JOIN Custom_Captions ON Oppo_Stage = Capt_Code AND capt_familytype = N'choices'
  WHERE Oppo_AssignedUserId=1 AND oppo_status = N'In Progress'
  and ( Capt_Family = N'Oppo_Stage' OR Capt_Family IS NULL) and oppo_opportunityid in (65)
  GROUP BY Oppo_Stage
  ORDER BY 2 DESC
 
Example SQL for Cases Pipeline
 
  SELECT COUNT(*) AS Qry_Count, AVG(Capt_Order) AS Qry_Order, Case_Stage AS Qry_Stage
  FROM vListCases
  LEFT JOIN Custom_Captions ON Case_Stage = Capt_Code WHERE Case_AssignedUserId=1
  AND case_status = N'In Progress' AND (UPPER(RTRIM(Capt_Family)) = UPPER(RTRIM('Case_Stage'))
  OR Capt_Family IS NULL) and case_caseid in (45)
  GROUP BY Case_Stage
  ORDER BY 2 DESC

Revision as of 13:49, 24 March 2023

Clicking the Home icon will bring you to the dashboard screen.

This by default contains

1. An activity graph

2. Opportunity pipeline

3. Cases pipeline

Click on the tab to open it. Only one tab at a time can be open.

  • Activity graph

This is a graph showing your activity in CRM for the last 365 days. This uses communications created, opportunities, and cases created by the user and scores them points (communications get 1 point and cases and opportunities get 10) to show how active you have been on CRM in these areas.

  • Opportunity pipeline

This matches the pipeline that you have in CRM itself. You are presented with a graph and you click the button to view the list of opportunities

  • Cases pipeline

This matches the pipeline that you have in CRM itself. You are presented with a graph and you click the button to view the list of cases

    • Customising

You can add a custom page to the dashboard so that it has its own tab.

To do this create a new menu in

  Administration->Advanced Customisation->System Menus

called

 "acdashboard"

Edit this to add in a menu item. For example

 Caption: ERP
 Action: Customfile
 Custom File: sagecrmws/ac2020/sage300overview.asp*
  • This is a sample file only

Then restart Outlook or reload the screen. Click Home and you will see the tab.

Technically the url is structured as

 https://crm.yourserver.com/CRM/CustomPages/sagecrmws/ac2020/sage300overview.asp?SID=584334583611&F=&J=sagecrmws%2Fac2020%2Fsage300overview.asp&app=ac2020

Example SQL for Sales Pipeline

 SELECT COUNT(*) AS Qry_Count, AVG(Capt_Order) AS Qry_Order, Oppo_Stage AS Qry_Stage, 
 SUM((Oppo_Forecast/Curr_Rate) * 1.000000) AS Qry_SumForecast, 
 SUM(((Oppo_Forecast/Curr_Rate) * 1.000000) * Oppo_Certainty)/ 100 AS Qry_WeightedForecast, 
 SUM(Oppo_Certainty) AS Qry_SumCertainty 
 FROM vListOpportunity LEFT JOIN Currency oppo_forecast_Currency ON Oppo_Forecast_CID = Curr_CurrencyID 
 LEFT JOIN Custom_Captions ON Oppo_Stage = Capt_Code AND capt_familytype = N'choices'
 WHERE Oppo_AssignedUserId=1 AND oppo_status = N'In Progress' 
 and ( Capt_Family = N'Oppo_Stage' OR Capt_Family IS NULL) and oppo_opportunityid in (65)
 GROUP BY Oppo_Stage 
 ORDER BY 2 DESC

Example SQL for Cases Pipeline

 SELECT COUNT(*) AS Qry_Count, AVG(Capt_Order) AS Qry_Order, Case_Stage AS Qry_Stage 
 FROM vListCases 
 LEFT JOIN Custom_Captions ON Case_Stage = Capt_Code WHERE Case_AssignedUserId=1 
 AND case_status = N'In Progress' AND (UPPER(RTRIM(Capt_Family)) = UPPER(RTRIM('Case_Stage')) 
 OR Capt_Family IS NULL) and case_caseid in (45) 
 GROUP BY Case_Stage 
 ORDER BY 2 DESC