If you are a consultant, chances are you run your Microsoft Dynamics GP application demo environment on a laptop along with Microsoft SQL Server and SQL Server Reporting Services. This is all good, because it saves you from having to deal with virtual machine images in most cases
Wednesday, November 20 The Microsoft MVP Global Summit is come to an end, but I am going to finish up the series and as usual wrap up with some thoughts. Frankly, today I woke up dragging feet a bit. It’s been 2 grueling days of intense sessions with a lot of material to absorb.
In this post we will discuss about the use of recursive querying in SQL Server. Recently, I got a request from a Partner to develop a SSRS report for the Indented Bill of Materials in the Inventory module. I was going through the Dexterity Indented Bill of Materials report and found out that the report uses a temporary table.
Did you know that you can access SQL Reporting Service Reports directly from a GP form? This feature is cool because it allows customers to print SQL Server Reporting Services (SSRS) reports directly from a Microsoft Dynamics GP form making it easier to access information in a format that makes sense. The user may select to print SSRS reports from various forms across General Ledger, Receivables Management, Sales Order Processing, Payables Management, Inventory Management, Human Resources, and Payroll. Users can simply select to print a SSRS report assigned to the Microsoft Dynamics GP Form and the report will render information based on the record retrieved on the form. Customers can print the reports we ship or they can create their own custom SSRS reports to print
Continuing with the Web Client Wednesday series, today I wanted to highlight the fact that the web client is still a work in progress. While a lot of ground has been covered over the past 3 years, the product continues to evolve, and of course, in the meantime there will be little issues here and there that may affect the way you work. Previous articles in the series: Web Client Wednesday – Browser Support Web Client Wednesday – User Interface Differences Just recently I ran into a Microsoft Dynamics GP 2013 web client deployment case where the advanced SQL Server options are enabled to enforce password expiration
Here’s a list of tools available from your Microsoft Partner that are not a standard part of the Professional Services Tools Library toolset, along with the GP versions that they apply to. Most, if not all, of these are installed by dropping a file into the GP folder on your application server and restarting GP. Talk to your partner for more information.