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:
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.