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 Oct  13  3
2018 Sep  27  3
2018 Aug  45  5
2018 Jul  18  5
2018 Jun  45  6
2018 May  33  5
2018 Apr  224  6
2018 Mar  77  7
2018 Feb  42  5
2018 Jan  91  5
2017 Dec  86  9
2017 Nov  39  6
2017 Oct  71  8
2017 Sep  31  5
2017 Aug  151  11
2017 Jul  164  9
2017 Jun  119  11
2017 May  224  10
2017 Apr  27  6
2017 Mar  248  9
2017 Feb  133  11
2017 Jan  404  11
2016 Dec  134  10
2016 Nov  106  12
2016 Oct  15  11
2016 Sep  29  15
2016 Aug  31  16
2016 Jul  27  11
2016 Jun  32  12
2016 May  30  20
2016 Apr  28  5
2016 Mar  21  10
2016 Feb  34  3
2016 Jan  6  4