Web Client with Multiple GP Instances

I got a case on my server where I wanted the web client to work with different GP instant not the default, people start asking me you have multiple instances of Dynamics GP 2013 on your server!?! Yes I have installed the product 9 times with 9 different application instances and all are on the same SQL instant! This is what I liked with this version.

However, as I understood from the Dynamics GP Community, the web client is like the Dynamics.exe but on the web, meaning all application objects are to be loaded from the folder and the Dynamics.set will be called.

Hence, there must be somewhere to give the web client the path of the GP folder and it was there, I have noticed an XML file in the following path:

C:\Program Files\Microsoft Dynamics\GP Web Client\GPweb

File name is TenantConfiguration.xml, below is the content that explains itself:

<?xml version="1.0" encoding="utf-8"?>
<TenantConfiguration>
  <Tenants>
    <Tenant Name="GPWebApp">
      <Description>Microsoft Dynamics GP 2013</Description>
      <RuntimeApplicationDirectory>C:\Program Files (x86)\Microsoft Dynamics\GP2013\</RuntimeApplicationDirectory>
      <SetFile>C:\Program Files (x86)\Microsoft Dynamics\GP2013\Dynamics.set</SetFile>
      <DexIniFile>C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data\Dex.ini</DexIniFile>
      <HeartbeatTimeout>0.20:00:00</HeartbeatTimeout>
    </Tenant>
  </Tenants>
</TenantConfiguration>

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

Changes to GP2013 that should be considered by ISV’s

I been working the last few days hard to discover the new changes Microsoft made on GP 2013 desktop version and the web client and went through the application architecture to understand how will our solutions work among new application features and below are my initial findings:

1. Starting from GP 6.0 or maybe before, we used to know a fact that DYNAMICS database is constant and will never be changed, therefore we used to use this name statically in our code, starting from this point you no longer able to set this statically and will need to find an alternative.

2. As long as the Dynamics database we also used to know that the Sample company database was always named “TWO”, now it might be anything! Therefore you will need to query the SY01500 table with company ID of –1 to get the Intercompany ID and know the database name accordingly.

3. Working with GPConnNet wasn’t changed, however you still need to find a way to test the connection by using the Intercompany ID instead of querying the DYNAMICS database and shown on the examples, you can use “Dynamics.Globals.IntercompanyID.Value” from your development platform to retrieve this.

I will keep posting my findings!

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 2013 - Additional Core New Features

New Look and Feel! I liked the new look for the home page, customizable and more user friendly:

Reconcile to GL - Banks and Inventory was added! This is my favorite area, I been engaged in many assignments to reconcile modules to GL and suffered hard times!

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 2013 - Named DYNAMICS Database

In all previous versions, we used to created a separate SQL instant for each customer when doing a test environment on our servers, this makes working with multiple customer annoying! Check the below change in GP 2013:

NOTE: Database name must be less than 10 characters!

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

Dynamics GP 2013 Installation - Where is the Analytical Accounting??

 

I been unable to wait for the next week to start testing! I started the installation this morning and below the first change I notice, Analytical Accounting is now integrated with Fixed Assets and cannot be installed with having the Fixed Assets installed:

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

Dynamics GP 2013 – Beta Version has been released!!!!!

 

Microsoft Dynamics GP 2013 Beta Version has been released, go ahead a download your test version from the link below, while I am so excited to install and test, but I will be pushing myslef to publish my findings next week as I am going to relax this weekend!

https://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/MDGP2013_TAPReleaseDownload

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