Financial Reporting: 10 Tips for the Pros

Management Reporter for Microsoft Dynamics is an interactive financial reporting application tool used to create, maintain, deploy, and view financial statements.

It provides features that goes beyond the traditional reporting, helping you design a wide variety of reports which are enhanced by the use of interactive notes and instant messaging.

Management Reporter also includes dimension support, which means that account segments or dimensions are immediately available.

In our recent webinar « How Does Better Financial Reporting Sound », we introduced you to this great reporting tool, its components and key concepts.  In the presentation, we:

  • Demonstrated the basics of MR (Building Blocks, Dimension Sets and Categories.)
  • Showed you how to use attributes to bring transaction details into your reports
  • Provided a quick overview of the Management Reporter tools
  • Used sample dimensions to create reports
  • Walked you through the report Wizard
  • Introduced you to the missing account analysis tool

We also highlighted the best Financial Reporting practice tips and tricks. Since this topic generated a lot of curiosity and excitement, we have decided to share them once again with you here.

So here they are, your Top 10 Tricks discussed during the Webinar to make your report creations a snap:

  1. Create a base template that can be re-used to create multiple reports just by “Saving as” a new report
  2. Use the Wizard to create your base report.  It will do the mapping and allow you to format/change the row/column building blocks one the report is created.
  3. Use Report Groups to schedule and generate multiple reports
  4. Organize your folders for easy access to all of your Report Definitions, and other Building Blocks
  5. Use the Find/Replace to make mass changes which is located in the Menu Bar under Edit
  6. Renumber row feature will now update your formulas and is located in the Menu Bar under Edit
  7. Hide columns when working with reports with many columns.  It will minimize the back and forth on the scroll. This feature is located under the Menu Bar in the Format menu.
  8. Use Excel to make format changes by simply using the Copy / Paste functionality within Management Reporter
  9. Use the Missing Account Analysis tool once you have completed your reports.
  10. Use the online HELP!  It is full of information and is quite user friendly.  You can also download a MR User Guide from this location.

You are now ready for a positive reporting experience!

For more information on this topic or help to identify potential gaps and inefficiencies in your organization’s operations, contact us directly at +1 (888) 213-5111 in Canada or at +1 (800) 975-7269 if you are located in the United States.  You can always send us a request as well at Negotium Technologies.

Microsoft Dynamics GP 2018 is here!


This is it. You’ve been waiting for it and it is now here : Microsoft Dynamics GP newest version is now available!

The 2018 version of Microsoft Dynamics GP primarily focuses on product feature enhancement requested by the users. In the last few months, current Microsoft Dynamics GP users have communicated through the Customer Source Connect site, numerous suggestions to improve or add to the existing functionalities. Although Dynamics GP is quite a mature product that already offers all the major components and features one would expect and want from an integrated management solution, the day-to-day needs of its customer base never cease to evolve, thus the system put in place by Microsoft to capture these demands to thereafter integrate them into a future version.

With Microsoft Dynamics GP 2018, you can expect to find your well known complete range of features that already enable you to go about your daily operations, as well as a series of improvements and an overall enhanced user experience.


What are the main improvement areas?

User Experience

Microsoft Dynamics GP 2018 provides simplier and faster ways to search, find and retrieve the data you need. You will discover additional sorting options that support a faster access to your information. Some of the new features also offer these same advantages for searches on the web client.

Document Annexation

Known as « Comprenhensive Doc Attach », it is now possible to add, access and modify annexed documents directly from your Master Records, Inquiry windows or Transaction Entry windows.

Financial Services Features

Microsoft Dynamics GP 2018 enables you to do much more with much more effciency! You can now print and send your statements by email directly from your customer cards. The purchase order generator opens a detailed list of all the orders with filter options. The vendors settings options have also been enhanced with a series of new features that include the possibility to create a check by invoice.


Microsoft Dynamics GP 2018 continues to extend its workflow management capacities through new workflows for the General Ledger accounts and Purchase Reception transactions (Purchase Order Invoices). You will also find other additional workflows that pertains to automatic sending of email reminders, the possibility to retrieve workflow reports such as reports on the administration of, and the creation of new workflows hrough a new « Copy Workflow Steps » option.

Bank Reconciliation

There are wew additional sorting options at the bank reconciliation level to discover. Notably, a very nice new set of features that provide a faster and easier way to reconcile your transactions.

Data Optimization

Microsoft Dynamics GP 2018 offers optimized paging and filtering options in OData. OData V4 options have been optimized with the availability of predefined GP content for Power BI (Microsoft Dynamics GP Power BI Content Pack).

Power BI

With the Power BI Content Pack, you will have access to a series of predefined reports for the financial, sales, purchasing and inventory modules. Each report has been predefined with relationships with the Dynamics GP tables. It offers various filters that enable you to only view the information that is important to you. It also provides colomns with calculation options that can be displayed in your Power BI reports.

So here you have it. A quick overview of Microsoft Dynamics GP newest version. Of course, this list of features is not exhaustive. It should however convince you of the importance of this new release. We will be presenting the new features in depth in the course of our upcoming « Journée Expérience 2018 ». Stay tune for future announcements on this not to miss event.

Until then, for more information on our « Journée Expérience 2018 » or to obtain a personalized Microsoft Dynamics GP 2018 migration process review session with one of our experts, contact us at or by telephone at +1 (514) 871-0470 | +1 (888) 213-5111

Dynamics GP 2016 is just around the corner. What are the new features?

Microsoft Dynamics GP team announced the launch of Dynamics GP 2016 for May 1st, 2016.

This new version confirms Microsoft Dynamics GP’s position as a state-of-the-art ERP solution and is anchored in today’s era of affordable technologies in addition to being fully adaptable to Cloud and mobile. Dynamics GP scales to all-size companies’ budgets and needs, from the small shop to the large company, without compromising on the range of features that are expected from an ERP in 2016. It becomes a powerful tool that will manage all your operations and finances.

Here is a glimpse of GP 2016 new features:

HTML Web client

One of this version’s biggest changes is the HTML5 web client. It will replace the Silverlight interface and allow users to use all Dynamics GP features in their favorite HTML5-enabled browser. The new web client is available for Internet Explorer, Chrome, Safari, Firefox and Edge and is designed to allow mobile access on Windows, Apple and Android devices. The HTML5 web client provides the visual interface, while all features and processes are operated by the server.

Web Client search

To facilitate work via the Web Client and to help you keep organized, the Web Client Search feature is one of the main new characteristics. In web client Search, you will find:

  • A list of all currently opened windows/reports based on your search criteria
  • A list of all available windows and reports based on you search criteria
  • And the possibility to close all opened windows at once.

Budget import Exception Report

During a budget import from an Excel template, an Exception Report will display all ledger accounts that don’t exist in your Dynamics GP instance.

Smartlists export into Excel in “number” format

Current users of Dynamics GP 2015 and older versions already know: Smartlists transfer to Excel imported numbers in “text” format. They will probably be happy to hear about this new feature, as in version 2016, numbers and amounts exported to Excel will be formatted as numbers and no longer as text. (Yeah! J )

Management Reporter accessible in https format

Microsoft GP 2016 will allow Management Reporter deployment in https, allowing users to access reports via a secured web page.

Purchase order pre-payment

Purchase order pre-payment will now be possible and will include taxes, freight and miscellaneous costs.

The total amount of a purchase order can also be included in the pre-payment.

Check payment batch via Credit card

You will be able to choose between check, EFT and now credit card as payment methods for a payment batch. A statement will be printed to show the provider that the invoice(s) has been paid by credit card.

This credit card payment will automatically generate an invoice to be paid in your vendor account associated to the credit card.

All-in-one view of sales transactions

It will now be possible to see, on a single screen, all transactions linked to a client’s sales (Quotes, Orders, Invoices, Payments, Debit or Credit notes) and to filter transactions or drill down in them.

All-in-one view of inventory transactions

You will also be able to see, on a single screen, all transactions related to an inventory item: Quantity In, Quantity Out and Quantity Moved.


Isn’t this exciting?

Moreover, Microsoft Dynamics GP 2016 will include a number of improvements to the core product, including the possibility for the user to modify notifications and Workflows, to attach documents related to employee expenses in the project accounting module and to configure and assign user rights more easily in analytics accounting.

Stay on the lookout and don’t miss the event that will soon be organized by Negotium to mark the launch of Dynamics GP 2016. We will keep you posted!