3 Exciting New Features of Microsoft Dynamics GP 2020

Posted on: October 15, 2020 | By: Josie Mah | Microsoft Dynamics GP

Microsoft Dynamics GP has transformed businesses by providing a platform for data access and analysis. The much-anticipated 2020 version of Microsoft Dynamics GP offers users a variety of new features, making the use of the platform easier than ever. In this blog post, we explain how to use three of these new features.

1. Copy and paste purchasing transactions and distributions

The Fall 2020 Microsoft Dynamics GP now allows the option of defining purchase transactions and distributions and importing relevant data into the Payables Transaction window. This new “copy and paste” functionality will greatly increase efficiency, reduce error, and improve user experience.

  1. Copy and Paste PM Transactions and Distributions using the Transaction Entry window
  2. Include the following fields in the Excel spreadsheet: Description, Purchases, Trade Discount, Freight Misc., Document Number, O. Number, Cash
  3. Under Payable Transactions in Dynamics GP, select Transaction Entry and choose the Vendor ID.
  4. Place your cursor in the Purchasing field and Paste.

2. Match Excel Copy/Paste decimals places to currency setup

Previously, Microsoft Dynamics GP would import currency data incorrectly using the Excel Paste feature. In the Fall 2020 version of Dynamics GP, the system can be modified to recognize the decimal separators in Currency Setup.

  1. Choose Administration > Setup > System > Currency
  2. Choose your desired Currency ID, set a description, and input the correct separators.


3. Automated Reconcile of full General Ledger

In previous versions of Microsoft Dynamics GP, users had to reconcile one year at a time. With this new update, users can choose to reconcile all years in one action.

  1. Open the Reconcile Financial Information window.
  2. Select Utilities > Financial > Reconcile.
  3. Choose “All” for data to be reconciled from oldest to newest.

Next steps

Logan Consulting has helped many businesses optimize their operations with customized platforms like Microsoft Dynamics GP. Contact us today to find out how you can transform your business.



25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics
25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics

Free Download:

25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics

Download the guide ›

Top 10 Inventory & Operations Decisions Distributors Are Making Blind
Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Free Download:

Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Download the guide ›

2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›