importing Journals from excel into Dynamics
*This post is locked for comments
importing Journals from excel into Dynamics
*This post is locked for comments
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
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
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.
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)
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!!!
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.
Almas Mahfooz
3
User Group Leader