Your Microsoft Dynamics GP Product Management & Marketing team:
Errol Schoenfish
Pam Misialek
Jay Manley
Jen Dorsey
Gerice Anderson
Darrin Hawley
While this blog is technically "owned" by the Microsoft Dynamics GP Product Management and Marketing team, it truly belongs to ALL of those who call themselves a part of the Microsoft Dynamics GP community!
Today was the big announcement for Microsoft Office 365. Steve Ballmer, in NYC, made the announcement of the general availability of Office 365 and gave many great examples of the power and flexibility you get from having Office 365 deployed.
This really also allows SMB customers, those that typically have not had IT resources, to finally get features such as Sharepoint and Lync at their companies.
Take a look at the collateral on our new Partnersource site that is up today for more information, and check back shortly, as more DemoMate materials are coming soon!
Jay
https://mbs.microsoft.com/partnersource/marketing/marketingcollateral/demos/MSDYGP_Office365Integration
This demo, featuring Business Analyzer, illustrates how Microsoft Dynamics GP can provide you and your company with more insight and greater efficiency.
What's new in Microsoft Dynamics GP 2010 R2? This PowerPoint presentation highlights the new features you'll find in Dynamics GP 2010 R2.
Check out this demo to see how Microsoft Dynamics GP 2010 R2 can provide you with more insight and greater efficiency when managing your business.
Wondering what to do after you’ve installed Microsoft Management Reporter? Click this link for tips and info to ensure a smooth migration.
ManagementReporter - Migrating from Microsoft FRx
Connector is a unique solution that integrates Microsoft Dynamics ERP with Microsoft Dynamics CRM. Check out the Connector team's blog site at http://blogs.msdn.com/b/dynamicsconnector/ to watch demos and learn more!
Sorry, I LOVE anything dealing with pivot tables . . . especially if you add power pivot to them. Thanks to Belinda Allen for this video.
Have you ever wanted a list of all the Microsoft Dynamics GP 2010 R2 SRS Reports, but were afraid to ask?
No fears! Here is the list of all SRS reports that we now have in Microsoft Dynamics GP 2010 R2!
<See attached PDF>
I've been deliquent on these but you can go back to see the other posts. We had a great celebration last night. Here is the article.
Microsoft partner, The TM Group, Inc., has embraced the social media wave to build connected end-to-end marketing campaigns while also incorporating mainstays like telemarketing and direct mail into the mix. They are also funneling and monitoring these activities through their in-house Microsoft Dynamics CRM solution. See more HERE.
It's all in the family at the Schoenfish house . . . we live Microsoft. :) Article here.
The local Fargo paper is doing a series of articles celebrating the 10 year anniversary of Microsoft's acquisition of Great Plains Software. HERE.
Here's another picture from the past. We had a barbershop group that sang at various company events (including Stampede). Can you figure out which one is me?
The New Business Analyzer in Microsoft Dynamics GP 2010 R2 renders SQL Server Reporting Services (SRS) reports at the time and place that makes sense for you. Business Analyzer can display reports from your Navigation Lists or right on your desktop. Not only can reports be viewed but you can also take actions against those reports to easily edit and collaborate with others.
Here's how.
1. Create an ODBC connection to the Excel file you want to use as a data source
Start>>Control Panel>>System and Security>>Administrative Tools>>Data Sources (ODBC)
Select the System DSN from the ODBC Data Source Administrator window
Select the Add
Select Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) from drop down list of available drivers
Select Finish
Enter a Data Source Name and Description
Select the Select Workbook ... Button
Browse to the file you want to use as the data source and select OK.
Select OK
Your data source should now appear in the list of System DSN's.
Select OK to close the window.
2. Create the SQL Server Reporting Services Report
a. Open Report Builder 2.0 or Report Builder 3.0 (Start > All Programs > Report Builder 2.0/3.0)
b. Select to create a blank report.
Right Mouse click over Data Sources and select Add Data Source
Enter a Name for the data source
Select radio option to “Use a connection embedded in my report”
Select ODBC from the Select connection type drop down
Select the Build button
On the Connection Properties window select the System DSN you created
Select Test Connection
Select OK to close the window
Select OK to close the Data Source Properties window
Perform a right mouse click over Datasets and select Add Dataset
Enter a Name for the dataset.
Select the radio option to “Use a dataset embedded in my report.”
Select “Excel” as your data source (step 2D)
Enter “Select * from [sheet$]“in the query field
Select Query Designer…
Execute the query by selecting the red exclamation point to valid your query
Select OK to close the Query Designer window
Select OK to close the Dataset Properties window
You now have your Excel file set as your data source and you are ready to build a report.