Category Archives: Uncategorized

Long Absence & Resurrection

Posted on by

I’ve been absent from blogging for an obscene amount of time. Have been MIA on forums, my blog, pretty from every public medium. Except Twitter, of course.

A lot happened in the last 2 years.

The Good: My primary job now revolves around an incredible mining solution named PLODtrack. For those who are interested in knowing about that, follow the link.

The Bad: It has got absolutely no affiliation with Dynamics GP, which means I’ve not been working on GP projects for the last 2 years.

The Ugly: Several. I don’t even know from where to start.

Silverlining: I’ve gained precious experience in the last 2 years. Both professionally and personally. That’s going to drive me from now, until god knows when.

Assurance: I’ve not stopped pursuing Dynamics GP. I’m very much a Dynamics GP consultant at heart and mind. I’ve got that going for me outside of my work hours. And I have absolutely no intention of drifting away.

So, long story short, I shall try to keep this blog alive with some really nice posts. Hopefully won’t take much time from this post till the next.

I’d like to thank those who still visit some of my posts and keep this blog going.

Vaidy

Advertisement

Connect SQL Operations Studio For Mac to a SQL Server in Parallels VM

Posted on by

I’m slowly moving away from Windows. However, being a Microsoft Dynamics GP consultant, that’s not entirely possible. I’ve been working hard to overcome every single roadblock since the last couple of years.

One major gripe, among several others, was the inability to connect the SQL Server instance on my Windows 10 virtual machine, mounted using Parallels. Until now.

Microsoft released SQL Server Operations Studio, which is still under preview, for us to connect to a SQL Server from Windows, Mac OS or Linux. I now have the choice to work from either my Mac OS or my Windows 10 VM.

However, there are some steps we must follow to successfully connect to a SQL Server instance on a virtual machine. This post, from Anton Sizikov, is probably the easiest one to follow. Following the steps explained on this post, Connecting SQL Operations Studio to SQL Express Server in Parallels VM, I was able to successfully use my SQL Server Operations Studio to connect to my VM SQL Server. Below is the SQL Ops Studio in all its “dark theme” glory:

Screen Shot 2018-05-16 at 16.18.41

I couldn’t use my Mac more than pretty much for just browsing, emailing and other daily digital chores. This is one huge step forward to start utilising it well.

Vaidy

 

Error while connecting to Management Reporter 2012 CU13

Posted on by

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

Upgrade to Windows 10 for free before time runs out

Posted on by

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

Time to say Good Bye to OLE Notes

Posted on by

With Dynamics GP 2016, some of the conventional features are going away. One such major feature is OLE Notes. From Dynamics GP 2013 R2, Microsoft made it clear that they wanted to do away with OLE Notes. We got Document Attachment feature.

With GP2015 R2, Documents Attachment cemented its position firmly. We also got a utility namely “OLE Note Migration Utility” that would help us migrate OLE Notes to Document Attachment.

We now have the official word that OLE Note Migration Utility would no longer be provided with Dynamics GP 2016.

Anybody who is using OLE Notes must first migrate to Document Attachment while they are still on current version and then upgrade to Dynamics GP 2016.

More details are posted on the link above.

Good bye, OLE Notes!

VAIDY

GP2016 – Feature of the Day – Power BI Integration & Budget Import Enhancement

Posted on by

Another set of feature of the day posts reveal that Power BI is coming to GP.  Also we have got Budget Import enhancement. Links to the posts are below:

  • Duplicate Accounts Import Exception Report
  • Power BI Reports on Home Page – I would rather like to see Dynamics GP being added to the Power BI Connector Services. Don’t get me wrong. I love this feature, it’s great to have Power BI report widgets on GP home page. However, the ideal integration would be to see Dynamics GP Connector Service. I think that would possibly happen soon, considering the next feature.
  • Dynamics GP OData Service – This is going to be another important feature (HTML5 Web Client being the first one) that I have been waiting for. This will enable us to have an excellent Power BI integration. I am happy to see Power BI reports on GP Home Page, no doubt, but I am super excited about OData Service.

VAIDY

Management Reporter CU15 Available Now

Posted on by

We have got another cumulative update (CU), CU15, available for Management Reporter (MR). Dynamics CPM Team has posted the link to download CU15 with the list of new features.

Web Viewer Responsiveness and Data Mart Reset Through PowerShell are my favs.

Most important points to be note:

  • SQL Server 2012 or higher is mandatory now. Anyone who’s using a lesser version won’t be able to update MR anymore.
  • Installing .NET Framework 4.6.1 is mandatory and would require a reboot. We must make sure that proper downtime is added to the update schedule.

Direct Download Link (CustomerSource Access Required): Management Reporter for Microsoft Dynamics ERP Installs and Service Packs Overview

VAIDY

Time to say Good Bye to FRx…

Posted on by

If anyone out there still using FRx as their financial reporting tool, it’s time to migrate to Management Reporter.

Dynamics GP Support team has posted an article, Microsoft Dynamics GP 2016 is upgraded – What’s next?, on which they have announced that FRx is no longer supported with Microsoft Dynamics GP 2016.

Time to say good bye to FRx…

VAIDY

GP2016 Upgrade – Missing Security Roles & Tasks

Posted on by

When upgrading to GP2016 RTM, it looks like upgrade process would skip creating new security roles and tasks, to ensure that the old ones are not messed up.

According to Dynamics GP Support & Services blog, this is intentional and we have been provided with an INSERT script that would create the new GP2016 roles and tasks. It’s more like on-demand insert.

A fresh GP2016 installation would hence be different from an upgrade.

VAIDY

GP2016 – Feature of the Day – Workflow Enhancements, Licensing Addition & More…

Posted on by

Following features have been posted on Inside Microsoft Dynamics GP blog:

  • Workflow Condition Management: We have a better condition management now that lets us decide on what needs to be done when a workflow condition is not met. Excellent.
  • Workflow Reassignment Notification: Notifications can now be sent to the new approver for delegation, escalation and/or alternate approval.
  • Named Self Serve User: With GP2015 R2, we got a new user license namely “Self Service User”. With GP2016, named self service user license is introduced. In all honesty, I have to wait and see how this differentiate itself from the previous license model.
  • Automatically Batch Deposit Cash Receipts: This feature reduces one step and saves lot of time. Posting a cash receipt batch would automatically create a cash deposit (either by batch or by transaction, depending on the setup). Awesome.
  • Manage/Edit Attachment Flows: Allows us to edit the information that flows from master to transaction and more. Enhancements are always great.

VAIDY