{"id":99872,"date":"2022-05-11T15:03:35","date_gmt":"2022-05-11T13:03:35","guid":{"rendered":"https:\/\/www.jedox.com\/?p=99872"},"modified":"2026-03-08T18:50:30","modified_gmt":"2026-03-08T17:50:30","slug":"planning-with-microsoft-dynamics-365","status":"publish","type":"post","link":"https:\/\/www.jedox.com\/en\/blog\/planning-with-microsoft-dynamics-365\/","title":{"rendered":"Planning with Microsoft Dynamics 365"},"content":{"rendered":"<p><strong>Plans, budgets, and forecasts built collaboratively across the enterprise were historically elusive for companies with various technologies and software assembled over years, if not decades. Business systems like Customer Relationship Management (CRMs) don\u2019t talk to Enterprise Resource Planning (ERPs) or Human Capital Management (HCM) which don\u2019t talk to FP&amp;A software, or tax software, or procurement systems.<\/strong><\/p>\n<p>Over the past two decades, Microsoft attempted to solve this for global organizations by building upon their Office suite dominance to offer compelling finance and operations solutions assembled around Excel, PowerBI, and the Microsoft Dynamics CRM and ERP. However, planning, budgeting, and forecasting remained siloed and often dependent on manual consolidation of disconnected Excel worksheets to accomplish a yearly or quarterly planning process.<\/p>\n<p>This gap in a fully integrated Microsoft finance and operations technology stack is now in the process of closing. <a href=\"https:\/\/www.jedox.com\/en\/about\/newsroom\/jedox-partnership-microsoft\/\">Jedox\u2019s partnership with Microsoft<\/a> means that together, the two organizations can offer collaborative planning and performance at scale that fits neatly within the rest of the Microsoft ecosystem. We\u2019re proud that the investments Jedox made in honing technical connections to Microsoft, means it is the most logical <a href=\"https:\/\/www.jedox.com\/en\/financial-planning-analysis\/\">FP&amp;A software<\/a> platform for companies already invested in the Microsoft ecosystem or who are planning to migrate to a Microsoft environment.<\/p>\n<h2>How Jedox EPM builds upon a Microsoft Dynamics Finance and Operations data foundation<\/h2>\n<p><strong>The foundation of your business is data.<\/strong><\/p>\n<p>The seamless flow of data between business systems and people means your organization can act more decisively when new opportunities emerge. Iterative <a href=\"https:\/\/www.jedox.com\/en\/blog\/scenario-planning\/\">scenario planning<\/a>, augmented by advanced forecasting technologies like <a href=\"https:\/\/www.jedox.com\/en\/platform\/ai\/\">Jedox AIssisted\u2122 Planning<\/a>, or simply fed by internal drivers derived from your business systems, is predicated on accurate, always up-to-date data.<\/p>\n<p>How many business systems are you connecting? And, what are the methods of sharing data between systems today? Answers to these questions are critical factors in whether you can generate meaningful insight from your data.<\/p>\n<h3>Jedox makes secure, effective connections to the Microsoft Dataverse.<\/h3>\n<p>Jedox extracts valuable financial and operational data tables through a secure connection to Dynamics via Microsoft Dataverse. Dataverse\u202fstandardizes\u202fand\u202fsimplifies\u202ftables and relationships within the underlying data model and offers a clean layer to access this data. This allows Jedox model developers to build standard models that are common and consistent across all Dynamics users within an organization.<\/p>\n<p>OData\u202fis the secure connection protocol based on the RESTful API framework which provides the ability to maintain a single source of financial and operational data between Microsoft and Jedox systems. If this doesn\u2019t mean much to you, that\u2019s okay. At its core, Jedox connected to the Microsoft Dataverse means you will be able to collaborate between teams and generate meaningful insight from your data.<\/p>\n<h3>Real-world use case: A\u00a0global textile company improved strategic operational planning<\/h3>\n<ul class=\"check\">\n<li>Leveraged historical sales and operational transactions and operational data housed within Microsoft Dynamics 365 Finance to feed forward-looking planning scenarios<\/li>\n<li>Used Jedox AIssisted\u2122 Planning predictive models applied to historical time-series data to understand retail demand<\/li>\n<li>Married <a href=\"https:\/\/www.jedox.com\/en\/blog\/top-down-bottom-up-planning\/\">top-down and bottom-up<\/a> analysis by engaging stakeholders across 30 companies to contribute to ongoing planning processes.<\/li>\n<\/ul>\n<h2>How Jedox encourages collaboration in planning through Excel worksheets<\/h2>\n<p>Companies that crowdsource information throughout an organization <a href=\"https:\/\/www.washingtonpost.com\/opinions\/david-ignatius-more-chatter-than-needed\/2013\/11\/01\/1194a984-425a-11e3-a624-41d661b0bb78_story.html\" target=\"_blank\" rel=\"noopener\">make 30% better decisions<\/a>. Jedox creates the planning layer within the Microsoft ecosystem, and those plans, budgets and forecasts must incorporate feedback and data from people across the organization. Lowering the barriers to contributing to planning is paramount for effective planning.<\/p>\n<p>The <a href=\"https:\/\/appsource.microsoft.com\/en-us\/product\/office\/wa104381848?tab=overview\" target=\"_blank\" rel=\"noopener\">Jedox Online Add-in<\/a> provides you and the rest of your company\u2019s planners with access to the Jedox platform from within a familiar Excel application (Windows, Mac, or Browser). You can modify, plan, or budget your data with writeback capabilities and access updated information at any time. Maybe most importantly, the add-in allows contributors to your planning process to send data through the familiar Excel interface lessening the risk for bad data entering your models.<\/p>\n<h2>How Jedox feeds insight data to PowerBI so companies can act decisively<\/h2>\n<p>While Jedox provides comprehensive visualization, dashboarding, and reporting capabilities, many organizations live in PowerBI for their business intelligence needs. Through a turnkey connector, Jedox automatically keeps the PowerBI environment up to date with planning, budgeting, and forecasting data. In fact, people who use Microsoft\u2019s business intelligence offering can also writeback updates to Jedox through PowerBI if need be.<\/p>\n<h2>Make fewer technical connections to lower operational and collaborative planning adoption risk<\/h2>\n<p>Ultimately, whether it makes it easier for business users across the enterprise to collaborate in planning and forecasting activities because they can operate with a familiar Excel environment, or you increase IT resource capacity by maintaining automatic data-synchronization with Jedox, <a href=\"https:\/\/www.jedox.com\/en\/system\/microsoft-dynamics-365-finance\/\">Dynamics 365 Finance<\/a> and <a href=\"https:\/\/www.jedox.com\/en\/system\/power-bi\/\">PowerBI<\/a>, Jedox takes the approach of \u201cplaying nicely\u201d with the Microsoft ecosystem. Ultimately, the combination of Jedox and Microsoft means organizations can optimize their technology investments by purchasing complementary, not redundant or overlapping, software systems.<\/p>\n<p>From the first remote data collection of planning data via Excel, to generating management reports, to everything in-between, Jedox and Microsoft will power your business for decades to come.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plans, budgets, and forecasts built collaboratively across the enterprise were historically elusive for companies with various technologies and software assembled over years, if not decades. Business systems like Customer Relationship Management (CRMs) don\u2019t talk to Enterprise Resource Planning (ERPs) or Human Capital Management (HCM) which don\u2019t talk to FP&#038;A software, or tax software, or procurement systems.<\/p>\n","protected":false},"author":68,"featured_media":99882,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11471],"tags":[23202],"class_list":["post-99872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-jedox-updates","tag-ibp"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/posts\/99872","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/users\/68"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/comments?post=99872"}],"version-history":[{"count":1,"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/posts\/99872\/revisions"}],"predecessor-version":[{"id":171234,"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/posts\/99872\/revisions\/171234"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/media\/99882"}],"wp:attachment":[{"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/media?parent=99872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/categories?post=99872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jedox.com\/en\/wp-json\/wp\/v2\/tags?post=99872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}