How to best import journal entries into GP from Excel

(0) Share

Report

Posted on by Community Member

As new user to GP, I want to avoid re-keying journal entries into GP, and would rather use Excel template to upload into GP. What is the best way to accomplish this?

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

MattPaulen 6,912 on at

Like (0)

Report

If you are on GP 2013 R2 then there is built in functionality for importing from excel now.

Take a look at this blog: www.crestwood.com/.../copy-and-paste-from-microsoft-excel-to-dynamics-gp

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply. Unfortunately, we have GP 2013, but not the R2 version.

Was this reply helpful? Yes No
MattPaulen 6,912 on at

Like (0)

Report

Do you own Integration Manager? That would be one way. There's also SmartConnect by eOne. And another one I've seen in use awhile back is a free tool found here: http://di.jo/GPExcelPaste.aspx.

Was this reply helpful? Yes No
mm123 2,535 on at

Like (0)

Report

Jon,

We have developed a Product - Excel Journal entry Importer & implemented for several clients, If you are interested to learn, please drop an email.

samr@expsoltech.com

www.expsoltech.com

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Jon,

It's painful, but you could use the Table Import Utility - everyone has it, no extra charge. The GP SDK explains the fields you would need to import to the header and distribution tables.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We do have Integration Manager, so I will start to look into that first.

thanks to all for the replies.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

This tool is remarkable and the company has been around forever. This is actually called “ExcelToGP”.

[View:https://www.datamillsoftware.com/Software/View/4223e96c-d8d7-45df-9c9d-5c8d7f17791d]

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

In addition to GP table import and GP Integration Manager, there is this third-party product http://www.infiniatech.com/home.aspx. This you can use to import multiple journal entries at once plus AP and AR entries. We have many users using this and it works great.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jon,

You can use VKonnact for GL import. Through VKonnact you can import 1K (Approx.) GL entries in 60 sec time.

Also, VKonnact has its own data validation engine to validate & Correction data before importing.

You can use VKonnact for 15 days without spending single penny.

Kind regards,

Tejas Patel

www.flovianit.com

Was this reply helpful? Yes No
Suggested answer

MMA 10 on at

Like (0)

Report

Can multiple entries be pasted at the same time? If so please guide me on how to paste them all at once.

My issue is that I have about 315 entries that are unbalanced due to a system error and need to add the salary expense G/L account number to each one. If you have any ideas on how to resolve this issue please help me.

Was this reply helpful? Yes No