{"id":13040,"date":"2016-07-26T11:29:25","date_gmt":"2016-07-26T11:29:25","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=13040"},"modified":"2016-07-26T11:29:25","modified_gmt":"2016-07-26T11:29:25","slug":"open-cases-summary-report-to-managers","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/","title":{"rendered":"Open Cases Summary Report to Managers."},"content":{"rendered":"

In Sage CRM, a case entity is mostly used as a Customer service issue. We can capture a customer query in Sage CRM, and track the progress of the problem through to a Solution and closure.
\nCases may be assigned as High, Normal or Low priority in Sage CRM. They have a status as \u2018In Progress\u2019 and \u2018Closed\u2019. Every Organization has its own workflow or business process which takes place to move the case to its outcome.
\nNew Stuff:<\/strong><\/em>\u00a0<\/span>Providing additional Rights to a User within Security Profile<\/a>
\nA Customer case which is on high priority and has not been resolved on time will lead to Customer dissatisfaction. It helps to notify and escalate an issue to superior if not responded as per TAT.
\nSage CRM includes many system reports which allows us to gain insights into how business is doing and can be improved.
\nNow in this blog we are going to discuss about the custom application which we have developed to send email notifications. We have designed a tool which manages to notify Managers or Admin Users of Open Cases list in an email once in a week so that they can investigate why Case has been not resolved on time and help improve business and calculate the response time of an individual.
\nThis tool is designed using Sage CRM standard Web Service API and standard email settings SMTP configurations configured within Sage CRM application.
\nBelow are the detailed steps we followed,
\n1) Created an external application using standard Web Service API which reads Open Cases data and creates a dynamic list.
\n2) Email content and subject line is configured within Sage CRM.
\n3) Application uses internal SMTP configuration for sending email.
\n4) Application is scheduled in Windows task scheduler to notify Open Cases list on timely basis.
\nAs an example refer below screenshot of the email that was received by Manager with Case details.
\n\"CaseList\"<\/a>
\nThe email content added in the above screenshot is just a basic content; we can modify the content and subject line as per the requirement.
\nThis tool is designed in such a way that it can be configured in windows task scheduler for execution. We can set the time as per our requirement to schedule the email process. It can be set daily, weekly, monthly or yearly to execute email notification as per need.
\nAbout Us
\n<\/strong>Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
\nGreytrix<\/a>\u00a0has some unique integration solutions for Sage CRM with Sage ERP\u2019s (Sage X3<\/a>,\u00a0Sage 100<\/a>,\u00a0Sage 500<\/a>\u00a0and\u00a0Sage 300<\/a>). It also offers best-in-class\u00a0Sage ERP customization and development services<\/a>\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users and Sage PSG worldwide. Greytrix<\/a>\u00a0helps in\u00a0migrating to Sage CRM from ACT<\/a>,\u00a0Goldmine<\/a>\u00a0and other CRM\u2019s.
\nFor more information on our integration solutions, please contact us at\u00a0sage@greytrix.com<\/a>. We will be glad to assist you.
\nAlso Read:
\n<\/strong>1)\u00a0\u00a0<\/span><\/em>Bulk Reassignment of Cases within the teams<\/a>
\n2) D<\/a><\/span><\/span>isplay Image to notify number of Cases\/Opportunities\/Leads against Person\/Company
\n<\/a>3) Link the Cases (Created through Support Mails) to Case Workflow
\n<\/a>4) Globally scheduling the cases across users<\/a>
\n5)\u00a0Set Default Status Value for Communications and Cases<\/a>
\n\u00a0<\/a>
\n <\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage CRM, a case entity is mostly used as a Customer service issue. We can capture a customer query in Sage CRM, and track the progress of the problem through to a Solution and closure. Cases may be assigned as High, Normal or Low priority in Sage CRM. They have a status as \u2018In\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-13040","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nOpen Cases Summary Report to Managers. - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open Cases Summary Report to Managers. - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In Sage CRM, a case entity is mostly used as a Customer service issue. We can capture a customer query in Sage CRM, and track the progress of the problem through to a Solution and closure. Cases may be assigned as High, Normal or Low priority in Sage CRM. They have a status as \u2018In\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-26T11:29:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/\",\"name\":\"Open Cases Summary Report to Managers. - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg\",\"datePublished\":\"2016-07-26T11:29:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Open Cases Summary Report to Managers.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Open Cases Summary Report to Managers. - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/","og_locale":"en_US","og_type":"article","og_title":"Open Cases Summary Report to Managers. - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In Sage CRM, a case entity is mostly used as a Customer service issue. We can capture a customer query in Sage CRM, and track the progress of the problem through to a Solution and closure. Cases may be assigned as High, Normal or Low priority in Sage CRM. They have a status as \u2018In\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-07-26T11:29:25+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/","name":"Open Cases Summary Report to Managers. - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg","datePublished":"2016-07-26T11:29:25+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/07\/CaseList.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/07\/26\/open-cases-summary-report-to-managers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Open Cases Summary Report to Managers."}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=13040"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13040\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=13040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=13040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=13040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}