Uncommonly Used Features – Copy-Paste Function in Dynamics GP

By Deb Schaffer | May 31, 2022

In this blog post, we’ll be walking through how to use Copy-Paste function in Dynamics GP in General Ledger, Payables Transactions, and Payroll Transactions areas.

Using the Copy-Paste Function in Dynamics GP for General Ledger Transactions

First, let’s take a look at using Copy-Paste to bring in General Ledger (G/L) transactions.

If you have data that needs to be entered directly into the G/L, such as a payroll transaction if your payroll is outsourced, or transactions that need to be entered monthly, one way to bring these in is to copy-paste.

On your spreadsheet that contains the data that you need to import, create a new tab so that you keep the original file data, and enter in the following headers for columns A through D:

  • Reference
  • Account
  • Debit
  • Credit

Picture1 4

The reference can be whatever you want to use as the line reference on the transaction. Then enter the entire string account number. You do need to split out Debits and Credits separately as I’ve shown in the example below. You cannot combine these by doing a negative to represent a credit type entry.

Go to GP and open the General Ledger Transaction Entry page by navigating to Financial > Transactions > General.

Picture2 4

Enter in the header information – Batch ID if needed, Transaction Date, and reference. Then tab to the first segment of the account number.

Back on your spreadsheet, select the data that you want to paste into the transaction. Select only the data, not the column headers.

Picture3 1

You will still see if your transaction is balanced when you import it, and if there is an account not in GP that is on your data for import, you will get a report that shows the accounts don’t exist.

How to Use the Copy-Paste Function in Dynamics GP for Payables Transactions

The copy-paste for Payables Transactions is similar. You need to have the data you want to import in the specific format shown below.

Picture4 1

Once you have the data, navigate to Purchasing > Transactions > Payables Transaction Entry.

Enter the header information for the transaction including the Vendor ID. Then click on the Paste button.

Picture5 2

The data will be entered into the transaction. Distributions will default in from the Vendor record unless you paste in the distributions (it is not required to paste these in).

The process is similar to using copy-paste on the distributions. The example of the spreadsheet layout is shown below. Once you have the transaction pasted in, click on the Distributions button, copy your lines from the spreadsheet and click Paste in the Distribution window.

400-6520-00PURCH1000
000-4601-00TRADE1010
400-6500-00FREIGHT25
000-6780-00MISC15
000-2100-00PAY540
000-1100-00CASH500

Picture6

Using Copy-Paste Function in Dynamics GP for Payroll Transactions

The last area where Copy-Paste can be used is in Payroll Transaction Entry. For you to be able to paste in a group of payroll transactions, you need to be on a “fresh” page, that is, where you have not entered any other lines for this payroll batch. If you need to add additional lines, do that after you paste the file in.

The format for using the Copy/Paste function in Payroll is shown below.

Picture7

Navigate to the Payroll Transaction Entry window (HR & Payroll > Transactions > Transaction Entry) and enter in the Batch ID and Transaction Defaults.

Picture8

Then copy the data only (not the column headers) and back in GP, click on the Paste button.

Picture9

Now if you have any additional lines that need to be entered, you can continue on in the next available row. Then process your payroll as you normally do.

Questions?

If you have any questions, don’t hesitate to reach out – we’re happy to assist you.

Related Posts

Recommended Reading:

Performance Turning Webservices in Dynamics 365 Business Central: Migrate Your Integrations off SOAP and Move to OData or API

Dynamics 365 Business Central users will soon be unable to use SOAP web services when making application functionality available to […]

Read the Article

Stoneridge Software Selected for 2022 Microsoft US Partner Award – Dynamics 365 Business Central

Stoneridge Software is honored to be selected as a 2022 Microsoft US (MSUS) Partner Award winner for Dynamics 365 Business […]

Read the Article
6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X