Menu
GP

Tip: Paste from Excel into Microsoft Dynamics GP

by the TrinSoft Dynamics GP Team

A nice time-saving function that came with the release of Microsoft Dynamics GP 2013 R2 was the ability to copy journal entries from Excel and paste them into the proper corresponding fields in Dynamics GP.

 

First, open Dynamics GP and navigate to the Financial Page and select “General” under the Transactions/Financial section as shown below.

 

Paste from Excel

 

This will open the transaction entry screen.  Within the window complete the fields in the top section including Batch ID (optional), Transaction Type, Transaction Date, Reference, and Currency ID if needed.

 

Paste from Excel

 

Next, in Excel make sure you have four columns in the following order Description, Account, Debit Amount, & Credit Amount (see below).  Copy from the first cell of the Description column to the last cell of the credit amount column as shown below.

(Note: The description does not have to be listed for each row.)

 

Paste from Excel

 

(Note: Do not copy the column headings.)

 

Back in Dynamics GP, place your cursor in the first account field, then at the top of the action bar select the icon that looks like the Excel button and says “Paste”.

 

Paste from Excel

 

Once the user selects “Paste” the data copied from Excel will be pasted into the Dynamics GP window.

 

Finally, review the JE to make sure that the accounts and dollar amounts are correct.  If the entry is in a batch you can save and then post the batch from the Batches window later; or if not in a batch post the entry now.

 

Paste from Excel

 

Tips & Tricks:

  • The debit and credit amount fields in Excel can be formula based as when they are pasted into Excel these fields will be recognized as static values.
  • The account string cannot be split among multiple columns. (Use the =CONCATENATE function to combine the segments as needed.)
  • Unit accounts and amounts can be included.
  • The Excel paste function only works with NEW journal entries; it is not possible to paste to a saved journal entry.

 

 
Search in All Title Contents
2018 Jul  4  3
2018 Jun  20  6
2018 May  24  5
2018 Apr  95  6
2018 Mar  74  7
2018 Feb  40  5
2018 Jan  73  5
2017 Dec  76  9
2017 Nov  39  6
2017 Oct  71  8
2017 Sep  30  5
2017 Aug  148  11
2017 Jul  148  9
2017 Jun  116  11
2017 May  201  10
2017 Apr  25  6
2017 Mar  162  9
2017 Feb  94  11
2017 Jan  354  11
2016 Dec  79  10
2016 Nov  69  12
2016 Oct  15  11
2016 Sep  27  15
2016 Aug  31  16
2016 Jul  25  11
2016 Jun  32  12
2016 May  27  20
2016 Apr  25  5
2016 Mar  19  10
2016 Feb  18  3
2016 Jan  6  4