Dynamics GP Journal Entry pasted from Excel with free Add-in

Ever find it a little to tedious when inputing jounral entries in Dynamics GP? Well, developers listened and created a free add-in to simplify the task. By downloading the tool, you will be able to save time and increase your efficiency.

Check out how this works

 

To get started, simply download the tool from the link below and place the DLLs in your AddIns folder.

http://www.di.jo/GPExcelPaste.aspx

Then, create an excel view like the following:

Dynamics GP Journal Entry

Highlight and copy the data in this excel table

Navigate back to the Transaction Entry window of Dynamics GP and select additional>>Paste from Excel (or CTRL + F for shortcut)

Next, spend the extra time you saved checking out the rest of the GP tips on Tridea Partners’ blog!

How to Copy and Paste into Microsoft Dynamics GP

Advtrex’s Titanium GP brings the ease of copying and pasting into Microsoft Dynamics GP.

Imagine a user wanted to copy and paste 50 lines of data from an Excel worksheet into a General Journal Entry in Dynamics GP. Normally, this would require using Microsoft importing tools that take a heavy amount of time depending on the size of the data files. With Titanium GP, a user can easily and immediately copy and paste import detail lines.

1. Highlight data in your computer file
2. Right click to copy or hold down “CTRL+C”
3. In GP, hit “Paste”.

Voila! The data is immediately pasted from Excel or Word into GP.
To make the process even faster, use keyboard shortcuts to copy/paste:

• To paste in Dynamics GP, hit “CTRL+T”
• To view in Grid form that allows the user to copy lines, hit “CTRL+G”

Pictured below is the grid view (CTRL+G).

How to Copy and Paste into Microsoft Dynamics GP 2013

When you copy/paste from Excel or Word to GP, the order of the columns is flexible.  As long as the columns titles match the respective fields in the GP window, the function will recognize the proper fields to copy/paste data.

Notice below that the Debit, Credit and Reference columns have been switched.

Titanium GP

Nonetheless, we are still able to successfully paste the data into the GP window.

Additionally, this tool allows copying and pasting from GP into an Excel or Word document. To save a GP document (or export it) to Excel, open a document in GP and use the menu command to “Save to Excel.” You will then be prompted to indicate the path and name to save the file.

The COPY/PASTE functionality can be used with the following windows:

• Journal Entries

• SOP Entry

• Purchase Orders

• Receivables Transaction

• Inventory Transaction

• Inventory Transfer

• Inventory Kits

Contact us at Tridea Partners to learn more about this tool.  info@trideapartners.com