Barry Crowell’s Next Post on Dynamics GP & Power BI


Another excellent article from Barry Crowell on Dynamics GP and Power BI:

During my last blog post, I walked you through creating a financial dashboard using Power BI with Dynamics GP data. I have created additional analysis and measures now. If you look closely at the bottom left, you will see two additional reports for Sales Summary and Customer Analysis. Sales Summary The data used from Dynamics […]

via Supercharge Your Dynamics GP Dashboards & Reports with Power BI — My quest in SQL, BI & Dynamics GP

Barry Crowell’s Excellent Dynamics GP & Power BI Post – Multicompany Financial Dashboard


Back in October of 2015, I posted a blog about how to modify Jared Hall’s awesome Excel Financial Dashboard that you can download here. The problem with his solutions is that most Dynamics GP environments are multi-company setups making these dashboards not very functional without navigating and opening multiple Excel spreadsheets to view each company’s […]

via WOW! A Dynamics GP multi-company Financial Dashboard – Part Deux — My quest in SQL, BI & Dynamics GP

Management Reporter CU16 Released


It’s been almost a year since I had posted anything on my blog, due to various reasons. In all honesty, breaking that hibernation was harder than what I expected. Anyways…

Management Report CU16 has been released and is now available for download. Here’s the post from Dynamics CPM Team: Management Report CU16 Now Available

CU16, like my own absence from community activities, has come after almost one year. And this release indeed seems to be substantial. Following is the fixes list:

  1. Change tracking only gets enabled on the first Microsoft Dynamics GP company database.
  2. Wildcards and ranges doesn’t return all valid dimension combinations.
  3. Dimension filter uses an OR condition instead of an AND in different scenarios when two dimensions are specified.
  4. Dynamics GP: Management Reporter is performing a count query before actual query, doubling the query cost with data mart.
  5. Dynamics GP: Management Reporter fact integration slow when posting large Analytical Accounting batches.
  6. Dynamics GP: GP data validation is not working for Microsoft Dynamics GP 2016.
  7. Dimension filter uses an OR condition instead of an AND if using a dimension value that does not exist.
  8. Dynamics GP: Unable to create GP integration with GP 2016 Dexterity Shared Components.
  9. Dynamics GP: Yes/No Analytical Accounting dimension not working or integrating correctly in the Management Reporter data mart.
  10. Report generation fails when using a dimension value setting in the reporting tree based on MainAccount.
  11. MR CU15 Known Issue – @DateLong AutoText header displays day of week in web viewer.
  12. Report generation fails when there is a duplicated name for a dimension value.

I have removed all Dynamics AX related fix references. Full list can be found here: Management Report CU16 Fix List (PartnerSource/CustomerSource Access Required)

About the new features, most important one is the support for HTTPS & SSL deployment, for more data security.

I am gonna go ahead, download CU16 and upgrade my test environment, to experience the fixes and features.

I strongly suggest to whoever still use MR to do the same.

Vaidy

Error while connecting to Management Reporter 2012 CU13


This post just saved my day. Big time!

Ariston Javier Blog's

Error Messages:

System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://Server:4712/InformationService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. —> System.Net.WebException: Unable to connect to the remote server —> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.123.40:4712
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
— End of inner exception stack trace —
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()
— End of inner exception stack trace —

Server stack trace:
at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()
at System.ServiceModel.Channels.HttpOutput.Send(TimeSpan timeout)
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.SendRequest(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at…

View original post 162 more words

Jet Express for Excel & Dynamics GP


Exciting news from Pam on her blog about the new reporting kid on the block.

Microsoft and Jet Reports have partnered to give us a new reporting tool for Dynamics GP called Jet Express for Excel.

I’d recommend you to read her post without fail to know everything about this new reporting tool.

Couple of things, among all the other information, that really excite me:

  1. This new reporting solution will be available free to all users in June.
  2. The new tool will be compatible with all versions of Dynamics GP, including through to GP 2016, and will also offer an upgrade path.

Happy Reporting…

VAIDY

GP 2015 VS Tools Installation Error


I was trying to install VS Tools for GP2015 R2 on my machine that has already got VS Tools for GP2016 installed. I could not complete the installation and received following error message (and its corresponding Event Log).

Screen Shot 2016-05-13 at 3.16.03 PM

Please note, on the event log, it says “GP 2016 SDK” while I was trying to install GP2015 VS Tools SDK.

Has someone faced this error? If so, could you please share with us on how you resolved it? Have you resolved it at all?

Please lend your inputs on the comments section.

VAIDY

Upgrade to Windows 10 for free before time runs out


David Musgrave's Winthrop Development Consultants Blog

David Meego - Click for blog homepageWindows 10 was officially released on the 29th July 2015, and when it was released users of Windows 7 and Windows 8 were offered a free upgrade to Windows 10.

The free upgrade offer lasts for one year and so will expire on 29th July 2016. So this article is a reminder for everyone out there who has not upgraded yet to get a move on.

View original post 242 more words