Microsoft Dynamics GP (Archived)

Dynamics and excel

(0) Share

Report

Posted on by Violet

145

importing Journals from excel into Dynamics

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

There's a product called 'Excel Paste' that you can install to do this (www.di.jo/GPExcelPaste.aspx). Or, upgrade to GP 2013 R2, which is due to be released soon. This feature is scheduled to be part of that release.

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

You can also using Integration Manager to import Journal Entries from Excel to Dynamics GP. To import JE form Integration manager follow blow link.

blog.interdynartis.com/using-integration-manager-to-import-journal-entries-into-dynamics-gp

You can also use word merge to create a macro file and import Journals into GP.

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Violet,

You can import journal entries from excel using

* eConnect custom application

* Integration Manager

* GP Macro using Mail-Merge

* Table Import(Not Suggested - No validation, need to know the table structure & entry reflection in back-end)

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

DI Excel Paste is your best option, it is free for General Ledger Journal Entry, and has extended capabilities that work on several other Dynamics GP forms.

All you need to do is to download the tool from the link above, and you may follow the instructions within the manual for any associated inquiries.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Frank

Are you able to advise if the full functionality of GP Excel Paste is to be included in GP 2013 R2. We are not only very interested in the General Journal Paste Option, but also in the SOP Paste Option.

Judi Carson

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

The functionality provided in GP 2013 R2 is related to Journal Entries import (General Ledger level). DI Excel paste extends over Dynamics GP forms in a variety of modules such as Sales, Purchasing, Inventory ...etc

Was this reply helpful? Yes No