Category Archives: Dynamics GP

GP2016 – Feature of the Day – Export as Numbers to Excel

Posted on by

This one won’t seem a big deal, however those who use Smartlist and Excel day-in day-out would agree with me that it’s a pain to see numbers getting exported as string from Smartlist to the Excel.

We had to then format the column as either number/currency and then continue with our analysis.

With this FOTD, we are gonna save time. No frustrations either. With GP2016, we can export amounts from Smartlist as numbers to Excel.

In my opinion, this is not a new feature. This should be categorised as an improvement. I am glad that all these small nitty-gritty details are coming through well with each release.

VAIDY

GP2016 – Feature of the Day – PA Document Attach & Payables Credit Cards

Posted on by

Next set of “feature of the day” posts give us a glimpse on:

Interesting thing about PA document attach feature is that the attachments on Project Time Expense (PTE) would flow to Project Accounting and to Payables.

VAIDY

GP2016 – Feature of the Day – Inventory AIO Viewer & Project on Purchase Requisition

Posted on by

Excited to see the “All-In-One Viewer” being extended for all modules. After sales, inventory has got its own AIO viewer.

Perhaps the most important feature that I am excited about, in addition to HTML5 Web Client, is the ability to add a Project to Purchase Requisition Entry. This was sorely missed by many of the customers. I am glad this feature made it to GP2016.

Read the “feature of the day” posts here:

VAIDY

20 Best Dynamics GP Blogs of 2016

Posted on by

I am delighted to see my blog, Dynamics GP – Learn & Discuss, listed as one of the 20 Best Dynamics GP Blogs of 2016.

best-dynamics-gp-blog-badge

Thank you so much, Rand Group, for honouring me with this. I feel even more responsible now to continue.

VAIDY

IMPORTANT: GP 2016 Upgrade Blog Series

Posted on by

By now, the entire GP community would be excited about GP 2016 release, scheduled on 1st May 2016 and would be eagerly waiting for Feature of the Day blog series on Inside Microsoft Dynamics GP blog.

I am more interested in this series: Microsoft Dynamics GP 2016 Upgrade Blog Series

Needless to say, this series would be crucial to all consultants/partners/customers to understand what to expect in GP2016 upgrade.

Watch out for this series, GP folks. Don’t miss it.

VAIDY

Changing SQL Server Collation After Installation

Posted on by

I had a necessity to change the collation of newly created SQL server instance from CI_AS to CP1_CI_AS.

To brief you about why this was needed, I wanted to test upgrade GP from version 2010 RTM to 2010 SP3. In order to that, I created a new SQL server instance with collation SQL_Latin1_General_CI_AS. I restored GP 2010 RTM backups on to this newly created server. But later realised that GP databases that I got for 2010 RTM was of collation SQL_Latin1_General_CP1_CI_AS.

There were two options. Either I must change the collation of databases to CI_AS or I must change the server collation itself to CP1_CI_AS. Later seemed to be a better option (for some reason, I wanted to retain the collation on the databases). I was left with changing the collation of server instance.

That’s when I got this link: Changing SQL Server Collation After Installation

I was worried about the whole process but this post saved me loads of time and sweat. Changing the collation was a breeze.

Anybody out there who is looking for the best possible method to change server collation, above is the post you would want to read.

VAIDY

GP 2015 – New Feature – Caps Lock On Message

Posted on by

I had no idea about Dynamics GP Dev team adding this nice little (yet highly useful) feature to Dynamics GP 2015; “Caps Lock On” message while entering a password on your log in screen.

Till GP 2013, we did not have this out-of-box. So consultants/developers like used to write a simple plugin that filled this gap.

But with GP 2015, fortunately for customers and consultants/developers alike, this is now a built-in feature.

Screen Shot 2014-12-30 at 3.10.41 PM

I am not sure how many of us have noticed it. I just did today and in my opinion, this one’s a great addition without doubt.

UPDATE: I also noticed that this message will be displayed on any field in GP with “Password” mode enabled, as shown below.

Screen Shot 2015-01-04 at 3.38.29 PM

Well done, Microsoft Dynamics GP Dev Team. Very well done.

VAIDY