{"id":4694,"date":"2017-03-09T18:56:07","date_gmt":"2017-03-09T13:26:07","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=4694"},"modified":"2017-03-09T18:56:07","modified_gmt":"2017-03-09T13:26:07","slug":"copy-actualclosedate-and-actualrevenue-when-migrating-opportunity-in-microsoft-dynamics-365crm","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2017\/03\/copy-actualclosedate-and-actualrevenue-when-migrating-opportunity-in-microsoft-dynamics-365crm\/","title":{"rendered":"Copy ActualCloseDate and ActualRevenue when Migrating Opportunity in Microsoft Dynamics 365\/CRM"},"content":{"rendered":"

Introduction: <\/strong><\/p>\n

While migrating data for Opportunities, Quote and Order entities, the actualrevenue, actualclosedate, fulfilled date and closeddate are some of the fields that do not get mapped.<\/p>\n

Traditionally these fields are updated when the respective transactions are closed and the associated OpportunityClose, QuoteClose activity type records are associated at the time of closing these transactions.<\/p>\n

Most often during data migrations we do a field mapping but even mapping the data to the above fields did not really work. The only solution had been to add custom fields and copy that data over there as this is important information that is required for reporting. Though this solution brought in the data, it was never well received by the customers as the reporting was always done on the OOB fields and not the custom fields where the data had been migrated. So reporting on historical data was always an issue.<\/p>\n

Solution:<\/strong><\/p>\n

SSIS Toolkit<\/a> from our friends at KingswaySoft has always been our preferred tool for data migration and in the latest release the team has worked on finally resolving this problem for us.<\/p>\n

You now find additional fields related to opportunityclose actually listed on the opportunity data migration entity.<\/p>\n

\"1\"<\/a>

Click on the image to view in full resolution<\/p><\/div>\n

Mapping these fields ensures that the data actually moves over correctly with the actualclosedate and actualrevenue being correctly set as in the historical data without the need to add any custom fields.<\/p>\n

Let us see how it works:<\/strong><\/p>\n

We are migrating Opportunity entity data and here \u2018Actual Close Date\u2019 and \u2018Actual Revenue\u2019 should be mapped.<\/p>\n

Opportunity from Source CRM:<\/p>\n

\"\"<\/a>

Click on the image to view in full resolution<\/p><\/div>\n

So, we have mapped \u201cactualclosedate\u201d and \u201cactualvalue\u201d fields from source CRM with the \u201copportunityclose_actualend\u201d and \u201copportunityclose_actualvalue\u201d respectively in the destination CRM editor as seen in the screenshot below;<\/p>\n

\"3\"<\/a>

Click on the image to view in full resolution<\/p><\/div>\n

As you can see in the screenshot, the migrated Opportunity record has the \u201cActual Revenue\u201d and the \u201cActual Close Date\u201d mapped.<\/p>\n

 <\/p>\n

Opportunity in destination CRM:<\/p>\n

\"\"<\/a>

Click on the image to view in full resolution<\/p><\/div>\n

Also, the Opportunity Close activity created has the \u201cActual Revenue\u201d and \u201cClosed Date\u201d mapped as well.<\/p>\n

\"\"<\/a>

Click on the image to view in full resolution<\/p><\/div>\n

Similarly, you would be able to see the fields for Quote Close while mapping Quote entity and Order Close while mapping Order entity in Dynamics CRM Destination Editor.<\/p>\n

\"6\"<\/a>

Click on the image to view in full resolution<\/p><\/div>\n

\"7\"<\/a>

Click on the image to view in full resolution<\/p><\/div>\n

Conclusion<\/strong>: If you are migrating data to Dynamics CRM 2016 and onwards using KingswaySoft SSIS toolkit for Dynamics CRM, then you can map the Opportunity Close, Order Close and Quote Close entity fields while the creation of Opportunity, Order and Quote records.<\/p>\n

Export and Email your Dynamics 365\/CRM reports in PDF, Word or Excel format in a single click with Click2Export!<\/a><\/span><\/em><\/strong><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Introduction: While migrating data for Opportunities, Quote and Order entities, the actualrevenue, actualclosedate, fulfilled date and closeddate are some of the fields that do not get mapped. Traditionally these fields are updated when the respective transactions are closed and the associated OpportunityClose, QuoteClose activity type records are associated at the time of closing these transactions.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":4755,"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":[57],"tags":[99,1177,1179],"class_list":["post-4694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ssis","tag-actual-close-date-and-actual-revenue","tag-migrating-data-dynamics-crm","tag-migrating-opportunity-in-microsoft-dynamics-365crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/4694","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=4694"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/4694\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/4755"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=4694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=4694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=4694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}