Dynamics GP Excel Paste–New version has been released

Yesterday we have released a new version of the Dynamics GP Excel Paste, it has many new features and enhancements, I am showing the main additions in this post:

1. One installation across all GL Versions: (GP 10.0, GP 2010, GP 2013), ALL Service Packs, all platforms (Windows XP, Windows 7, Windows Server), any CPU (64x, 32x).

2. Messages Handling: We left this option for end user to decide either to auto answer the dialogs or by manually handling answers:

Another message will be shown:

3. Added more free screens: we have allowed the paste over common objects across all companies, like Currencies, Users, Tasks and Roles.

4. Enhanced the connectivity to the internet: if you are running behind firewalls we been facing difficulties loading templates as your firewalls are blocking the outbound access to the SQL, by using an alternative to the 1433 port, currently the application automatically calls a web service using the default port and using default proxy settings to pass through firewalls and get the templates installed.

5. Enhanced the ability to paste into distribution windows: we found many issues pasting using Advanced Excel Paste into “Distribution Windows”, issue have been resolved and you can paste safely:

PM Transaction Entry with Distribution

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 is now supported on GP 2013

We did few code modifications to get this works on GP 2013, it was a matter of doing some changes to database naming that was statically assigned like DYNAMICS and TWO.

For web client, I been able to load the menus into the additional menus of the application screens, but still unable to access the Clipboard to load data due to security complications between web client and server, besides we feel like the Continuum API which we use to perform the paste operation is not loaded over the web client, however as long as the .NET still supported, I assure you that we will make it, but we’ll be waiting for the RTM release to kickoff!

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–New Version Release

I am sure that for some people this became annoying, but I assure you guys that for the last two months I did nothing but modifications on the Excel Paste due to the huge number of requests we got and still getting.

This version was scheduled to be released by the first of the month, but it was postponed for few days to include more enhancements, below what we have changed:

• Additional Modules has been added:

Now the product does not works only with Dynamics Dictionary, it was extended to include almost all Dynamics GP modules, I personally have tested the below:

1. Manufacturing
2. Cashbook Management
3. Fixed Assets
4. Analytical Accounting

• Special SQL Command Prior to Paste:

We did face many cases where the end user wanted to perform some operations on the database level before doing the paste, like deleting Journal Lines before pasting new lines, this would be possible before and now it became an easy setup.

• Special SanScript Commands:

While trying to apply the tool over the Item Transfer form we have notice something cannot be done using old version specially when you have Multi-bin activated or Serial/Lot Tracking for your items, it took allot to be done but we have created an option for experts to run special SanScript commands before filling any of the fields and perform any kind of operations on the field, like getting new form opened or running some validations.

Inventory Item Transfers with Multi Bin

• Products Online Download

We have added a functionality on the tool to accepts new Dynamics GP Products at runtime! There will be no need from the development team to release new package each time we add a module, we will be updating our host with Product configuration and all the necessary setup and the end user will only download the product to get it active:

• Filtered Templates

Now you can filter the templates page by any available column, you just need to click on the column to get exactly what you are looking for:

• Updated Menus Design:

We been asked many times which are your menus and which are other products menus within the “Additional” list, therefore we have identified the menus related to the Excel Paste with “DI”:

Hope that this helps.

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 – New Features has been Added!

Following to the requests we are getting from many users, we have added the below functionalities the the product:

Move rows up and down

You can now add your rows and then use arrows to move your record up and down:

Direct Grid Modifications

You can now perform modifications to the product by modifying the grid directly and then click on “Save Grid Modifications” so if you missed up with Excel Column Index for example you can simple readjust the sequence and save:

Download Templates

Few days back we have released the ability to paste the setup directly to the tool, but found this a little bit hard for end users to copy tasks one by one, therefore we have added a new functionality to download templates from the internet directly to your database:

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 Templates

A new version of Microsoft Dynamics GP Excel Paste has been released, but not the one that pastes with header and details, instead we have decided to release “templates support” version until getting the other version ready due to the high demand to get this feature and to reduce the support tasks that been assigned to the support team.

By releasing this version, end users will be able to download ready templates from the following page:

http://di.jo/GPExcelPasteTemplates.aspx

And simply paste the template into the Dynamics GP Excel Paste Setup form as shown in the video below:

Setup Excel Paste Templates

Experts can easily create templates, copy what they have created from the grid to Excel and just send it to me for publishing, this will make users life easier!

Enjoy!

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 Updates

Since the first day I announced the release of the excel paste, I been getting questions and requests from customers who already purchased the tool to do few modifications.

Issues started with unique screens, since the product is totally dynamic and does not have screens statically defined, sometimes few screens might not be effective as required and we been working the last few weeks on catching these screens by following customers requests.

Honestly I didn’t expect this number of requests nor the number of interested customers, which added a big number of helpdesk incidents to cover customers demands and product gaps.

One of the big things we used to get was to include the ability of having “headers” and “details” as a part of the product functionality so end users can paste multiple invoices at once or one invoice with multiple lines and each line with multiple serials, and here the challenge was started!

We been able to dynamically deliver the first part, we have adjusted the product to accept multiple windows by having one to many relation between the header and details lines. Below video might clarify more:

Example on header and details lines in GP Excel Paste

This version will be published soon once it get released from the Quality Assurance team and fine tuning some features, and will keep trying hard to find a solution for items and serials.

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