Convergence proves again that GP is still the very best mid market ERP available

Convergence in New Orleans: 11,000 people, 4 days, extreme working hours, no sleep,  1000 smiles, some new friendships and way too many beverages.

My big take away from New Orleans this year is that there is absolutely no doubt that Microsoft Dynamics and specifically GP and CRM provide one of the very best mid market solutions available. Here are a few of my thoughts as to why I reach that conclusion:

1. GP is experienced and has been around for ever meaning it is tried, tested and an extremely solid solution. Fully functional and relatively bug free.

2.  GP customers just love it.  Some folk seem to be even too passionate (a little over the top) about their software! I met thousands of customers that think their GP solution is just awesome. I want to clarify this a little – as every one of the people that love GP – put a lot of effort into making it work to suit their business. They invest time and effort into their systems and use it to do way more than just basic accounting functions.  If you want any software solution to do everything for you without putting in an effort – you will be sorely disappointed no matter how much software you purchase. ERP and CRM is complex, must be configured, must be maintained and most of all must be deeply understood if you are going to reap the benefits.

3. WebClient.  I believe that too many people are getting hung up in the cloud. That said – the new GP web client is providing access to critical ERP functionality via a browser for those that need it. Microsoft are sinking plenty of dollars into this as the delivery mechanism for GP.  CRM already has a world class browser and cloud delivery.

4. Mid Market Flexibility: The happy clients I met were not small businesses. These companies are mid to large enterprises with complex needs, complex solutions and clever people to deliver them.  Many of these companies were amazed at the value for money they receive vs a large scale SAP type ERP solution. If you are a small company wanting a generic solution that does your accounting  – then GP is probably not for you. (go and buy NetSuite).

5. ISV community: Some call this a downside, I belive it is awesome. The ISV development community for GP and CRM is deep, experienced and passionate. This community is the envy of most other ERP solutions. The ERP that tries to build in functionality to fit every situation ‘ is really dreaming’. The knowledge required to truly nail these more niche solutions is something that a large ERP solution (including Microsoft) can not and do not possess (leading to half baked software releases).  If you need some extra functionality – there is an App for that.  These ISV have been around for a long time and have deep domain knowledge in their chosen solutions. They all integrate seamlessly and closely with Microsoft Dynamics.  (especially as more of htem take on SmartConnect as the integration tool of choice).

6. Ease of Integration:  Every business has some very business specific solution in place. It might be a point of sale system, a transaction website, an industry specific CRM or billing engine, warehouse or any number of point software solutions. This makes GP the back end core for all these systems – and with tools like SmartConnect it becomes a very simple process to integrate data in and out.

7. Clever hard working people:  This is perhaps the best the most important factor – the people I met were smart, they had good ideas, were creative and knew how to get things done. Software is no use to anyone unless it fits into the daily process of your business, and that’s where people fit in.

 8. Community: the willingness to both learn and share was amazing. Groups like GPUG (GP user group) do an amazing job in connecting people who are working on the same types of businesses with similar needs and similar solutions.  Learning from others and learning their lessons the easy way is just super.  Other ERP solutions I look at would do anything for a strong user community like GP and CRM has.

You will notice that many of the points above are about people rather than technology. The GP technology is current and as good an anything in the market – but it is the people that make it a success. I for one – will continue to invest my money in  my business building solutions for the Dynamics range. There is a long future for GP, and other products will come and go while creating a buzz, but GP will remain a technology leader with the best network of people supporting it.

Follow this link:
Convergence proves again that GP is still the very best mid market ERP available

April 4, 2013 · Martin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 182

T-SQL 2012: CHOOSE and IIF



We’ve been needing these two features for a long time. This post includes a couple of easy examples showing how these functions work.


I’ll start with CHOOSE. By using CHOOSE you can do away with many tedious CASE statements. CASE statement opportunities are everywhere in Dynamics GP. For instance, how many times have you needed to display the document type in your report and want a word, not a number. Prior to SQL 2012, we would have written a CASE statement that would look a lot like this:

    when 1 then ‘Quote’
    when 2 then ‘Order’
    when 3 then ‘Invoice’
    when 4 then ‘Return’
    when 5 then ‘Back Order’
    when 6 then ‘Fulfillment Order’
    ELSE ‘Undefined Document Type’
End as ‘ Doc Type’

CHOOSE will pick the value in your list according to the value of your data. It returns the expression at a specific index. So, instead of writing a case statement, you can simply write this:

CHOOSE (SOPTYPE, ‘Quote’, ‘Order’, ‘Invoice’, ‘Return’,
‘Back Order’, ‘Fulfillment Order’) AS DocType

If the value of your index is greater than the number choices, it will return NULL. It will also return NULL if the value is less than 1.


Next is IIF. Most of you probably already know how to use this and have wondered why you couldn’t do it in T-SQL. Flavors of this are in Excel formulas, Access calculations and even VBA, to name a few. It works with a Boolean expression and returns a value based on whether the expression is true or false. You set this up with three parameters. The first parameter is the expression you’re evaluating, the second parameter is the value if the expression is true, and the third parameter is the value if the expression is false. Yep, just like Excel.

So here’s what it looks like:

IIF(boolean_expression), value if true, value if false)

So much easier than CASE.

Until next post!


View original post here:
T-SQL 2012: CHOOSE and IIF

April 3, 2013 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 279

T-SQL 2012: LAG & LEAD

I’ve just started playing with SQL 2012 and wanted to show you the new LAG and LEAD features.

I’ll use the report below as an example. Suppose you needed to generate a report that showed the last three years of sales. The result set would need to look something like this:

Lag and Lead

LEAD looks ahead the specified number of rows from the current row, and LAG (you guessed it!) looks behind the specified number of rows from the current row. By using the OVER clause you can specify your grouping (partitioning) and sort order.

Using SQL 2012 you can easily accomplish this using the following SELECT statement:

   year(docdate)  AS ‘Order Year’
  ,SUM(SubTotal) AS ‘Current Yr Sales’
  ,LAG(SUM(SubTotal), 1, 0) OVER (ORDER BY YEAR(docdate)) AS ‘Last Year Sales’
  ,LAG(SUM(SubTotal), 2, 0) OVER (ORDER BY YEAR(docdate)) AS ‘Year Before Last’
  ,LAG(SUM(SubTotal), 3, 0) OVER (ORDER BY YEAR(docdate)) AS ‘Three Years Ago’
  ,LEAD(SUM(SubTotal), 1, 0) OVER (ORDER BY YEAR(docdate)) AS ‘Next Year’

Have fun with it!

Until next post!


Read more here:
T-SQL 2012: LAG & LEAD

April 3, 2013 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 314

Microsoft Dexterity Training Roadshow – Next Stop: Seattle

(C) Microsoft Corporation

The Microsoft Dexterity Training Roadshow rolls around the United States with its next stop in Seattle, Washington from April 22 – April 26, 2013.

We still have plenty of seats left, so if you want to learn some of the development techniques used by Microsoft Dynamics GP developers this is your chance. For registration information, click here.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Original post:
Microsoft Dexterity Training Roadshow – Next Stop: Seattle

April 3, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 198

Dexterity Training in Dallas, Texas, USA (17th to 21th June 2013)

Dexterity - Click for blog homepageIf you are new to Microsoft Dynamics GP development or have been working only with Visual Basic for Applications (VBA) or Visual Studio Tools, or even if you dabble in Dexterity, but have not had formal training, now is your chance to get properly trained in Dexterity.

Dexterity is the native development environment for Microsoft Dynamics GP and the only development/customisation tool that is fully supported on the Microsoft Dynamics GP 2013 Web Client. Even if you don’t plan to develop in Dexterity, understanding Dexterity and how Dynamics GP windows are constructed is invaluable knowledge when working with the development tools other than Dexterity.

So, my friend Leslie Vail is running a class in her home town of Dallas, Texas, USA.


Please see her post on the Dynamics Confessor Blogspot for all the details:


If you need more reasons to attend Dexterity training have a look at list of reasons on my post from last year:


Also see Mariano Gomez‘s post on The Dynamics GP Blogster site for the details of the training roadshow he is running, there are still a number classes planned for various locations (inside and outside of the US):


Take advantage of these great opportunities to be trained by two of the best instructors out there.


Read the original:
Dexterity Training in Dallas, Texas, USA (17th to 21th June 2013)

April 3, 2013 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 188

Tech Tuesday – Calculating Dates Using Scripts

This week we’re going to look at a couple specific scripts dealing with how to determine dates in SmartConnect. The first one will show how to get the last day of the previous month, and the second will show how to get the last day of the current month. The second script involves an extra step, but using these as a basis you should be able to get any other day you need as well.

Last day of the previous month:

 Dim myDate As DateTime = Date.Now.ToString(“MM/01/yyyy”)

 myDate = myDate.AddDays(-1)

 return myDate

The first thing we do in this script is declare the variable to hold the date, along with assigning it a value. Date.Now gets the current date, but we throw a format onto it in order to modify the date its generating. MM/01/yyyy in the format means we grab the current month and year, but the day is hardcoded to the value 01.

So if we ran the first line of code anytime during this month it would generate 04/01/2013. The second line then is simply setting that date equal to itself minus 1 day, which ends up being the last day of the previous month. By calculating it in this manner we don’t have to worry about whether the previous day had 30 or 31 days (or 28), we let the .Net framework take care of that for us.

Last day of the current month:

 Dim myDate As DateTime = Date.Now.ToString(“MM/01/yyyy”)

 myDate = myDate.AddMonths(1)

 myDate = myDate.AddDays(-1)

  return myDate

This second script adds one extra step to the process. We are able to add and subtract months the same way we can with days on any date we have. So before we subtract a day, we add one month to the date so that it will end up being the last day of the current month.

Hopefully these scripts help out when creating new integrations where we need to calculate a date separate from what is in the source file. Using these, you could easily modify them to get the first day of the month or any other day you needed.

Chris Hanson
Senior Technical Consultant

Continue reading here:
Tech Tuesday – Calculating Dates Using Scripts

April 2, 2013 · Abbey · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 172

Relive Convergence 2013 Content on Connector … – MSDN Blogs

Dynamics GP partner blog on Connector. Series of posts specific to the Dynamics GP to Dynamics CRM 4.0 integration and points out several great areas to think about before implementing your Connector integration.

See more here:
Relive Convergence 2013 Content on Connector … – MSDN Blogs

April 2, 2013 · CharG · No Comments
Tags: , , ,  · Posted in: Blogs I Follow Total Views: 171