Dynamics GP 2013 Excel Paste vs Dynamics Innovations Excel Paste

This morning i been working on the R2 release and been enjoying the newly added features and been playing around the newly added paste feature

Factor	GP Paste	DI Paste	Winner
Speed (when pasting 1500 rows)	100 seconds	60 seconds	DI
Data Validation	Data validated	No data validation	Microsoft
Coverage*	GL Only	All forms	DI
Intercompany**	Not Available	Available	DI
Columns Order Modifications**	Not available	Available	DI
Update Existing Journal	Not available	Available	DI
Paste Multiple Journals**	Not available	Available	DI

• * All GP forms is covered in purchased version only.
• **This feature is only currently available with purchased version, we expect this to be free soon.

---

Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Dynamics GP Excel Paste V 4.0

We have finally released and uploaded a new version for the Excel Paste, this one has the following coverage:

1. The major move was the ability to integrate into multiple products, like combining the GL Transaction Entry with the Analytical Accounting.

2. Ability to Paste into modified forms and additional fields.

3. We have added a link between the defined Products and the actually installed products to avoid annoying errors if you have missed one product in your workstation.

4. Added an option to handle prompts or disable the handling, to avoid any annoying messages during the paste operation.

5. For users who are running behind firewalls, they used to have Slowness during the login to GP, we have fixed this by moving the online validation to be through the webservices first and then direct database connection.

6. We had many “Minor Bugs” that were reported, all been resolved.

Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Dynamics GP Excel Paste has been ranked in DynamicsWorld Microsoft Dynamics Top 50 Add-Ons 2013

I got the mail this morning that the Dynamics GP Excel Paste has made it and ranked in the 2013 list of DynamicsWorld Microsoft Dynamics Top 50 Add-Ons.

Quoting from DynamicsWorld:

In previous years each platform has had its own Top 12, however, with an increasing number of ISVs now creating cross platform Add-Ons this year it was necessary to publish the top Add-Ons for Microsoft Dynamics as a single list of the Top 50.

The issue of what makes the best Add-On for an end user is dependent upon what the end user requires, so, as in previous years the list does not rank the Add-Ons in order of choice, instead, the list is published in Alphabetical order.

So GP Excel Paste might be the best! No body knows!!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Excel Paste and Payroll Transaction Entry

People been facing difficulties using the Excel Paste for Payroll Transaction Entry, therefore I have created the template and uploaded it to the host, you can download it now with the below format:

EmployeeId, ComputerTrxType, UprTrxCode, LocalAmount, LocalTrxNumber, LocalBtnNext

Watch the below:

Payroll Transaction Entry

Enjoy!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Microsoft Dynamics GP Excel Paste is now Online

 

Production version of Microsoft Dynamics GP Excel Paste is now released and the development team has updated the website to integrate PayPal!

Download Fabrikam copy now or purchase your company version now from the below link:

http://www.dynamicsinnovations.com/GPExcelPaste.aspx

Below is the pricing table for the tool:

Core Financial Modules (GL, CM, DTA)	350$
Accounts Payables and Receivables (AR, AP)	300$
Sales Order Processing (SOP)	400$
Purchase Order Processing (POP, POR, POE)	400$
Inventory Control (IV, IVC)	300$
Payroll (UPR)	300$
Full Package – All Modules	1,300 $

Enjoy!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Excel Paste for “Any Screen” in Microsoft Dynamics GP

 

Last few days, we have released a tool to paste data from Excel into Dynamics GP GL Transaction Entry form and published the tool for all users with no charge.

From that day, the development team in DI has decided to go further with this and tried to enhance the dynamicity of the tool to go beyond what we have developed and develop a tool for sale but worth payment, so end users can define the paste path and how to paste columns in Dynamics GP.

In addition they wanted to make this for all GP forms not only GL Transaction Entry, and going from there below what we have developed.

If you would like to watch this live on what we have done using excel paste for forms with scrolling windows, please take a look into the following video:

Purchase Order Excel Paste

So what if you do not have scrolling window and you want to paste from excel into “Cards”? We have included this we well! Check below video on how to paste customers:

Customer Card Excel Paste

Initially, users will need to analyze what fields need to be included in the paste operation, for example let us take the purchase order screen as an example:

I have picked the integration path that I need on the screen and been ready to setup my Excel Paste using the following setup screen:

End user will be able to define what they just analyzed using the above screen, they just select Form Name, Window Name and start selecting fields one by one.

Once finalizing the setup, copy data from an excel like the below:

And just paste on the purchase order screen:

Enjoy!!!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Dynamics GP Journal Entry: Paste From Excel–Free Add-in

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:

Paste from Excel

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