In Dynamics GP 2013 R2 you can copy/paste a GL entry from excel directly to the transaction entry window

You’ll need the following columns set up in excel, just copy them to your clipboard (Ctrl+C), be sure to exclude the header row. The column names do not matter but the column order does matter.

Copy/paste these fields-distribution reference is optional

Copy/paste these fields-distribution reference can be blank

Open up the GL transaction entry window and choose Paste, be sure the journal entry window is blank, otherwise the paste button will be greyed out.  You cannot use the Ctrl+V shortcut – you must click on the paste button in yellow.

CopyPasteToGL2

If you click the paste button with one or more invalid GL account(s) nothing will be brought into the journal entry window and you must fix the issue first.  Plus, you will get a report showing the invalid accounts.

CopyPasteToGL3

You can only copy/paste one journal entry at a time.  However, this is such an improvement over the multi-user issues with text files and integration manager.

If you have problems, take a look at this post:

http://community.dynamics.com/gp/b/dynamicsgp/archive/2014/08/22/gp-2013-r2-copy-and-paste-from-excel-to-gl-nothing-happens.aspx

This entry was posted in Dynamics GP. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *