Tag Archives: Office 365 Canada

News on the new Microsoft Dynamics GP 2018 new features

News on the new Microsoft Dynamics GP 2018 new features.

We’re trilled to be one of the first to provide a more in-depth overview on the new features within Microsoft Dynamics GP 2018 ERP.   With a scheduled release date of December 1, 2017, Microsoft Dynamics GP ERP has a great looking future with a detailed GP roadmap (Great Plains) and continual investments from Microsoft for this strong mid-market ERP system.  Since Dynamics GP is a mature application, you will see now, and into the future, more and more focus on User Experience and user requested functions, rather than major releases of new modules or other core functions and capabilities.  We believe that this is a “great thing to see” in an ERP, where stability, flexibility and scalability are important. Learn more about Endeavour Solutions for Microsoft Dynamics GP consulting and support in Canada and USA at GP Upgrade.

Top Microsoft Dynamics GP 2018 new features

Dynamics GP 2018 Additional User Requested Functions  Microsoft GP 2018 Screen Customer Statements

  • SmartList Favourites with unique password protection. Great for sharing as read-only.
  • Checks and Cheques have been renamed as Payments as seen in Payables Transaction windows. This reflects the common term for ETF vs Cheque.
  • Copy user access settings and security across AA dimension codes. Therefore saving time on setting up new users.
  • A variety of new Sort functions for the Receivables Transaction Inquiry window – by Type, document number, amount, amount remaining, document date, etc.
  • Ability to Print and Email a single statement from the customer card as seen to the right.
  • Ability to print Purchase Requisition.
  • User experience updates to the Dynamics GP web client including ‘type ahead auto-complete’. Great for cloud-hosted users.
  • Additional sorting options for Bank Reconciliations.  Therefore saving time in monthly bank rec.
  • Even greater integration and accelerators for Power BI with the new GP 2018 Power BI Content Pack. (coming soon)

Dynamics GP 2018 Workflow v 4.0

  • New workflow approvals for General Ledger Accounts and Purchase Invoice
    • Workflow now exists for almost all areas including batch approvals for Purchasing, Payroll, Project, Payables, Sales, System Security and Vendor management.
  • Ability to copy workflow steps and settings.
  • Additional fields for PO and Payables transaction workflow.
  • Reminder e-mails for Workflow to help keep approvals on task.

Dynamics GP 2018 Improved DocAttach (Document Attachment) Microsoft Dynamics Dynamics GP 2018 screen receivables attach

  • Add, View and Modify attachments on most master record windows, inquiry windows and transaction entry windows.
  • Document Attach icon is now shown within the Ribbon on most transaction and inquiry screens including:
    • GP Document Attachment on Receivables Entry
    • Document Attachment in General Ledger Entry
    • Document Attachment on Employee Inquiry
    • GP Display Vendor notes on Vendor Inquiry
    • Display Customer notes on Customer Inquiry
    • Project Notes screens in Project Inquiry and PA Project Inquiry
    • Document Attach in Asset General Information (FA) (Fixed Assets).

 

Endeavour Solutions has been working with Microsoft Dynamics GP Canada for over 28-years to advise and help progressive organizations improve their business processes, operational efficiency and overall performance by leveraging the power of Microsoft Dynamics GP ERP.  Underpinning each project is our belief that a strong ERP or CRM is only as good at the data within it. Based on this concept, our team at Endeavour strives to ask “why” and “how” to uncover the true processes and business insights that will help drive innovation within your business.  Meet our team www.endeavoursolutions.ca/about-us

Endeavour Solutions Canada is a Microsoft Gold ERP and Microsoft Silver Cloud & CRM Partner focusing on development, implementation, upgrades, support and training for Dynamics GP ERP and Dynamics 365 CRM as well as Office 365 and Microsoft Power BI.

Read More

Cheque printing in Dynamics GP Great Plains

The good, bad and ugly of GP Cheque printing

A member of our GP consulting team had the distinct pleasure of providing coverage for our finance department over the holidays. This included opening mail and performing some simple AR processes / bank deposits. While looking at client renewal cheques, she noticed much of the good, the bad and the ugly of GP Cheque printing, which later became a point of inspiration for this month’s newsletter. Let’s start with a fictitious sample, of a “bad cheque” based on a combination of real examples seen by our AR team.

Sample “Bad Cheque” (Dynamics GP check printing)

Sample of bad cheque in Dynamics GP - GP Cheque printing

The risk of “Bad Cheques”

  • Ugly, mis-aligned cheques are a poor representation of your company’s brand and attention to detail
  • Poor alignment creates an increased exposure to forgery and fraud (Example $__60.97 vs $9060.97)
  • Poor font choices (too small, too thin, too light), make it harder for your suppliers to automate their processes with cheque scanning

 

Sample “Good Cheque” (Dynamics GP Check printing)

Dynamcis GP Cheque printing

What makes a “Good Cheque”

  • Text is an appropriate size and aligns with each of the relevant headings
  • The dollar sign $ is close to the dollar value, and the verbose printed amount is left aligned to reduce fraud
  • Payee name is in ALL CAPS as required for Cheque scanning
  • Paper Cheque stock has built in security features to prevent forgery

 

For more information on these insights, or other questions related to Dynamics GP and Dynamics CRM, please contact the Endeavour support team. We would be happy to help you explore how Microsoft Dynamics can further help your business succeed.

www.endeavoursolutions.ca/support  (new clients welcome)

www.endeavoursolutions.ca/GPupgrade

 

Read More

Dynamics GP 2016 R2 to be released late 2016

Dynamics GP 2016 R2, unofficially announced this summer and further validated at the Microsoft Dynamics GP “ReIMAGINE” conference earlier this week (September 19 2016).

Microsoft Dynamics GP 2016 R2 will be released later this year.

The official date has not been set, but is slated for Q4 CY 2016 – End of calendar year 2016 in Canada and USA.  Given the announcement of the launch of Microsoft Dynamics 365 Business Financials and Dynamics NAV 2017 in Canada for early November 2016, it is presumed that Microsoft Dynamics GP 2016 R2 will most likely be late November or early December 2016.

This release will align well for clients considering Dynamics GP 2016 R2 upgrades in early 2017 after they’ve closed their period-end books (Year-end for some, Quarter-end for others).   Below is an unofficial photo of the Microsoft Dynamics GP 2016 / 2017 Roadmap along with other products within the Microsoft Dynamics Suite including Microsoft Dynamics CRM On-line.  We’re also told that Microsoft Dynamics GP 2017 should be expected late next year, our best guess would be Fall 2017.

Dynamics GP 2016 R2

Visit Endeavour Solutions for more information on:

Microsoft Dynamics GP ERP for Business Financials

Microsoft Dynamics CRM for Customer Engagement and Dynamics 365 CRM Cloud for Customer Engagement

Microsoft Office 365 and Cloud for e-mail, file storage and collaboration

Videos and Demos for Dynamics ERPDynamics CRM or Office 365

Microsoft Presidents Club Gold

Read More

Top 3 Excel Functions for Microsoft Dynamics

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

Congratulations Endeavour – Microsoft Cloud Certification – Way to go Team

A special congratulations to consulting the team at Endeavour for their latest in Microsoft Cloud certifications for Small and Midmarket Cloud Solutions Provider within the Microsoft Partner Network.

________________________________________
” Congratulations Endeavour – Microsoft cloud certification – way to go team!”

Office 365 Enterprise Canada Endeavour365 Cloud Logo banner

This certification is a great testament to the hard work and success that our clients have been able to achieve with Microsoft Office 365 Enterprise and other Microsoft cloud services including Azure Active Directory and Azure hosting.  Microsoft Canada now offers Office 365, SharePoint Online, Exchange Online and Azure in Canada hosted out of the ultra-secure new Microsoft Canadian data centers in Toronto and Québec City.
More info on Endeavour Solutions Inc. and the Microsoft Cloud see:
e-Business, Cloud, Mobile and Custom Integrations
More info on Endeavour365 for Office 365 Enterprise, Microsoft Cloud and e-mail Migration see:
Microsoft Office 365 with Endeavour Solutions

As a value add to new and existing clients, we are also now selling Canadian Dollar Microsoft licenses for Windows Server, SQL Server and other small, mid-market and enterprise software and user CALs in Canada.  see  www.endeavour365.ca/licenses

About Endeavour Solutions Inc (ESI)

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.

See our Innovative projects www.endeavoursolutions.ca/dynamicsprojects

Read More
1 2