{"id":215,"date":"2010-04-01T13:08:00","date_gmt":"2010-04-01T13:08:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=215"},"modified":"2010-04-01T13:08:00","modified_gmt":"2010-04-01T13:08:00","slug":"use-fiscal-year-date-periods-for-reporting-purpose-in-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/","title":{"rendered":"Use Fiscal Year Date periods for Reporting purpose in CRM"},"content":{"rendered":"

Modern business era requires involvement of lots of calculations with annual financial statements as well as the resources to outcome values over some predefined periods in year. This is where Fiscal year comes into picture and reporting based on fiscal year periods is one of the best ways to understand the business.<\/p>\n

In this post an example used for entire explanation will be a report \u201cOpportunities Created<\/strong>\u201d in which we can list out all the opportunities based on there Created Date<\/strong>. Here we will try to drill down the report based on fiscal periods.
<\/strong>
Can I generate such report in standard Sage CRM?<\/strong><\/p>\n

Yes, it is pretty much doable task. We just need to remember our fiscal periods i.e. the Start Date and End Date of each fiscal period in a year. Let\u2019s consider in above example we are using \u201cCreated Date\u201d for \u201cOpportunity\u201d. We can put this field in Report Search Criteria and enter the date range of our fiscal period to get the report based on that particular fiscal period of year. We will get all the opportunities created within the provided date range. Well, the main hitch in this functionality is that, though most of the business minds still run on fiscal periods; they don\u2019t bother to remember the fiscal period date ranges.
<\/strong>
How can I make it more simplified?<\/strong><\/p>\n

We have designed an out of box functionality in order to achieve this in CRM. The functionality involves below mentioned two modules.
<\/strong>
1. Create New Fiscal Years :<\/strong><\/p>\n

i). You just need to enter the fiscal period, Start Date and End Date values for that period in an excel sheet and run an executable to create fiscal periods in CRM.<\/p>\n

<\/p>\n

\"\"
ii). Above action creates a lookup family in CRM for all the fiscal periods which can be then referenced in any selection field as well as the multiselect fields as per CRM functionality.<\/p>\n

iii). Code for each caption values will be formed based on logic in date ranges.<\/p>\n

2. Store fiscal period equivalent dates:<\/strong>
<\/strong>
This involves following set of actions (consider the example mentioned above). <\/p>\n

i). Create the field to store fiscal year equivalent value of date field. We will create a Selection field named \u201cCreated Date (FY)\u201d under \u201cOpportunity\u201d and attach the above created Fiscal year lookup family with it to see the options as shown below.<\/p>\n

\"\"<\/a>
ii). Logic can be written in Table level script or SQL trigger in order to update the value in this field based on actual \u201cCreated Date\u201d field value. So if Created Date falls in the date range of fiscal period 06<\/strong> of year 2009<\/strong>, then the Created Date (FY) will be set to FY09-06<\/strong>.<\/p>\n

iii). Now we can place this fiscal period equivalent date on our Report Search Criteria and then we will be able to select single as well as multiple fiscal periods in order to generate the report.<\/p>\n

\"\"<\/a>
Note<\/strong>: – For the CRM systems that are already being in action over the time, old data updation in order to update the fiscal year date values is also a necessary task. We have also designed an executable which does the same.<\/p>\n

If you find this content useful, Please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

Modern business era requires involvement of lots of calculations with annual financial statements as well as the resources to outcome values over some predefined periods in year. This is where Fiscal year comes into picture and reporting based on fiscal year periods is one of the best ways to understand the business. In this post\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1159,1708,1920],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-fiscal-year","tag-opportunity","tag-report"],"yoast_head":"\nUse Fiscal Year Date periods for Reporting purpose in CRM - 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\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use Fiscal Year Date periods for Reporting purpose in CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Modern business era requires involvement of lots of calculations with annual financial statements as well as the resources to outcome values over some predefined periods in year. This is where Fiscal year comes into picture and reporting based on fiscal year periods is one of the best ways to understand the business. In this post\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-04-01T13:08:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.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\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/\",\"name\":\"Use Fiscal Year Date periods for Reporting purpose in CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.JPG\",\"datePublished\":\"2010-04-01T13:08:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#primaryimage\",\"url\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.JPG\",\"contentUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use Fiscal Year Date periods for Reporting purpose in CRM\"}]},{\"@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":"Use Fiscal Year Date periods for Reporting purpose in CRM - 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\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/","og_locale":"en_US","og_type":"article","og_title":"Use Fiscal Year Date periods for Reporting purpose in CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Modern business era requires involvement of lots of calculations with annual financial statements as well as the resources to outcome values over some predefined periods in year. This is where Fiscal year comes into picture and reporting based on fiscal year periods is one of the best ways to understand the business. In this post\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-04-01T13:08:00+00:00","og_image":[{"url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.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\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/","name":"Use Fiscal Year Date periods for Reporting purpose in CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.JPG","datePublished":"2010-04-01T13:08:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#primaryimage","url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.JPG","contentUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/S7SdoUfRpII\/AAAAAAAAA_g\/orIvnPRA7QI\/s320\/FY1.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/04\/01\/use-fiscal-year-date-periods-for-reporting-purpose-in-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Use Fiscal Year Date periods for Reporting purpose in CRM"}]},{"@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\/215","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=215"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}