Dynamics GP2013R2 – Copy Paste Journal entries from Excel to Transaction Entry

Dynamics GP2013R2 – Copy Paste Journal entries from Excel to Transaction Entry

One of the great new features in GP2013 R2 is the ability to copy and paste from an excel spreadsheet directly into the journal entry screen in GP. Here is how it’s done.

The first step is to create your spreadsheet that contains your journal entries.

There are four columns that your source excel file must contain (The columns must be in this order):

  1. Description: Enter the description of the account. The description is not required. (Field can be blank).
  2. Account: Enter the GL accounts for each amount.
  3. Debit: Enter the debit amount for the account on the same line.
  4. Credit: Enter the credit amount for the account on the same line.
  5. Alias: Optional 5th column if you are using Analytical Accounting.

The second step is to copy the columns of data you want for your journal entry. (Note: Do not copy the column headings or you will receive errors when you paste the data into your transaction entry. You do need to copy column 1 for Account Description even if you are not importing this information.)

The third step is to access the Transaction Entry window: Financial >> Financial >> General

(You can enter the Transaction type (Standard or Reversing), Transaction Date, Source Document Code, Reference, and Currency ID before or after you paste in the lines.)

The fourth step is to make sure your cursor is in the Account field.

When you click Paste: If there are errors in your file, you will receive this Report Destination for the GL Transaction Paste Validation Report. Your data will not be copied into the window. Once you fix the spreadsheet, recopy and paste the information.

If there are no errors in your file, the copied data will be placed into your Transaction Entry.

You can enter transactions in a batch or individually. Follow normal posting procedures followed by your company. If a batch is being used, save the batch. If this is an individual entry post.

Let us know if you have any questions about this new feature. Watch for additional blogs on other new features included in this release.

Contact us if you would like to schedule a time to install GP 2013 R2,


Post A Comment

You must be logged in to post a comment.