Page 8 of 26« First...45678910111213...2025...Last »

Microsoft Convergence New Orleans 2013: Wrap Up

Convergence is over and I am now back to the daily grind. However and as is customary, this wrap up post serves as a venue to provide some insight into this past event, links to all posts, and of course, suggestions for the next.

First and foremost, a big thank you goes out to my friends at Microsoft for inviting me to this year’s Convergence event as a speaker and presenter at the General Session. This is probably one of the highlights of my career in the channel. In particular, I want to send out a big shout-out to the following folks (in no particular order):

  • Aaron Donat, for accepting the co-presenter role with me at GPPC’s PreGAME and to help me in continuing building my understanding and knowledge of the Web Client.
  • Pam Misialek, for all her guidance throughout the process leading up to the General Session presentation.
  • Kevin Racer and Daryl Anderson, for inviting me as a co-presenter in our session CSGP32 – Microsoft Dynamics GP 2013 Web Client For Smaller Companies. Sorry I came down ill on our first go around, but hopefully the second time was great.
  • Errol Schoenfish, for his great introduction of Mark and I and the duel we were about to engage in.
  • Chad Sogge, for his participation at the MVP Breakfast
  • David Musgrave, for his patience in preparing me for the Support Debugging Tool session and for dedicating a great deal of time in making the pre-build 18 release available for the session.

I can’t thank the rest of you at Microsoft enough for your continued camaraderie and support: Jay Manley, Jennifer Ranz, Theresa Nistler, Brian Meier, Sivakumar Venkataraman, Jared Hall, Brian Roney, Sarah Purdy, Kelly Youles, and the list goes on and on, so please forgive me if I omitted your name here. You all contributed to making this a great Convergence for me and my wife.

Special thanks to Brian Graftaas for conceding some time on his busy Convergence calendar to talk about the Certified for Microsoft Dynamics program.

Outside of Microsoft, I would like to extend a big thank you to Kim Peterson and Andy Hefer at DynamicCommunities for inviting me to GPPC PreGAME as a presenter, MVP Mark Polino for accepting the challenge of presenting with me at General Session, though we only had a few hours to rehearse in person, MVP Jivtesh Singh for his guest appearance during my session CSGP30 – The Microsoft Dynamics GP Support Debugging Tool,

Now, the links…

On this site, you can find coverage of Convergence using the following links:

Microsoft Convergence New Orleans 2013 – Getting there

Microsoft Convergence New Orleans 2013 : GPPC PreGAME

Microsoft Convergence New Orleans 2013: Day 1

Microsoft Convergence New Orleans 2013: Day 2

Microsoft Convergence New Orleans 2013: Day 3

Microsoft Convergence New Orleans 2013: Day 4

You can always take a look at some of the pictures I took over at The Dynamics GP Blogster on Facebook:

Microsoft Dynamics Convergence 2013 Album

Over at DynamicAccounting.net, Mark Polino has some thoughts about the event after couple days of review:

Convergence 2013 Monday

Convergence Update from Tuesday

My Convergence 2013 Thoughts

MVP Leslie Vail, over at Dynamics Confessions has some cool pictures and offer some insights as well:

Convergence 2013 Day Zero

David Musgrave, we miss you!

Volunteer Day at Convergence 2013

Kofi Annan Convergence 2013 Keynote Speaker

MVP Belinda Allen, over at The GP CSI has the following entries on Convergence:

So it begins… Microsoft Dynamics GP Convergence

Microsoft Dynamics Convergence for GP begins today

Microsoft Dynamics GP Customer Story – Shock Doctor

Microsoft Convergence Keynote brief

Microsoft Dynamics GP Project Accounting Convergence Session

Microsoft Dynamics Convergence for GP update – FREE EXCEL DASHBOARD

The Learning Resources page of this blog has been updated with latest Convergence 2013 materials I presented for your  consumption. Please download here:

The Dynamics GP Blogster: Learning Resources

Scroll to the end of the page and click on any of the links to download.

Finally, visit the Virtual Convergence site for links to my presentations. As of this article, they all seem to be up and available, including the General Session.

Virtual Convergence 2013

As you already know, Microsoft Convergence 2014 will be held in the beautiful city of Atlanta, my home base. I hope to see you all here next year.

Until next post!

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

View the original here:
Microsoft Convergence New Orleans 2013: Wrap Up

March 25, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 322

Microsoft Convergence New Orleans 2013: Day 3

With the General Session gone it was now time to get through some sessions for the day.

The morning started out with a breakfast for the Microsoft Dynamics (AX, GP, CRM, NAV, and SL)MVPs in attendance, hosted by our Microsoft MVP Award Program lead, Melissa Travers.



Left: Melissa Travers (Microsoft), Donna Edwards (CRM), Mariano Gomez (GP), John Lowther (GP), Julie Yack (CRM), Gus Gonzalez (CRM), Jivtesh Singh (GP), Mark Polino (GP)
 
Right: Per Mogensen (NAV), Chad Sogge (Microsoft), Belinda Allen (GP), Jerry Weinstock (CRM), Charles Allen (GP), Juris de Gruyter (AX), Roohi Shaikh (CRM)

After breakfast, it was time for my first session of Convergence 2013 – CSGP24 – Administering SQL Server for Microsoft Dynamics GP. My session was attended by over 255 people, with just a few seats left for a full room.

The day did not precisely continue as I expected. After my session, I came down with a severe case of conjunctivitis (commonly known as “Pink Eye”) and had to quickly seek out an urgent care clinic to obtain a prescription antibiotic. As such my afternoon session, CSGP32 – Microsoft Dynamics GP 2013 Web Client For Smaller Companies was conducted by my co-presenters Kevin Racer and Daryl Anderson, with Daryl sitting in for me throughout the session.

Frankly, this was a first getting ‘sick’ at any event I have attended and have to say it was quite frustrating and disappointing. As such, I went back to the hotel to nurse my eyes for the rest of the day – yes, that meant no parties, grr!!!

Until next post!

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

More:
Microsoft Convergence New Orleans 2013: Day 3

March 22, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 275

The Dynamics GP Blogster: Microsoft Convergence New Orleans …

The Dynamics GP Blogster. “Your Microsoft Dynamics GP world without barriers” …. No comments: Post a Comment · Newer Post Older Post Home. Subscribe to: Post Comments (Atom

Original post:
The Dynamics GP Blogster: Microsoft Convergence New Orleans …

March 17, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 132

Microsoft Dynamics Salary Survey 2013

The folks over at Nigel Frank have published a link to their 5th annual Microsoft Dynamics Salary Survey for YOU to participate and express your views. You can find the survey here:

Microsoft Dynamics Salary Survey

This year the survey added some new interesting questions allowing for more insight into retention and recruitment as well as the general Microsoft Dynamics labor market trends. The report is due to be revealed at Convergence 2013, so you won’t want to miss out.

In addition, it seems like you can enter into the draw for a Microsoft Surface Pro, so really, there’s nothing to lose. Go fill out your survey now!

Until next post!

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

Originally posted here:
Microsoft Dynamics Salary Survey 2013

March 11, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 216

Visual C++ Runtime Failed while configuring Reporting Extensions for CRM 2011 with SQL 2012

Hi Folks, With the latest update of CRM 2011 we have compatibility with SQL 2012 server. I have got a chance to install CRM application on top of SQL 2012. If you are successful in installing CRM then trying to configure Reporting Extensions for CRM you might encounter the following error:  “Installation of Microsoft Visual C++ Runtime failed.

Originally posted here:
Visual C++ Runtime Failed while configuring Reporting Extensions for CRM 2011 with SQL 2012

March 2, 2013 · turlapativishnu · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 161

SQL view for sales quantities by item by site by year

Below is another variation on my view for sales by item by year and view for sales quantities by item by year. This one shows the total item quantity sold by site by year. The view below makes a number of assumptions (listed in the view comments in green), and I am hard coding years from 2006 through 2013 as well as adding an overall total column at the end. You can easily change the years or add new ones by following the example in my code.

Some additional resources:

CREATE VIEW view_Sales_Qty_by_Item_Site_Year
AS

-- ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
-- view_Sales_Qty_by_Item_Site_Year
-- Created Feb 28, 2013 by Victoria Yudin - Flexible Solutions, Inc.
-- For updates see http://victoriayudin.com/gp-reports/
-- Returns total sales quantities fulfilled (invoices less returns) for each item
--    by site by year
-- Only posted invoices and returns are included
-- Quantity is calculated by multiplying by QTYBSUOM column in case other UofM's are
--    used on transations
-- Voided transations are excluded
-- Item Description is taken from Inventory Item Maintenance for all inventory items
--    and from SOP line items for non-inventory items
-- ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~

SELECT
D.ITEMNMBR Item_Number, D.Item_Description, D.LOCNCODE Site_ID,
sum(case when year(D.DOCDATE) = 2006 then D.Qty else 0 end) 2006_Qty,
sum(case when year(D.DOCDATE) = 2007 then D.Qty else 0 end) 2007_Qty,
sum(case when year(D.DOCDATE) = 2008 then D.Qty else 0 end) 2008_Qty,
sum(case when year(D.DOCDATE) = 2009 then D.Qty else 0 end) 2009_Qty,
sum(case when year(D.DOCDATE) = 2010 then D.Qty else 0 end) 2010_Qty,
sum(case when year(D.DOCDATE) = 2011 then D.Qty else 0 end) 2011_Qty,
sum(case when year(D.DOCDATE) = 2012 then D.Qty else 0 end) 2012_Qty,
sum(case when year(D.DOCDATE) = 2013 then D.Qty else 0 end) 2013_Qty,
sum(D.Qty) Total_Qty

FROM
(SELECT SH.DOCDATE, SD.ITEMNMBR, SD.LOCNCODE,
 coalesce(I.ITEMDESC, SD.ITEMDESC) Item_Description,
 CASE SD.SOPTYPE
 WHEN 3 THEN SD.QTYFULFI*QTYBSUOM
 WHEN 4 THEN SD.QUANTITY*QTYBSUOM*-1
 END Qty
 FROM SOP30200 SH
 INNER JOIN
 SOP30300 SD
 ON SD.SOPNUMBE = SH.SOPNUMBE
 AND SD.SOPTYPE = SH.SOPTYPE
 LEFT OUTER JOIN
 IV00101 I
 ON I.ITEMNMBR = SD.ITEMNMBR
 WHERE SH.VOIDSTTS = 0
 AND SH.SOPTYPE IN (3,4)
 AND SD.ITEMNMBR not like 'XXXXXXXXXXXXXXX%') D

GROUP BY D.ITEMNMBR, D.Item_Description, D.LOCNCODE

GO
GRANT SELECT ON view_Sales_Qty_by_Item_Site_Year TO DYNGRP

Disclaimer: I tested this on limited data, if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone.

Filed under: Dynamics GP, GP Reports code, GP SQL scripts, SOP SQL code Tagged: featured, GP Reports code, Sales Order Processing, SQL code

Visit site:
SQL view for sales quantities by item by site by year

February 28, 2013 · Victoria Yudin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 287

GPUG Georgia Regional Chapter Meet Up

I did not want this to pass me by.

Last Tuesday, February 12, 2013, I had the opportunity to participate as a guest speaker at the GPUG Georgia Regional Chapter meeting, hosted at Prosys Information Systems, a Microsoft Dynamics GP customer.

Our chapter meeting had two topics being discussed for the day:

  • Advanced Analytics for Microsoft Dynamics GP. This first topic was very exciting and was conducted by Dwight Specht, COO of IBIS, Inc. Dwight demonstrated the power of Analysis Cubes for Microsoft Dynamics GP and showed how Excel can be leveraged as a client to interact with these.

  • Where to Go for Answers? I championed this topic and explored some of the options for finding information within the Microsoft Dynamics GP community with all attendees. We had a great deal of discussion around the use of social media from a corporate and personal perspective and how it can be leveraged as a tool for building your professional network and obtaining support.

All in all, it was an exciting afternoon and attendees had a chance to interact with the presenters and discuss how they are taking advantage of analytics and social media in their organizations. I can’t wait for next quarter’s meeting.

Until next post!

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

See the original post:
GPUG Georgia Regional Chapter Meet Up

February 18, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 251