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

This 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.

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:

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

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.