Posts

Showing posts from January, 2013

Microsoft Dynamics GP 2013 on Windows Azure: The Deployment Process

Image
Welcome to the third installment on Microsoft Dynamics GP 2013 on Windows Azure. In the previous article I showed how to provision the various VMs needed in our environment - see Microsoft Dynamics GP 2013 on Windows Azure: Provisioning Process . The following is a summary of the VMs with the applications and services they will be running: Server Name Function ip-ads01 AD DS server ip-sql01 Database Server ip-gp01 GP and Session Service ip-gpweb IIS, Web Client, WMC, and Session Central The deployment started out with some prep work, as follows: Active Directory Server (AD DS) On the AD DS server, I setup a few domain user accounts and security groups that will be needed to run both Microsoft Dynamics GP's Session Service and Session Central Service services on the GP server ( ip-gp01 ) and the Web Client and Web Management Console application pools on IIS ( ip-gpweb ). In addition, I have created two se

Why I go to Convergence

Image
The folks at Microsoft thought that it would be a good idea to ask me why I keep going back to Convergence . Take a look: Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/

Listing all eConnect Modified PRE and POST stored procedures

Image
As of recent, I was ask of a simple method to determine which eConnect PRE and POST stored procedures had been modified. After all, with a concrete list, you are able to script just the affected ones prior to a major version upgrade or a feature pack installation. A modified stored procedure could be simply qualified as one on which you have ran an ALTER PROCEDURE statement or have edited it using SQL Server Management Studio. With that said, the following query may not be failsafe, but provides a very accurate way of getting a list. -- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons -- Attribution-NonCommercial-ShareAlike 3.0 Unported License. -- http://creativecommons.org/licenses/by-nc-sa/3.0/legalcode -- SELECT name, create_date, modify_date FROM sys.objects WHERE (type = 'P') AND (name LIKE 'ta%Pre' or name LIKE 'ta%Post') AND (create_date <> modify_date) Enjoy! Until next post! MG.- Mariano Gomez, MVP

Microsoft Dynamics GP 2013 on Windows Azure: Provisioning Process

Image
Welcome to the second article on Microsoft Dynamics GP 2013 and Windows Azure of this installment. In the first installment, I showed how to create an Azure account and setup a subscription - see Microsoft Dynamics GP 2013 on Windows Azure: Subscription Process . This time around I will review the virtual machines (VMs) provisioning process. For all intends and purposes, this environment will consist of an Active Directory Domain Server (AD DS), required to support authentication within our Azure environment; a Microsoft Dynamics GP application server, which will serve as a session host, therefore running GP and the Web Client Runtime; a Microsoft SQL Server database server, which will host the GP databases, the Web Management database, Session Central database, and Tenant Services database; and finally, a web server running IIS to support the Web Client itself along with the different session services required to run our web application. For more information on Microsoft Dynamics

Microsoft Dynamics GP 2013 Web Client Phase I details

Image
Over at Inside Microsoft Dynamics GP , Pam Misialek (Twitter: @PamMisialek ) details what Microsoft Dynamics GP 2013 modules and features are available with the Web Client. Web Client System features At the System series level, here is a list of items to consider: Modifer changes will render in the Web Client. Modifier itself is not in the Web Client. VBA code will not run on the Web Client. Excel Reports work if you are connected to the domain. Excel Report Builder and Drill Down Builder are not in the web client. Business Analyzer is on the home page. It is not on the Navigation List Pages Not available in the Web Client: Field Level Security Integration Manager Payment Services Concur Expense Excel Based Budgeting Creating Analysis Cubes Reports.   Web Client Financials features At the Financials series level, most features are available with the exception of Grant Management. Web Client Distribution features The Distribution modules feature all mo

Microsoft Dynamics GP 2013 on Windows Azure: Subscription Process

Image
In my previous article, I provided an intro on the necessary elements required to deploy Microsoft Dynamics GP 2013 on Windows Azure - see Deploying Microsoft Dynamics GP 2013 on Azure - Introduction . Now, I begin a series of articles showing step by step how to configure the platform. The first thing you will need to do is setup a subscription. As it turns out, Microsoft is running a 90-day free trial , how about that? The free trial allows you some good room to get a couple servers required for setting up a Microsoft Dynamics GP 2013 session host and the Web Client. Storage is set currently at 35 GB, so I believe we have plenty room to play. So on we go by clicking the Free Trial option, which takes us to the Sign In page. Authentication is done via your Windows Live account, so one is effectively required. Don't worry! Even if you haven't signed into Windows Azure before, you will be prompted to follow the account creation process. You will now be able to see wh

How to delete a fiscal year that was incorrectly created

Image
Well is that time of the year again... Most of you are in the midst of closing 2012 and getting Microsoft Dynamics GP configured for fiscal year 2013. If you are in this process of closing 2012, make sure to check out the Year-End closing procedures series over at the  Microsoft Dynamics GP Support and Services team blog: Microsoft Dynamics GP Year-End Closing Blog Series 2012 Schedule!! The past few days however, I have had to address a number of calls asking for a little help deleting fiscal years that have been setup incorrectly. The following screenshot illustrates one of such issues: Fiscal Periods Setup window For the most part, users enter the correct start and end dates for the period, but mistype the fiscal year, which can cause a lot of headaches since there's no Delete button to remediate the situation. In addition, if the year is changed to 2013, the system will not allow you to create a new fiscal year with the start and end dates of a previously setup fis

Microsoft Dexterity Training Roadshow - Atlanta

Image
Don't miss this excellent Microsoft Dexterity training opportunity in the beautiful city of Atlanta, from January 21 - 25 at our midtown facilities. You can find full registration information here  or you can contact Chuck Boyles . Other cities and schedules available. (C) Chuck Koehler Seating is limited so please sign up now. Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/