Monday, December 31, 2012

The Dynamics GP Blogster's best articles of 2012

It's that time of the year again! Time to say goodbye to the outgoing year, 2012, and receive the new one, 2013, making all sort of resolutions that we never seem to be able to achieve and with good measure, since most of us are simply consumed with the daily grind that lifting our heads up to take a breather and see the forest from the trees seems difficult and sometimes downright impossible.

2012 however was a very good year and gave me tons of stuff to write about. In retrospect, 3 conferences, 2 virtual conferences, the release of Microsoft Dynamics GP 2013 and the Web Client are simply a subset of the activities that allowed me to write some really cool stuff that you expressed through your comments to enjoy. Without further due, here is a list of the "best articles of 2012" written on this site (in no particular order):

1. Microsoft Dynamics Convergence 2012 Houston. Convergence Houston in March of 2012 was a very cool experience and probably one that I will never forget as I was able to meet up with my good friend David Musgrave and his wife, Jennifer. I also had the opportunity to share some time with some of my customers in attendance. As always, the good part is meeting tons of people and the thrill of presenting.

2. Microsoft Dynamics GP Technical Airlift 2012. In the realm of cool, the Technical Airlift in Fargo, North Dakota was a very awesome conference, but also marked the first time I presented without my compadre, David Musgrave. The Tech Airlift also demanded tons of prep work and was built upon cooperation between Microsoft and GPUG's GPPC and featured a record number of partners in attendance. I also liked the fact that I met up with some of my fellow MVPs.

3. GPUG Summit 2012 Seattle. Seattle has this aroma of coffee mixed with sea all over the city and I have to say the GPUG summit was a very charming conference, with lots of topics for the attending crowd. Seattle, Seattle...

4. Windows 8 and the Microsoft Dynamics GP Web Client Series. Okay, so I confess. I was a nuisance to the Escalation Engineering team testing the Web Client. You see, the Web Client was not supposed to even be working on Windows 8 as a compatible installation platform, but after months of annoying I had my way with this. The best part though was working with the team of Aaron Donat and Jason Lech and understanding the nuances of the deployment process of GP Web Client. Thanks guys for putting up with me and for making this happen.

5. Adding Customer Item User Defined fields to SOP Invoice. I love the Support Debugging Tool and how it can make live easier for things that seem unconceivable. How about this cool article on getting customer item user defined fields onto the SOP invoice? Well, I have to say I had tons of fun getting this to work.

6. How to add a "Cover Letter" page to a Microsoft Dynamics GP Word Template document. Life is not complete without a Word Template article. I hope to keep these coming in 2013 since Word Templates are essential to Web Client.

7. Resizing SmartList panes with the Support Debugging Tool. Now, did I say I love the Support Debugging Tool? David Musgrave leverages some obscure Dex functions to make SmartList a dream tool to use.

8. Leveraging Custom Links to track carrier shipments in Sales Order Processing. You know, I am always amazed at how underutilized GP seems to be sometimes, but my duty as a blogger and consultant is to expose these underutilized features to the community.

9. Microsoft Dynamics GP Add-In for Microsoft Word not enabling despite several attempts to install. I had a number of clients come to me with this issue. Upon doing more research, I realized it was a community wide problem and I had to do something about it.

10. Adding more comment lines to POP Purchase Orders. Building on a previous article written by David Musgrave for SOP, I thought I would show how to accomplish the same in POP - it was all worth it as the community gave praises for the solution.

101 articles throughout the year are simple quite a bit of stuff written. I just hope I can keep the good stuff coming. Happy New Year!

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Wednesday, December 26, 2012

Microsoft Dynamics GP 2013 Features now on Community's YouTube Channel


The Dynamics GP Support and Services team has just released 24 new videos on the Microsoft Dynamics Community YouTube channel focusing on Microsoft Dynamics GP 2013 features. Videos cover all aspects of the application, including the brand new Web Client - 11 videos alone on this subject.

Link to the original article is provided below as it contains link to all 24 videos:

Microsoft Dynamics GP 2013 Features on YouTube - CHECK IT OUT!

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Wednesday, December 19, 2012

Deploying Microsoft Dynamics GP 2013 on Azure - Introduction

Today is the BIG DAY! Microsoft Dynamics GP 2013 has been released!

PartnerSource: Microsoft Dynamics GP 2013 Product Release Download page
Microsoft Download Center: Microsoft Dynamics GP 2013 What's New


With that said, I wanted to move forward and start to look at some really cool stuff you can do with Microsoft Dynamics GP 2013 and the Web Client. Now that I've had a chance to deploy the Web Client on a number of sandboxes here in my test lab and pretty much have all the on-premise deployment down, it's time to show you one more cool stuff: Microsoft Dynamics GP 2013 and Web Client deployment on Microsoft Azure platform.

Windows Azure is an open and flexible cloud platform that enables you to quickly build, deploy and manage applications across a global network of Microsoft-managed datacenters. You can build applications using any language, tool or framework. And you can integrate your public cloud applications with your existing IT environment. The overall goal of Windows Azure is to provide a scalable PaaS (Platform as a Service) and IaaS (Infrastructure as a Service) to subscribers.

Examples and SDKs are available in the Developer Center at

http://www.windowsazure.com/en-us/develop/overview/.

Microsoft Dynamics GP 2013 Azure Deployment

A Microsoft Dynamics GP 2013 deployment on Microsoft Azure focuses on 4 main aspects (assuming you have already completed all the sign up and subscription process):

  1. Provisioning a virtual network, which can be optionally integrated to your local network.
  2. Provision an Active Directory Domain Controller to manage the virtual network environment. (optional depending on whether you integrate the virtual network to your local network or not)
  3. Provisioning the different virtual machines to support the IIS web server, Web Client, and Web Management Console applications; the various services (Session Central, Session Service, Tenant Services, and the GP Web Services) if deploying each service on separate servers; and the session hosts virtual machines to host the Microsoft Dynamics GP runtime client.
  4. Provisioning a Microsoft SQL Server 2012 virtual machine and storage to host the various company and system databases and deploy a Reports Server.

NOTE: SQL Server 2012 will need to be reconfigured to support SQL authentication. The standard galleries provided on the Azure platform are configured by default to support Windows authentication. SQL Azure is currently not supported with Microsoft Dynamics GP 2013 on Windows Azure.

A simple Azure deployment environment is shown in the above picture.

Once the environment has been provisioned, the Microsoft Dynamics GP installation process is fairly comparable to that of an on-premise installation. The installation process will start by installing Microsoft Dynamics GP desktop client on the web client server (or on the SQL Server) and running GP Utilities to set up the databases. The installation is done via Remote Desktop Client which is used for management of the environment only.

Up next is the installation of the web client and web management console applications on the IIS web server. An endpoint will need to be created using the Azure Management Portal for Internet access to the virtual machines. Upon completing the deployment of the Azure environment, access to GP is achieved via Internet Explorer from outside the Azure virtual network.

This is just the proverbial tip of the iceberg. In the next few days, I will be whipping out the credit card to setup an Azure subscription and walk through all the different provisioning steps and the Web Client installation process. I will detail all of these in a series of articles to come.

Special thanks to Daryl Anderson, Senior Program Manager and Aaron Donat, Senior Escalation Engineer at Microsoft for their input and editorial contribution to this article

Downloads

Microsoft Dynamics GP 2013 and Windows Azure (D109GPandAzure.pptx)

Resources

To read more about Microsoft plans for the Dynamics applications and Azure, click on the following link over at MSDynamicsWorld:

Microsoft Shares Updated Azure Plans for Dynamics NAV 2013, GP 2013, AX

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Thursday, December 13, 2012

Microsoft Dynamics GP 2013 Released to Manufacturing (RTM)

12/12/12 only comes once in a lifetime - at least in our lifetime - and whether the Microsoft Dynamics GP Development team believes in superstitions or not, the fact is they worked against the clock to deliver the product to manufacturing yesterday. By the way, the Development team spent a whopping 78,000 hours building the BIGGEST RELEASE EVER! of Microsoft Dynamics GP.

Microsoft Dynamics GP 2013 RTM commemorative banner
What started out as the lone idea of a developer has now crystalized into tens of thousands of hours building the most notable feature to be delivered with Microsoft Dynamics GP 2013: the Web Client. I had the distinct pleasure as a Microsoft Dynamics GP MVP and partner to participate in the beta testing process and I have to say I am very proud to have worked with some of the most talented individuals one could wish to meet.

In the process, I learnt a great deal about the development considerations, product architecture, deployment, and troubleshooting. I also learnt heaps about the 140+ features that went into the new release as well. In other words, even if there was no web client to be had with Microsoft Dynamics GP 2013, you still would have the single most comprehensive set of enhancements released to date.

Microsoft Dynamics GP 2013 will be made available to the general public on December 19. The question is, are you ready?

Be this the chance to invite you to a Microsoft Dynamics GP 2013 webinar hosted by IntellPartners on December 20, 2012. In this webinar I will be talking about Microsoft Dynamics GP 2013 features and technology and considerations for upgrading. If you are interested, please add a comment to this article with your email address. In return, I will send you instructions for joining the webinar.

Read more about Microsoft Dynamics GP 2013 shipping over at Inside Microsoft Dynamics GP.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Microsoft Dynamics GP 2013 "Feature of the Day" - Week 20 & 21 Digest


Well, we knew this moment was coming. The "Feature of the Day" series at Inside Microsoft Dynamics GP is over as Microsoft Dynamics GP is now released to manufacturing (RTM). The end of this series marks tens of thousands of hours of work that went into making this THE BIGGEST RELEASE EVER in the history of the product. Enjoy the final set of features.

Feature of the Day: Manual Prepayments

Purchase Order Entry: Prepayment Amount field

Purchase Prepayment Entry window: Manual Payment option


Manual Payment Posting Journal

Original article: Feature of the Day: Manual Prepayments
Link to presentation: GP2013 Manual Prepayment.ppsx
Learning script: Purchase Order Computer Prepayments


Feature of the Day: Web Client

Web Client

Original article: Feature of the Day: Web Client
Link to presentation: GP2013 FOD Web Client.ppsx


Feature of the Day: Web Client User Interface

Web Client User Interface

Original article: Feature of the Day: Web Client User Interface
Link to presentation: GP2013 FOD Web Client UI.ppsx


Feature of the Day: Web Management Console

Microsoft Dynamics GP Web Management Console

Original article: Feature of the Day: Web Management Console
Link to presentation: GP2013 FOD Web Management Console.ppsx

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Thursday, December 6, 2012

Microsoft Dynamics GP 2013 "Feature of the Day" - Week 19 Digest


By now, you are aware that the planned release date for Microsoft Dynamics GP 2013 is December 19, 2012. As such, the "Feature of the Day" series will be concluding soon. Inside Microsoft Dynamics GP brought 4 more features last week, ranging from HR/Payroll to Encumbrance, to Purchase Order Processing and Payables Management.

Feature of the Day: FICA Tax Sheltered Annuity Changes

Deduction Setup window

Employee Deduction Setup window


Original article: Feature of the Day: FICA Tax Sheltered Annuity Changes
Link to presentation: GP2013 FOD FICA Medicare and Social Security TSA.ppsx

Feature of the Day: Encumber General Journal Transactions

Encumbrance GL Transaction Entry and Journal Inquiry

Original article: Feature of the Day: Encumber General Journal Transactions
Link to presentation: GP2013 13740_GL Encumber FOD.ppsx

Feature of the Day: PTO Detail & History and PTO Exception Reports

PTO Detail & History Inquiry

Original article: Feature of the Day: PTO Detail & History and PTO Exception Reports
Link to presentation: GP2013 FOD PTO Detail - History and PTO Exception Report.ppsx

Feature of the Day: Computer Prepayments

Purchase Order Entry / Payables Batch Entry / Receivings Transaction Entry

Original article: Feature of the Day: Computer Prepayments
Link to presentation: GP2013 Computer Prepayment.ppsx

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Resizing SmartList panes with the Support Debugging Tool

I have a secret to tell...

At the past GPUG Summit in Seattle, I presented a session,  ITP16 Advanced Microsoft Dynamics GP Administration with the Support Debugging Tool. The session concluded with a demo of the Splitter Control feature implemented with the all too popular Support Debugging Tool. The few individuals in attendance were very impressed, since SmartList resizing had always been a royal pain in the rear for them.

If you have been following the Developing for Dynamics GP blog lately, my dear friend and partner of many presentation battles, David Musgrave has now detailed the secrets of the Splitter Control and provides the code to implement it using the Support Debugging Tool.

SmartList with the Splitter Control (shown inside the red circle)

The Splitter Control uses some cool unsupported Dexterity features so please play with this stuff in a test environment. IF you find anything cool or uncool about it, and you would like to express your feelings, please add your comment to David's article:

Update: Resizing SmartList TreeView and ListView panes using the Support Debugging Tool

Finally, there's no similar control in Silverlight for this Dexterity feature so this will not work with the Microsoft Dynamics GP 2013 Web Client.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Microsoft Dynamics GP 2013 Release Date

Couple days aback, Microsoft announced the planned release date for Microsoft Dynamics GP 2013, in a combined press release which included updates on Microsoft Dynamics AX and Microsoft Dynamics CRM.

Microsoft Dynamics GP 2013 Release Candidate 0 build

Of interest to this community, of course, is the target release date of Microsoft Dynamics GP 2013, which has been planned for December 19. As we all know, plans can change, but bar some major issue, we should be seeing RTM pretty soon. Currently, Microsoft is testing Release Candidate 0 (build 12.00.1273) and is probably getting prepared to compile a new build for partners in the beta program.

Still not ready? Take a look at my article 5 Ways to Prepare for the Microsoft Dynamics GP 2013 Web Client over at MSDynamicsWorld (free registration required). Other resources to help you get there can be found on this blog and on the Inside Microsoft Dynamics GP blog's Feature of the Day series.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/