Adding Customer Item User-defined Fields to SOP Invoice – Mariano


Another excellent post up there on Mariano’s blog, which explains how to add customer item user-defined fields to SOP invoice.

The customization is done using Support Debugging Tool (SDT) to achieve this.

There is an interesting point which Mariano mentions there, which is not about the topic itself, but about how clients have started demanding things from us, consultants, which shows how much clients are aware nowadays.

Modifier with VBA would have been the BEST and easy option for any developer or consultant for this functionality. But looks like the client was strictly against it because *it’s not supported on Microsoft Dynamics GP 2013 Web Client*. 🙂

But that demand indeed had led to another superb piece of customization using SDT.

VAIDY

eConnect Vs GP Web Services – Chris Roehrich


This is an awesome post from Chris Roehrich on Developing For Dynamics GP blog.

The post explains very neatly (and in detail) about the differences between eConnect for GP and Web Services for GP.

And which one to use or not to, is up to you after you read this post. There are some interesting short discussion on the comments section, so do read the comments as well.

That’s an excellent post, Chris. That surely would have answered several questions from users/consultants across the world.

VAIDY

Updated Microsoft Dynamics GP Statement of Direction


I am a bit late in blogging about this, but better late than never. Microsoft has updated the Statement of Direction for Microsoft Dynamics GP.

Some important points worth to be highlighted are:

  1. Preview of Microsoft Dynamics GP 2013
  2. Details about key investments to enhance GP as a product
  3. Updated Product Roadmap
  4. Microsoft Dynamics GP Support Commitment Information

You can download this document from PartnerSource and CustomerSource.

VAIDY

Microsoft Dynamics GP Technical Airlift 2012


This event is going to rock this year, as we are gearing up for the release of GP 2013.

Early Bird registration for Microsoft Dynamics GP Technical Airlift 2012 event is there till 31st July, 2012. More information about this event can be read on David’s post.

I hope to get registered this year, meet those people I admire and follow and learn all important concepts about GP 2013.

Fingers crossed.

VAIDY

Dynamics GP Short Story “The Stakeouts” by Mark Polino


The Stakeouts, is a plain and simple; short and sweet; interesting and intriguing (may I say that?) story written by our private eye, errr, Polino.

Mark, I did read your post “You are a writer…“. But I never thought there would be a story soon. That was quick & great. 🙂

Would love to read a long one from you; well on any topic.

Why not? And when?

VAIDY

Item Decimal Places Currency & Inventory Adjustments


Q: From where does the Inventory Adjustment entry retrieve a product’s Decimal Places Currency value?

A: When we create a product, this value will be defaulted from the Functional Currency of that company. While entering an Inventory Adjustment for this product, the decimal places currency value will then be retrieved from the product master record.

I realized this when I faced an issue couple of days back. I got a requirement where, I have to facilitate an automated program that will replicate a product information (Master, Quantities/Site, Vendors, Currencies & Price List) from one company to another. Of course, with necessary changes that are specific to the destination company.

It worked merrily till both companies had functional currencies with same number of decimal places. I had to extend this program on to another company, whose functional currency supports 3 decimal places. Now you might have realized the issue. My program, quite honestly, was written with a hardcoded value of 2 decimal places.

When I created some products on my new company using this program, I could not enter Inventory Adjustments with 3 decimal places. It was always 2. Upon spending some time on this, I realized what I have mentioned at the start of this post. You cannot override this at all.

So those who write customization like what I have explained above, beware of all such nuances which will play very crucial role in day-to-day transactions.

VAIDY

PSTL is now available (FREE) on PartnerSource


Dynamics GP Support Blog confirms that the Professional Services Tools Library (PSTL) is now available for all, free of cost.

BUT, all Customers should contact their Partners to get this tool. Once installed, it would generate the registration key by default and you are good to use it.

PSTL has been a great tool with top notch features to solve real time issues. With this becoming free to use, customers should make use of this.

VAIDY

Microsoft Dynamics Cloud Services – Some Concerns & My Thoughts


This post is just an extension of what Janakiram (DynamicsBlogger) had posted. Microsoft Dynamics products line (CRM, AX, GP, NAV) are all heading towards Cloud. And Microsoft is quite serious about it for sure.

Janakiram had expressed some doubts (or concerns, if I may say) about this offering.

I would like to clarify these points as much as I can. I just happened to attend Microsoft Open Door Gulf event today and also have been closely watching this area (of Dynamics GP & Cloud model).

According to what I have understood:

1. Microsoft is NOT listing Dynamics GP as PUBLIC CLOUD enabled product at all. Having said that, Microsoft Dynamics GP 2013 Web Client is just a beginning to attract customers towards GP as an ERP. GP had long been considered as a stagnant product in terms of extended functionality or its technology. With this web client, both are now quashed.

Web Client will enable customers to get rid of several H/W & S/W costs. Terminal Server licenses will be immediately abolished, which will certainly save some hard cash for customers.

It also enable Partners top expand their business from being “mere Partners” to “Partners & SaaS Providers”, by allowing them to host Dynamics GP for customers. It’s going to be win-win situation, at least for another 5 years from the time Dynamics GP 2013 is released.

Hybrid Model? YES. That’s because you can have a private cloud on your environment and also you can have desktop clients. You can also have your GP data mirrored to your on-premise server and can have clients accessing that as well. It’s more like your Microsoft Office 365, wherein you can have your email server hosted on cloud and can also have the same being synchronized on your On-Premise server. Decision is up to customers.

Microsoft Dynamics GP Public Cloud is NOT going to be realized anytime soon.

2. Microsoft is not going to abolish the Dynamics Partners model at all (at least for another 10 years). That’s for sure. If you closely watch Microsoft Dynamics business, it’s always been Partners who have driven this and not Microsoft. Microsoft indeed has worked a lot on improving it’s Dynamics products but it’s always been partners who have taken these products to end customers.

Microsoft recently took a clean up act on Partners, by reducing the number of Partners and also downgrading some and also stripping their “Gold Certification”. MSFT also toughened the criteria for anyone to become a Microsoft Partner. This was both condemned as well as praised. Ultimately, the incidents of customers getting a negative impression with Microsoft Dynamics (& Partners) got a bit reduced.

But never did Microsoft take the implementation of Microsoft Dynamics Products from partners. Never ever.

You also have to have a Microsoft Partner to avail the license for any Microsoft Dynamics product. This is true for even Microsoft Office 365 implementation. We, as customers, can never get out of Partners anytime soon.

So Partners need not worry about.

3. Microsoft Dynamics GP has been a great product NOT because it’s great out-of-box. It’s because, it is flexible and can get extended by having proper and correct customizations. It also made easy for a customer to avail a Partner or Freelance Consultants or In-house Consultants to manage their GP environment with so many value added enhancements.

In my experience, I have never seen one single GP implementation without a single customization. Oh yes, there was indeed one, but that was for a Non-Profit company and they used ONLY GP Finance Module (GL, AP & AR) and that’s it. Trust me, that’s all about it.

Till now, GP never had a built-in, user-friendly, technology-friendly reporting tool (no offense intended to Report Writer). It supports external tools such as Crystal Reports, SSRS, etc., but that had to be CODED by consultants/developers to get it work. Not one single GP implementation was done without having to write one single Custom SQL Stored Procedure for any kind of business requirement. It’s not just GP. You take any ERP solution in current market. And you will certainly understand that, without additions, it’s highly impossible.

Why am I talking about this? Because, with cloud hosted GP, there comes several restrictions such as denial of access to SQL Server on which our GP data is going to lie. Oh well, we won’t even know on which server our data is hosted and in which country the server is located AT A GIVEN POINT OF TIME. In such cases, who will take care of extending our business requirements? It’s a big question, trust me.

Till we get an answer to the above question, no customer would ever want to go for a public cloud.

4. Consider that your GP is on cloud now, hosted by none other than Microsoft. Customers will gain A LOT. I mean it. I am a consultant and I still say that customers will gain a lot.

Why? Because they don’t have to worry about upgrades, backups, downtimes, H/W maintenances; well at least theoretically and also by agreement, they don’t have to.

Microsoft has ensured (and also boasting) that the uptime and availability is a staggering 99.99%. Which means A LOT for a customer. IT expenditures on backing up the data, preserving the H/W resources, upgrading H/W resources are all quashed.

As far as support is concerned, the only support that you may have with Microsoft, when you are on cloud, is the non-availability of the service itself. You won’t complain to them about a missing transaction. Worst case scenario, you may miss your entire company data due to a server crash or malfunction happened on their servers.

5. Cloud Services are a BIG PLUS for customers who have an unlimited & fast bandwidth internet connectivity. Not all countries (let alone cities) enjoy this. And this will play huge part on customers’ psyche. There are so many customers who pay for their data usage. For them, on premise cost would be less than data usage cost.

Even for customers who have a faster line connection, the upload bandwidth is still crazily low.

Simply, it’s not always possible for all customers.

Alright, I have much more that I can share with you about this. Above are all my understanding about this Cloud concept in accordance with the product Dynamics GP. I have been working on this product for 8 years now and my thoughts shared above are based on that.

I welcome you all (readers of this blog) to share your thoughts on this.

VAIDY

Microsoft Dynamics GP 10.0 Mainstream Support Ends on 9th October 2012


Those who are on Microsoft Dynamics GP 10, would want to seriously think about upgrading their product.

Microsoft Dynamics GP Support Blog has posted this morning that Microsoft Dynamics GP 10 Mainstream Support ends on October 9th, 2012.

So be aware of this fact and plan for your upgrade at the earliest.

VAIDY

Is GP 15 the last release? Errol Answers, and how!


First of all, thanks so much Errol Schoenfish, for instilling that confidence in all of us (Customers/Consultants/Partners) about the great product Microsoft Dynamics GP.

For those who are confused about this post; about the title; here you go…

From Errol’s own words:

The current Microsoft Dynamics GP Statement of Direction accurately talks about our committment to the product.  Located here.  In the Statement of Direction  we talk about our current release + 1 in detail, while painting a picture of what the future beyond holds.  When asked “Is GP 15 the last release because that’s the last release showing on the roadmap slide?”, I respond with this, “When I started at Great Plains Software in 1987, Dynamics GP 2010 was NOT on the roadmap slide”  🙂

So, once again, thanks Errol. That’s the most convincing answer that anyone could give.

VAIDY