Tag Archives: Dynamics GP 2016

Top 3 Excel Functions for Microsoft Dynamics

No Comment Aug 17,2016 Business Intelligence, Microsoft Dynamics CRM, Microsoft Dynamics GP, Office 365, Partners, Uncategorized

Excel has been a key part of Microsoft Office and continues to be enhanced in Office 216, part of Microsoft Office 365 (Office 365 Consulting in Canada).  As a complement to Microsoft Dynamics, Office 365 and Excel 2016 not only provides additional functions and usability, but there are now dedicated mobile apps,  browser-based online versions as well as the traditional Office desktop workhorse apps for Mac and PC.

The following are a quick Top 3 Excel Functions for Microsoft Dynamics
1. Excel templates in Dynamics CRM and GP.

There are a number of great ‘canned’ reports within Dynamics GP and CRM.  Some of the more popular GP ‘canned’ reports include: Export Chart of Accounts, Sales Analysis, Purchasing Analysis and Inventory Analysis. New within Microsoft Dynamics CRM Online 2016, you can now create your own Excel templates and reports. This is an exciting new function within Microsoft Dynamics CRM Online 2016.  Excel templates can now be formatted and embedded within CRM and made available as a personal or system-wide template.  This means the full capabilities of Excel formatting, including Pivot Tables, Pivot Charts, conditional formatting or offline calculations that can’t be easily handled inside CRM, can now be created as templates and made available to all users.

CRM Dynamics Canada reports

2. Excel PowerPivot for advanced slicing and dicing.

This this free add-in within Excel, simply type into the search “Power Pivot”, Excel will point you to the data analysis add-in called Power Pivot.  Vlookup and Hlookup are good, but being able to use a graphical interface to create joins between multiple tables via Power Pivot makes the consolidation and analysis of information a breeze.  Within Excel 2016, Power Pivot has been expanded to include that ability to preview and filter (ETL) before extracting data from a view, instead of downloading the entire Dynamics View or SmartList. This is a great time saver when you are dealing with large data sets with, hundreds of thousands or millions, of rows of transactional data. We recommend that you get some help from an expert (Endeavour Microsoft Dynamics Consultants) to build and create the custom connections to views or database tables in Dynamics CRM or Dynamics GP before performing your slicing and dicing.  Be sure to periodically reconcile a simple PowerPivot report against your current reporting system to confirm that you are capturing each of the right tables and transactions.

PowerPivot for Microsoft Dynamics

3. Creating budgets within Excel and re-importing them back into Dynamics GP.

Under the Financial Card in Dynamics GP, you can use the ‘Budget Wizard for Excel” to create GP friendly budgets that can be re-imported into GP for actual vs. budget comparisons.  To help kick-start your budgeting process, you can export an Excel budget template with starting data from Microsoft Dynamics GP based on:

  • A percentage change +or- from the open year, or
  • A percentage change +or- from a previous year, or
  • A percentage change +or- from a previous budget, or
  • A blank Excel budget template that you can populate from scratch before re-importing back into Dynamics GP.

Budget template for Dynamics GP

 

For more sophisticated budgeting and forecasts, you may also want to consider Endeavour Solutions’ approved Dynamics ISV partner, Prophix for automated budgeting workflows in support of a collaborative approach to setting budgets and forecasts.  With their new cloud-based options, Prophix is now more affordable for Microsoft Dynamics users in the mid-market. See Endeavour’s dedicated Prophix page at www.endeavoursolutions.ca/Prophix

 

About Endeavour Solutions Inc.

Endeavour Solutions is a Microsoft Gold ERP and Microsoft Silver CRM Partner focusing on development, implementation, upgrades, support and training for Dynamics GP, Dynamics CRM. and Office 365. With offices in Toronto, Halifax, London, Montréal and Edmonton we have more than 400 active clients in every province in Canada. In 2016, Endeavour was named to the Microsoft President’s Club – The top 5% of Microsoft Partners Worldwide.  See our Innovative projects @ www.endeavoursolutions.ca/dynamicsprojects

 

Read More

New Microsoft Dynamics GP 2016 released May 2016

No Comment May 4,2016 Microsoft Dynamics GP, Office 365, Uncategorized

New Microsoft Dynamics GP 2016 released May 2016

https://mbs.microsoft.com/customersource/northamerica/GP/downloads/product-releases/MDGP2016_Release_Download

Dynamics-2016-LogoWe recommend GP 2016 for new clients and new installs.  For existing clients and upgrades, we suggest that you hold off on upgrading till mid summer so that any ISV or add-in products can also be upgraded.   Also worth nothing, as of the release date, Microsoft Dynamics GP 2016 does NOT support Microsoft Office 2010.

We suggest you consider upgrading to Office 365, which includes Office 2016.  see Endeavour365.ca/overview for more info.

On a side note, Dynamics GP 2016 will also be referred to as Dynamics GP 2016 R1, as Microsoft Dynamics GP 2016 R2 may be released in the fall/winter of 2016.  Some past articles may have referenced Microsoft Dynamics GP 2015 R3, which was renamed to Microsoft Dynamics GP 2016.

Read More

Dynamics GP 2016 Upgrade Toronto, Halifax, Montreal, London, Edmonton

No Comment Apr 8,2016 Microsoft Dynamics GP, Uncategorized

Dynamics GP 2016 Upgrade Toronto, Halifax, Montreal, London, Edmonton

May 2016 – Update GP 2016 has been released.  See Microsoft Dynamics GP on CUSTOMER SOURCE

The Microsoft Dynamics consulting team at Endeavour Solutions is very excited with the new release of Microsoft Dynamics GP 2016 this spring.  The general consensus is that it will be in May 2016, but Microsoft is already releasing content, tips, training, blog etc. to Microsoft Dynamics GP partners such as Endeavour, to assist clients with their upgrade projects.  In the materials released thus far, there are a number of exciting functions which our team will review and announce shortly after the launch.  From an upgrade perspective, see past posts on Dynamics GP upgrade preparation and system requirements that you should be aware of, and of which our consultants will advise you on.  Contact Endeavour to start your plans Don’t have a Microsoft partner? or Need a new one? Visit

As a sneak peek, three of the new GP 2016 functions are:

  1. HTML5 – Full functioning web front-end that works and resizes in any modern browser on TABLETS, PC and MAC – Chrome, Edge, Firefox, Safari and Internet Explorer.  This aligns nicely with Microsoft’s mantra of “Cloud-first, Mobile-first” evolution for business applications.
  2. The new GP 2016 web client will have a useful function called “search open windows” to find layered windows open within the browser.
  3. All-In-One document viewers will help create a centralized dashboard for users.  With the viewer you can view ‘quantity-in’ and ‘quantity-out’ transactions for one item in one window.  Handy for transactions such as inventory management.

Microsoft Dynamics GP 2016 roadmap

Read More
1 2

Microsoft Cloud Migration

Deciding to leave Dynamics GP is bittersweet. Our team at GP Support North will miss you, however, our Business Central migration and support team at Endeavour Solutions is eager to help you succeed.