{"id":4165,"date":"2022-01-06T05:17:46","date_gmt":"2022-01-06T05:17:46","guid":{"rendered":"https:\/\/himbap.com\/blog\/?p=4165"},"modified":"2022-01-06T12:40:58","modified_gmt":"2022-01-06T12:40:58","slug":"timezone-conversion-issue-in-crm-to-nav-integration","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=4165","title":{"rendered":"Timezone conversion Issue in CRM to BC integration"},"content":{"rendered":"<p><strong>Issue<\/strong><br \/>\nRecently we faced date issue while sending invoice data from Dynamics 365 to Business Central.<\/p>\n<p><strong>Details<\/strong><br \/>\nWe have implemented Dynamics 365 and Business Central integration using KingswaySoft toolkit. While testing invoice details created in Business central, we found issue with the date, it was one day behind the CRM date sent to BC. Earlier same SSIS packages with Azure Data Factor and it was working file without any date issue but when we moved these packages to Azure VM, this issue started.<\/p>\n<p>In CRM, date time behavior is User Local<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissuedate.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4257 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissuedate-300x72.png\" alt=\"timezoneissuedate\" width=\"300\" height=\"72\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissuedate-300x72.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissuedate-1024x244.png 1024w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissuedate-624x149.png 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissuedate.png 1027w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>While troubleshooting we tried different option but finally we solved this issue using Time Zone Conversion component from KingswaySoft<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissue1.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4253 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissue1-300x180.jpg\" alt=\"timezoneissue1\" width=\"300\" height=\"180\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissue1-300x180.jpg 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissue1-624x375.jpg 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2022\/01\/timezoneissue1.jpg 695w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>In this dialog under <strong>Input Columns<\/strong> we selected our date field. As this integration was done for the European region so we converted time zone from <strong>UTC<\/strong> to <strong>UTC+01:00<\/strong>.<\/p>\n<p>After these changes date started moving correctly to BC!<\/p>\n<p>So in case you are facing same issue, use Time Zone Conversion component to solve it.<\/p>\n<p>Hope it will help someone !!<br \/>\n<strong>Keep learning and Keep Sharing !! <\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Issue Recently we faced date issue while sending invoice data from Dynamics 365 to Business Central. Details We have implemented Dynamics 365 and Business Central integration using KingswaySoft toolkit. While testing invoice details created in Business central, we found issue with the date, it was one day behind the CRM date sent to BC. Earlier same SSIS packages with Azure&#8230; <a href=\"https:\/\/himbap.com\/blog\/?p=4165\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":4253,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[847,21,402,882],"tags":[941,942,940,943,944],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4165"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4165"}],"version-history":[{"count":7,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4165\/revisions"}],"predecessor-version":[{"id":4267,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4165\/revisions\/4267"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/4253"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}