Home Screen: Difference between revisions

From Accelerator for SageCRM
No edit summary
No edit summary
(3 intermediate revisions by the same user not shown)
Line 14: 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
Line 60: Line 60:


   https://crm.yourserver.com/CRM/CustomPages/sagecrmws/ac2020/sage300overview.asp?SID=584334583611&F=&J=sagecrmws%2Fac2020%2Fsage300overview.asp&app=ac2020
   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