Microsoft Dynamics GP Fall 2020 Release New Features: Copy and Paste Purchasing Transactions and Distributions

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Copy and Paste Purchasing Transactions and Distributions Financial enhancement.

This new feature allows users to create purchase transactions, including distributions, in an Excel workbook and paste them into the Payables Transaction entry window in Dynamics GP. It will work in both the Dynamics GP desktop and web clients.

The pasting of the transaction and the distributions are done separately from different Excel worksheets. The worksheet must have all of the required fields in a specific order to paste successfully; amount fields need to have a value, but can be set to 0.

Excel with transsction fields

The required fields are:

  • Description
  • Purchases
  • Trade Discount
  • Freight Misc.
  • Document Number
  • P.O. Number
  • Cash – if the cash field has an amount, the Payables Cash Entry window will automatically open after clicking the “Paste” button.

In the Payables Transactions window (Purchasing area page » Transactions » Transaction Entry), select a Vendor ID and place the cursor in the Purchases field and click the Paste button on the action pane:

Payables Transaction Entry

Distributions will default from the Vendor record unless they are also pasted (this is an optional step, but one which must be done before the transaction itself is pasted in). As with the transaction fields, there are certain required fields for the distributions which must all be supplied:

  • Distribution Reference
  • Account
  • Distribution Type – using the names in the Type field in the Payables Transaction Entry Distribution window.
  • Debit
  • Credit
Payables Transaction Entry Distribution

If you will be pasting distributions, you need to paste them before the transaction itself; to do this, open Payables Transaction Entry, enter a Vendor ID, click the Distributions button and click Paste to paste the distributions; you will then return to the main window and paste the transaction.

I can see pasting payables transactions to be quite a useful function for users who are not already set up with an import routine.

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

2 thoughts on “Microsoft Dynamics GP Fall 2020 Release New Features: Copy and Paste Purchasing Transactions and Distributions

  1. Christine Polifka says:

    Is this feature also available for Purchase Order Processing to match a receipt to a invoice?

    1. Ian Grieve says:

      Hi Christine,

      No, this feature is Payables Transaction Entry only.

Leave a Reply

Your email address will not be published. Required fields are marked *