The Dynamics GP Blogster

I'm completing the deployment of Microsoft Dynamics GP 2013 R2's Project Accounting and Time Entry approval workflow for a customer in Alabama who is currently deploying web client for extranet access (and timesheet entry) and desktop client for intranet access. As a result, since time entry employees are remote, we decided to setup these user accounts as web client only. However, the customer wanted to provide an alternative to the web client in case it became unavailable. This meant that these users would needed the ability to access the Microsoft Dynamics GP desktop client via a Terminal Server provisioned (albeit temporarily) to support this goal. The Problem To meet this requirement, we needed to adjust the user accounts in Dynamics GP to also support SQL Server authentication (in addition to web client access), by deselecting the Web Client user only  check mark and completing the SQL Login credentials information. Upon attempting to save the changes we received the...

Hello all! It's been quite a while since I've actually written anything of remote interest to anyone who follows my blog, but at the same time, you will be pleased to know that I've been quite busy in the consulting front, with upgrades, server migrations, complex multi-instance postings involving 10's of thousands of transactions, wrapping up some Field Service Automation projects, and the list goes on and on. This time around I want to bring to the forefront, an issue I encountered updating  from Microsoft Dynamics GP 2013 SP2 to Microsoft Dynamics GP 2013 R2 plus the latest service pack. Background My client requested a server migration to a new environment where they wanted to deploy Dynamics GP 2013 R2 web client (plus the latest service pack) and upgrade their relational database management system to Microsoft SQL Server 2014. This is something I'm absolutely comfortable with (for the most part) given also that my client was sitting at Microsoft Dynamics...

Hey, not that this concerns anyone, but finally here is the wrap up post for the Convergence 2015 event. It's really been a busy couple of seasons for this writer (not that I'm complaining!), so I have had to opt for work instead of blogging which I'm sure you will understand as a reader. Microsoft Convergence Atlanta 2015: GPPC PreGame Microsoft Convergence Atlanta 2015 (#CONV15) - Day 1 Microsoft Convergence Atlanta 2015 (#CONV15) - Day 1 Continued Microsoft Convergence Atlanta 2015 (#CONV15) - Day 2 Microsoft Convergence Atlanta 2015 (#CONV15) - Day 3 Microsoft Convergence Atlanta 2015 (#CONV15) - Day 4 Other entries on the event, from my good friend David Musgrave : #CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame #CONV15 – Convergence 2015 Atlanta – Day 1 – Opening Keynote #CONV15 – Convergence 2015 Atlanta – Day 1 – Dynamics GP Session #CONV15 – Convergence 2015 Atlanta – Day 1 – Continued #CONV15 – Convergenc...

Phew! How about that OneRepublic concert ? Day 4 is finally here and with it, all good things must come to an end. For a change, today David and I managed to make it down to the GWCC on time and had a fairly relaxed breakfast at the Meal Hall to then move over to the Phillips Arena for one very interesting closing keynote. As customary, an energetic Judson Althoff , President Microsoft North America welcomed the crowd to the event and proceeded to recap the week and what will be seen from Microsoft in the coming months. Judson Althoff, President Microsoft North America The first thing in his opening was to remind the audience how Convergence is becoming the premier event for business and that Microsoft, at its core, is " the productivity and platform company for the mobile first, cloud first world " and how the company is thinking about innovation and technology. Althoff then introduced the upcoming events, Microsoft Ignite  which is geared to showcase innovat...

Ok, I'm officially tired! Day 2 did not leave much room to sleep with a presentation, expo, dinner, and Rock-n-Rave (even though I did not stay long). However, today I had to gut it out for our repeat session, CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface , which was scheduled for 11:00 AM. CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface Mariano Gomez and David Musgrave We had 64 people in our session and really had an enthusiastic crowd despite the Rock-n-Rave precedent. The session went on as planned and we feel we had a bit more organization in our delivery. Once our session finished, I ran off to Kevin and Dan's session,  CS15G014 - Leveraging Microsoft Dynamics GP 2015: Service Based Architecture for better integrations . Kevin Racer and Dan Lothspeich This session was truly informative as Kevin and Dan walked through the evolution of the work environment and how it has been impacted by the ever increasin...

Wow, Day 1 sure proved to be very exciting with all the big keynotes, general sessions , and presentations , not to mention the whole Expo reception. It also seemed like the night went by flying and sleeping was overrated. To add to the mix, Atlanta's Tuesday morning traffic came back with a vengeance and did not really allow David and I to make it down on time for some early sessions we had planned to attend, oh well! As a result, we ended up going to the Speakers' Room to finalize our last bits of demo code for our upcoming session, only to discover we were not using "best practices" as noted by our Microsoft friend Rob Bernhardt . Since we are very keen to deliver best practices in our Service Based Architecture code (more on this on a separate post). This put us in a tailspin, so we went looking for Kevin Racer to offer some advise. We finally got what we were looking for, just 10 minutes before our session. Off we went to look for our dual A313/314 room ...

Day 1 - Afternoon After the Keynote and General Session , it was time for lunch and trying to catch up with friends. It never ceases to amaze me the logistics required to sit and feed 12,000 people at any giving time. Just making sure everyone has a place to sit or even the kind of food they like is got to be an incredible task. Crowd heading for lunch at the Meal Hall After getting my food, I went to sit at the table with some very distinguished folks in the community - in the meantime, David was off trying to get something that won't upset his tummy. As you may or may not know, my good friend troubles with MSG intolerance (and associated flavor enhancing glutamates), which makes his daily food intake an exercise in patience and careful negotiation with restaurant staff and chefs. From left to right: Beat Bucher (Forensic Technology), Kim Peterson (GPUG), Mark Huff  From left to right: ?, Frank Heslin, and MVP Belinda Allen After lunch, it was time to go v...