{"id":24307,"date":"2020-08-04T13:38:42","date_gmt":"2020-08-04T13:38:42","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=24307"},"modified":"2020-08-04T13:38:42","modified_gmt":"2020-08-04T13:38:42","slug":"how-to-do-sales-forecast-projection-in-dynamics-365-crm-using-trend-charts-and-flow-snapshots","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-do-sales-forecast-projection-in-dynamics-365-crm-using-trend-charts-and-flow-snapshots\/","title":{"rendered":"How to do Sales Forecast Projection in Dynamics 365 CRM using Trend Charts and Flow Snapshots"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

In the previous article<\/a> , you saw that we only had the ability to create an org chart forecast and territory forecast. But now while exploring the \u2018Sales Forecast\u2019 feature\u00a0I noticed a new option named \u2018create from scratch\u2019. <\/strong><\/p>\n

In this extended blog, we will explore Sales Forecast experience through \u2018create from scratch\u2019.<\/strong><\/p>\n

Organizations always have a need to project the revenue generated from various partners through their customers for a given period of time. Now, as we know Account entity in Dynamics 365 CRM can be used for both Partners and Customers as well. So here, when we record the Customer as Account entity then we can set Partner in parent Account lookup field and hierarchy can be accomplished. And further this hierarchy can be used in forecasting feature using custom forecast.<\/p>\n

Also it has enabled the facility to select the \u2018Hierachy Entity\u2019 and this selection is not just restricted to User entity\u00a0 that we already experienced in the Org Chart type forecast. Here, we have selected Account entity in our case.<\/p>\n

Custom foreacast can be used in many scenarios, let us consider one scenario that I implemented. If my organization would like to foreacast or track the opportunities\u00a0 based on the Account selected on Opportunities then I can use custom foreacast by keeping \u2018Hierachy Entity\u2019 as Account.<\/p>\n

Forecast Configuration steps:<\/strong><\/p>\n

Navigate to Sales–> Forecasts–> If in Dynamics 365 CRM environment there are no forecast configured yet then below screen will appear:<\/p>\n

\"Sales<\/p>\n

In order to create a new forecast, you need to navigate to \u2018App Settings\u2019 in the Sales Hub and select \u2018Forecast Configurations\u2019.<\/p>\n

\"Sales<\/p>\n

Click on the \u2018Create from Scratch\u2019 option.<\/p>\n

\"Sales<\/p>\n

Start creating the custom Forecast as per requirement by entering the below details:<\/p>\n

\"Sales<\/p>\n

Note: Similar to other forecasts this forecast option also currently only supports Opportunity entity.\u00a0<\/em><\/strong><\/p>\n

In org chart, we have already seen that \u2018Hierarchy entity\u2019 field was non-editable and was default to user.<\/p>\n

In Custom forecast, there is additional option available to choose the entities. The entities that are available for selection until date are as below:<\/p>\n

\"Sales<\/p>\n

Here, Account entity is selected. From this, you can track Opportunities based on Account hierachy.<\/p>\n

Now, you need to define hierarchy route as shown below:<\/p>\n

\"Sales<\/p>\n

Next, select the entity as shown below:<\/p>\n

\"Sales<\/p>\n

For demonstration, the Account entity that I selected is set at the top of the hierarchy using the Parent Account lookup on the Account entity. The entire hierarchy of Accounts is auto selected as shown in below screenshot:<\/p>\n

\"Sales<\/p>\n

Now complete the further steps like Permissions, Layout, Activate and add quotas same as explained in previous article<\/a>.<\/p>\n

The forecast record would be added as shown below:<\/p>\n

\"Sales<\/p>\n

Once you have completed with this configuration, navigate to Sales –> Forecasts–> here you will see the Grid tab as shown below:<\/p>\n

\"Sales<\/p>\n

Trend and Flow visualization:<\/strong><\/p>\n

Note: You will not be able to see Trend and Flow tab enabled directly. For this, you must turn on Sales Insights capabilities as suggested below:<\/em><\/p>\n

\"Sales<\/p>\n

When you click on \u2018Learn more\u2019, you will be navigated to below page where you have to click on \u2018I Agree\u2019 button.<\/p>\n

\"Sales<\/p>\n

After that, click on \u2018Start Trial\u2019 button.<\/p>\n

\"Sales<\/p>\n

And wait for \u2018Sales Insights\u2019 configuration installation to complete. It will take few minutes to complete this installation. Once installed you will see the below screen:<\/p>\n

\"Sales<\/p>\n

You can now see that Trend tab and Flow tab are enabled.<\/p>\n

Next, navigate to Trend tab just beside the Grid tab.<\/p>\n

\"Sales<\/p>\n

Using the trend chart, you can view the summary of a forecast category at a given time by hovering over the trend line, as shown in below screenshot. You can refer this article<\/a> for more details.<\/p>\n

\"Sales<\/p>\n

Besides Trend tab there is the Flow tab which was showing the below message:<\/p>\n

\"Sales<\/p>\n

For this Flow tab to show the data, at least two snapshots should be present in the system. To know more about this, refer the given article<\/a>.<\/p>\n

On the forecast from which you want to create a snapshot, select the\u00a0\u2018More options\u2019\u00a0icon, and then select\u00a0Add\/view snapshots as shown below:<\/p>\n

\"Sales<\/p>\n

Click on Add Snapshot button.<\/p>\n

\"Sales<\/p>\n

Give name to Snapshot and click on Create button.<\/p>\n

\"Sales<\/p>\n

You can see the created snapshot in the Snapshot History window as shown below:<\/p>\n

\"Sales<\/p>\n

\"Sales<\/p>\n

Note:<\/strong> After adding first snapshot, I was not able to add the second one instantly as \u2018+ Add snapshot\u2019 button disappeared. After 24-hours the \u2018+ Add snapshot\u2019 reappeared. So, if you want \u2018+ Add snapshot\u2019 button to appear immediately then you can delete the snapshot taken as shown in the above warning message and then add the snapshot.<\/em><\/p>\n

Second snapshot created as shown below:<\/p>\n

\"Sales<\/p>\n

\"Sales<\/p>\n

Once these two snapshots are created in the system then when we navigate to Flow tab, it will show two snapshots. Now, choose a snapshot from\u00a0Snapshot 1<\/strong>\u00a0(named S1) and one from\u00a0Snapshot 2 <\/strong>(named S2) and then click on Run as shown below:<\/p>\n

\"Sales<\/p>\n

As shown in above screenshot, snapshot shows the stacks structure. You can refer the given article<\/a> for more details.<\/p>\n

Topmost stack shows summary of snapshot such as the aggregated opportunity amount and the number of opportunities that are influencing the aggregated opportunity amount.<\/p>\n

The other columns on stack displays the forecast categories and the aggregated opportunity amount.<\/p>\n

New Deals: <\/strong>If any underlying opportunities are added to the forecast after snapshot1 is taken then a \u2018new deals\u2019 forecast category will be added to the bottom of snapshot1 column stack with the name \u2018New Deals\u2019, as shown in below screenshot:<\/p>\n

\"Sales<\/p>\n

Slipped Deals<\/strong>: <\/strong>If any underlying opportunities are deleted from the forecast after snapshot2 is taken then a \u2018slipped deals\u2019 forecast category will be added to the bottom of snapshot2 column stack with the name \u2018Slipped Deals\u2019.<\/p>\n

As shown in below screenshot, when I deleted the opportunities and then took the latest snapshot (named S3) and compared it with the previous and latest screenshot, I could see a column named \u2018Slipped Deals\u2019 was added to the stack.<\/p>\n

\"Sales<\/p>\n

Conclusion<\/strong><\/h2>\n

Sales Forecasting is a great prediction tool which will be helpful for the companies to project revenue based on opportunities created by the sales team for a given period.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction In the previous article , you saw that we only had the ability to create an org chart forecast and territory forecast. But now while exploring the \u2018Sales Forecast\u2019 feature\u00a0I noticed a new option named \u2018create from scratch\u2019. In this extended blog, we will explore Sales Forecast experience through \u2018create from scratch\u2019. Organizations always\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":24337,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[18],"tags":[2060],"class_list":["post-24307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365-v9-2","tag-sales-forecast-projection"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/24307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=24307"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/24307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/24337"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=24307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=24307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=24307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}