This morning, I been in my company with the team and been discussing what kind of innovations we should think of next, specially after delivering the first version of data level security for partners out of the kitchen for Quality Assurance and testing!
While reviewing articles published by the community leaders, we have noticed an article by Mark Polino discussing a product enhancement to have the ability to paste from excel into General Transaction Entry form, and we liked the idea and started the development!
Below is our outcome:
And in writing, you will need to request a DLL from Dynamics Innovations by sending a mail to me (temporary until publishing the file) you just need to click on the below link and download the tool, then place the DLLs in your AddIns folder:
http://www.di.jo/GPExcelPaste.aspx
Go to excel and create a new excel to look as the below:
Copy data from this excel and get back to Transaction Entry window of Dynamics GP, go to additional >> Paste From Excel, or press on CTRL + F and enjoy!
Update: While testing the tool we have noticed the below:
1. Distribution reference column is required, you will need include the column while copying even if the column was empty.
2. Tool was not accepting empty cells in credit and debit columns, it was modified to work.
3. Tool has been merged with paid version and published over the company website.
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com
Here you gave clear idea about how to make the dynamics journal entry and also heard about an article while discussing the production enhancement.
ReplyDeleteMicrosoft office training is more faster and very simple task, we can easily learning that software. It is having more high quality features, even in online also we can learn it.
ReplyDeletepowerpoint training
Is there a way that you can add multiple references into GP with our add in?
ReplyDeleteCan this tool be used for Intercompany?
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHello Lisa,
ReplyDeleteActually is works for GP 2013, but you might need to use another package to sent to you, please email me to daoudm at DI dot jo to send you the package.
For people asking about the intercompany, we have noticed that the intercompany process is using different fields than the fields used in our template, therefore we have customized a workaround for this and got this added for paid version only.
Do these instructions work for GP v10.0?
ReplyDeleteYes it works across all GP version from GP 10.0
ReplyDeleteIs there is a similar add-in solution for the Purchasing and Sales Distribution Entry screens?
ReplyDeleteHow much is the paid version (to use with Intercompany) and how can we obtain this?
ReplyDeleteYou can buy the product online using the following page, prices are there.
ReplyDeleteOnce you perform the purchase you will be able to use the intercompany for you production server.
Hi,
ReplyDeleteIn your excel example, you have the column names reversed. It should be Debit Credit.
Leslie
Is there software available to enter transactions into Purchasing. I enter hundreds of credit card transactions..which involves entering into 2 screens. The second screen included the transaction detail.
ReplyDeleteThe link states this is only for the test company now? Was this once for free for production company as well?
ReplyDeleteWhat happened to the FREE part of this?
ReplyDeleteHello Guys,
ReplyDeleteThe tool is still free for GL Transaction Entry and paid for other modules.
Does this also work for GP2013? We are getting an error.
ReplyDelete
ReplyDeleteit is indeeed an important phase of any business techie's training.
I had visited your website which was really good General-Products
ReplyDelete