Welcome to Houston!

Welcome to day 3 of Microsoft’s Worldwide Partner Conference 2013. And what a busy day we have lined up for you!

 

Building on yesterday’s end-to-end product session, today’s focus is on how you can plan and build your business. Firstly, at 1:30 p.m., prepare to be inspired in the Microsoft Dynamics GP and SL: New opportunities to build your business session, where you can learn about the new opportunities you should consider as you look at your business planning for the next 12 months – including key topics such as the Web Client, Business Analyzer, RapidStart Services for Microsoft Dynamics GP, Windows Azure, and Office 365.

 

Then go deep in two strategic business areas that could help propel your business forward and sharpen your competitive edge. First up, at 3 pm, is How to sell Office 365 together with Microsoft Dynamics GP, NAV and SL. This session will provide detailed guidance on how the increasing level of integration with Microsoft Office 365 has created a new opportunity for you to boost your bottom line by offering Office 365 to your customers. Hear about the combined sales motion, Office 365 pricing and licensing, available resources, and best practices from other Microsoft Dynamics partners.

 

Then at 4:30 p.m. don’t miss Heading into the Future with the Windows Azure Cloud for insight and information on opportunities to offer Microsoft Dynamics NAV and Microsoft Dynamics GP, hosted in the cloud on Windows Azure infrastructure services. Learn about the model, business best practices, pricing and licensing approaches, technical resources, top lessons learned, and more.

 

As well as being packed with valuable information, all three sessions offer the chance to win fantastic prizes, so come along, and be sure to stay until the end!

 

Still hungry for more? With over 450 sessions, there is something for every taste. You could brush up on your business leadership skills in the Business Leadership track and the Emerging Leaders track. Hear more about the Microsoft cloud strategy, offerings, and programs for hosting and cloud service providers in the Hosting and Cloud Service Providers track. Or get together with other partners like you in other areas of the Microsoft business ecosystem in the Small and Medium Business Reseller track.

 

You can get all the session details, times and locations here, and read about all the other valuable and inspirational tracks here.

 

So much to do, so little time…

See more here:
Welcome to Houston!

July 9, 2013 · Jay Manley MSFT · No Comments
Tags: , , ,  · Posted in: Blogs I Follow Total Views: 135

Customisation Import – Component Write Exception

While importing a customised Form with VBA I encountered a problem and received a Component write exception; Component Write Exception The form itself had imported but the VBA element had not. Not having seen this error before I hit up … Continue reading

View post:
Customisation Import – Component Write Exception

July 4, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 211

Offline Install Of dotNET 3.5 On Windows Server 2012

I recently encountered a problem trying to install the .NET Framework 3.5 in a virtual machine on my test server which is not connected to the Internet (I wish it was but I am currently renting and don’t have a … Continue reading

More:
Offline Install Of dotNET 3.5 On Windows Server 2012

June 24, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 163

Management Reporter 2012 Install Error – Invalid sa Password

I was recently on site with a client doing an upgrade from Microsoft Dynamics GP 2010 to 2013 and implementing Management Reporter 2012 to replace FRx 6.7. The upgrade of Dynamics GP to 2013 went through without issue, once I … Continue reading

See the original post:
Management Reporter 2012 Install Error – Invalid sa Password

June 21, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 137

Management Reporter 2012 Process Service Not Running

I was out on site a short time ago implementing Management Reporter 2012 for a client and ran into a problem with Management Reporter. I could log into Management Reporter, create reports and everything was fine; but I could not … Continue reading

Visit site:
Management Reporter 2012 Process Service Not Running

June 17, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 128

Microsoft SQL Server security roles and Microsoft Dynamics GP SSRS reports

It’s not uncommon to find system administrators and consultants alike struggling to deploy Microsoft Dynamics GP SRS reports in an environment, while trying to keep these reports secured. I find that the main issue revolves around understanding the different moving parts: domain accounts, GP user logins, the SQL Server database roles created for reporting, the reports web site security, the reports folder security and the list goes on.

So here is a list of resources that I believe will help with this:

The best place to start is the SQL Server Reporting Services Guide, which has all of the information for installing, deploying and setting up security for SRS reports to use with Dynamics GP.
This guide is available for download from the Microsoft Download Center.

Microsoft Dynamics GP 2013 Guide: SQL Server Reporting Services

In order for users to access SRS reports (default) for Dynamics GP, they need to have the following permissions:

1. Access to the Reporting Services web site (native mode) or report library (SharePoint Integrated). I have found the following resources to be extremely useful when configuring Reporting Services security in native mode:

Granting Permissions on a Native Mode Report Server

If you are dealing with Reporting Services in SharePoint Integrated mode, the following is a good resource:

Security Overview for Reporting Services in SharePoint Integrated Mode

2. Permissions to the SRS report files themselves.
The following TechNet video shows just that:

3. Database security roles (RPT_ ) under the DYNAMICS and/or company databases in order to pull data into the SRS reports. You will want to take a look at the following KB article 954242 – Frequently asked questions about the integration of SQL Server Reporting Services (SSRS) with Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010, which can be found at:

http://support.microsoft.com/kb/954242

I hope you find these resources useful.

Until next post!

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

Read the original:
Microsoft SQL Server security roles and Microsoft Dynamics GP SSRS reports

June 7, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 222

GP 2013: Why are my SmartLists not formatted when exported to Excel?

Just recently I have been seeing a number of questions around Microsoft Dynamics GP 2013 Smartlist exports to Microsoft Office Excel not being formatted correctly – let’s rephrase, the correct word to use here is “nicely”. The issues usually involve leading zeroes being dropped (in some cases) and currency amounts being exported with 5 decimals and no currency symbol.

Exported Payables Transactions smart list

To make a one swipe statement here, this behavior IS NOT a product bug – despite the inconvenience.

With the introduction of the Web Client in Microsoft Dynamics GP 2013, the development team needed the ability improve the performance of Smartlist exports over the browser. To gain this dramatic improvement in performance (which is also experienced when using the rich client), exported Excel smart lists were voided of formatting.

There’s an undocumented Dex.ini switch that provides limited formatting to Smartlists, thus maintaining export performance:

SmartlistEnhancedExcelExport=TRUE

You can find more information on this Dex.ini switch here:

Undocumented DEX.INI switch cuts down SmartList export times to Microsoft Office Excel

If you are not going to deploy Web Client, then this should be fine as a workaround. However, this switch causes the Web Client to error out with the following message when attempting to export to Excel:

Web Client error exporting smart list to Excel with SmartlistEnhancedExcelExport=TRUE 

So there you have it!

Until next post!

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

Excerpt from:
GP 2013: Why are my SmartLists not formatted when exported to Excel?

May 23, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 363