Jet Reports 2018 R2 New Features

Jet ReportsI wrote a blog post on Implementing Jet Reports earlier this year. While I was mid-series a new version of Jet Reports was released, Jet Reports 2018 R2.

Jet Reports published a blog post on the new features and there are some quite nice ones included.

  • Run Reports directly from your Windows Desktop – Run your reports without even starting Excel; just right-click and the new task tray app will let you know when your report is ready.
  • Run Reports in the Background within Excel – No need to wait for your report before you can start using Excel as you can run your report in the background and continue working with your other Excel files.
  • Updated Jet Ribbon and Windows within Excel – The Jet ribbon has been updated and the entire user interface has been refreshed to be more consistent.

    Several items have been rearranged to be easier to find and other related items have been grouped together for a cleaner experience; all configuration settings have been combined under a single button and the run options have also been consolidated.

    In an effort to better explain what they do, the Refresh and Report buttons have been renamed to Run and Run from Cache, respectively.

Details on all of the changes are available on the Jet Reports blog.

Microsoft Dynamics GP 2018 RTM Now Available for Download

Microsoft Dynamics GPI’ve been checking all day, but, finally, the download for Microsoft Dynamics GP 2018 RTM is now available.

You can download it from here (CustomerSource or PartnerSource login required).

You can read about the new features coming in my Dynamics GP 2018 RTM Feature of the Day series of posts.

The Support team will be running a New Feature series of posts starting on 5th December. These blogs will give a comprehensive overview of the features along with excellent content, documentation, and videos, as they have done in the past.

I’ll be going hands on with the new version in a series of posts, probably starting as soon as the download is finished; the posts will start with the installation of the new version, before moving onto covering the new functionality.

Hands On With MDGP 2018 RTM: Series Index

Microsoft Dynamics GPOn the 1st of December, Microsoft Dynamics GP 2018 RTM is due for release. I am, as I usually do, running a series of “Hands On” posts where I step through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

These posts will be posted over the coming days and weeks, and may be interspersed with posts on other subjects, so make sure to check back regularly.

Continue reading “Hands On With MDGP 2018 RTM: Series Index”

Microsoft Dynamics GP 2018 New Feature Blog Series Schedule Announced

Microsoft Dynamics GPMicrosoft’s Terry Heley today published a blog post outlining the schedule for the Microsoft Dynamics GP 2018 New Features blog series.

This blog post series is from the Dynamics GP Support and Services Blog which usually covers in depth the new features after launch; usually there is a series of posts by the Inside Microsoft Dynamics GP blog which precedes the launch of the new version which I am still hoping will happen this year.

There are five key areas of new functionality in Microsoft Dynamics GP 2018:

  1. Comprehensive Doc Attach
    Today, we introduce the next evolution with comprehensive Doc Attach on most master record windows, inquiry windows and transaction entry windows.
  2. User Experience
    Giving users easier and faster ways to get to and find the data they are looking for to make decisions based off the information stored in Microsoft Dynamics GP.
  3. Optimize Financials & HRP
    Recognizing the voice of our customers, you’ve provided the feedback, we’ve optimized your Financials and HR/Payroll experience in Microsoft Dynamics GP 2018
  4. Workflow
    With the release of Microsoft Dynamics GP 2018, we continue to extend the capabilities of Workflow. In addition to new workflows such as GL Account and Purchase Invoice, we’ve added workflow capabilities like copy step and reminder emails.
  5. Power “Suite” Evolution
    Support Paging and Filtering in OData Services, Support OData V4 and what you all have been waiting for GP Power BI Content Pack.

I’ll not list the detailed schedule, but the new features blog series will run from 5th December through to 15th February.

The post can be found here.

Microsoft Dynamics GP July Hotfix – 2017 Mid Year Tax Update Now Available

Microsoft Dynamics GPThe Dynamics GP Support and Services Blog blog announced the availability of the Microsoft Dynamics GP July Hotfix – 2017 Mid Year Tax Update towards the end of June.

This hotfix is available for Microsoft Dynamics GP 2013 R2, 2015 r2 and 2016 R2.

While all of them have updates for the US and Canadian Payroll systems, there were three changes in the 2016 version which caught my eye:

  • Financials

    • You may not be able to view any document attachment for any OPEN Payables Document.
    • Invoice Receipt Date field added for UK installs, click here for details.
  • System

    • Scan functionality may not function with document attach

The fixes to Document Attachment are good to see, but the Invoice Receipt Date was especially interesting as it results from new legislation which came into effect on April 1st for businesses of a certain size in the UK with a duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardize their ability to trade.

The new Invoice Receipt Date field is available on Payables Transaction Entry (Purchasing >> Transactions >> Transaction Entry), Receivings Transaction Entry (Purchasing >> Transactions >> Receivings Transaction Entry) and Purchasing Invoice Entry (Purchasing >> Transactions >> Enter/Match Invoice).

The Doc Attach changes only effect 2016, but the new field is available in 2013, 2015 and 2016.

Microsoft Dynamics GP January Hotfix Released

Microsoft Dynamics GPI don’t usually post about releases, except for major version releases. However, the January Hotfix release caught my eye with a few of the included features in the 2016 R2 one.

As well as having the US Payroll updates there are updates to the following which would be of benefit to clients in the UK:

  • VAT Daybook

    • VAT Daybook Summary reports may not show correct data in boxes 1, 6 and 7 if you voided a transaction.
    • VAT detail report may show incorrect figures if you have 2 or more tax codes on a transaction.
  • General Ledger

    • The Excel copy and paste function may not calculate the credit/debit column correctly when using an allocation account.
  • Fixed Asset Management

    • Tax values may not update properly if a user marks to create multiple fixed assets in the Fixed Asset Purchase Order additional information window.
  • Bank Reconciliation

    • You may experience performance issues with the Checkbook Register Inquiry window after you install GP 2016 R2.
  • Project Accounting

    • Ability to change line distributions for time and material projects in revenue recognition.
    • Fee Accounts not available in line distributions button.
    • Purchase Receiving’s not reflecting WIP account edits from Purchase Order for non-inventory items.
  • System Manager

    • Fixed issues with Uncollated printing.

The hotfixes for Dynamics GP 2013 R2 and 2015 R2 only contain US Payroll fixes.

The post from the Dynamics GP Support and Services blog contains the download links.

Microsoft Dynamics GP 2016 R2 Now Available For Download

Microsoft Dynamics GPOn the Inside Microsoft Dynamics GP blog, Pam Misialek has announced the availability of Microsoft Dynamics GP 2016 R2.

You can download it from here.

You can read about the new features coming in my Dynamics GP 2016 R2 Feature of the Day series of posts.

Pam highlights that starting next week, the Support team will post additional technical content in their Blog Series

Dynamics GP is moving, following partner and customer feedback, to annual releases. There was a recent roadmap released which you can see here.

Microsoft are currently working on GP Next and this is your opportunity to help shape the future functionality using Microsoft Connect. I would recommend you use that site to request features or enhancements which you would like to have included in Dynamics GP.

I’m about to drive home from client site, so I can’t get my hands on it for another 7 hours or so 🙁

Microsoft Dynamics GP 2016 Cookbook Now Available In August

Microsoft Dynamics GPMark Polino and I have been working on a new version of the Microsoft Dynamics GP Cookbook for Dynamics GP 2016. Originally, it was scheduled for publication in January 2017.

However, Mark and I were able to proceed a tad ahead of schedule, meaning the Cookbook is now slated for release in August:

Microsoft Dynamics GP Cookbook

That’s right; scheduled for release this month. Five months ahead of schedule. Don’t worry though, the quality is as high, if not higher, than previous versions as this book is a genuine collaboration between Mark and I. By splitting the work in this way, we were each able to focus on particular areas in which we had strengths.

We also received good feedback, to guide improvements, from fellow MVPS Leslie Vail and Jivtesh Singh.

You can pre-order the book from Packt Publishing, and very soon your pre-orders will be shipped. From what I gather the book should be available to order, as opposed to pre-order, in the next week or so, so you won’t need to wait long to receive your copy.

Microsoft Dynamics GP 2016 Cookbook Available In January 2017

Microsoft Dynamics GPMark Polino and I are working on a new version of the Microsoft Dynamics GP Cookbook for Dynamics GP 2016.

The book is currently scheduled for release in January 2017 and can be pre-ordered now from Packt Publishing:

Microsoft Dynamics GP Cookbook

Management Reporter 2012 CU15 Is Now Available

Microsoft Dynamics GPThe Dynamics Financial Reporting for Microsoft Dynamics GP has announced the availability of CU15 for Management Reporter 2012. This cumulative up-date contains a few bug fixes as well as some enhancements.

Here’s a summary of the new Management Reporter CU15 features:

  • Improved responsiveness in the Web Viewer.
  • A search bar has been added to search through the current level of the report as in-browser search functions may not always return all results because of the performance changes to improve responsiveness.
  • Printing in the Web Viewer through XPS download.
  • PowerShell module to enable reset of data mart.
  • Added a Turkish (tr-tr) localization.
  • Additional fixes for product defects.

The Dynamics Financial Reporting for Microsoft Dynamics GP team will be blogging about the new features in detail soon.

There are a few new prerequisites which are required for this cumulative update:

  • SQL Server 2012 or higher.
  • Microsoft .NET Framework 4.6.1 is also required (when installed this may require a reboot).

Management Reporter CU15 Release is version 2.12.15000.56; make sure your ERP version is supported by checking the compatibility list.

The EN-US download for Management Reporter CU15 is here and localised versions will be coming soon.