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 Apr  26  5
2018 Mar  67  7
2018 Feb  36  5
2018 Jan  59  5
2017 Dec  68  9
2017 Nov  37  6
2017 Oct  71  8
2017 Sep  30  5
2017 Aug  145  11
2017 Jul  140  9
2017 Jun  112  11
2017 May  186  10
2017 Apr  24  6
2017 Mar  121  9
2017 Feb  72  11
2017 Jan  300  11
2016 Dec  53  10
2016 Nov  42  12
2016 Oct  15  11
2016 Sep  26  15
2016 Aug  30  16
2016 Jul  23  11
2016 Jun  29  12
2016 May  27  20
2016 Apr  18  5
2016 Mar  18  10
2016 Feb  9  3
2016 Jan  4  4