Microsoft Dynamics GP Roadmap – GP "15" Added


Mariano has just published the updated Microsoft Dynamics GP Roadmap on his blog, with GP “15” added to the exciting list of GP versions to come in future.

I am absolutely delighted to see Microsoft’s commitment to this wonderful product.

VAIDY

Using SQL to retrieve number of records in a table – David


David gives an alternate SQL option for the simple COUNT(*) and explain how it improves the performance as against COUNT(*).

You may have to go thru’ the comments as well; some comments discuss the post further.

VAIDY

State of Online Accounting Industry – Q&A on Software Advice by Michael Koploy


I was contacted by Mr. Michael Koploy, Software Advice, to have a look at his then recent article; State of Online Accounting Industry.

The importance of this article is that it gives an insight about Accounting Software on Cloud, from 3 of the leading Online Accounting Software solutions. 5 important questions and you are well informed by the answers. It’s a great read and well informative.

I would like to share my views on this.

Advantages:

1. Cost – That’ll be the driving point for any one who want to go online.
2. Less/Zero Maintenance – You don’t have to worry about downtime or H/W maintenance on server or related resources.

Disadvantages:

1. Depends on providers. You can’t just trust everyone and anyone who provide an online solution. There were some recent outages from industry’s leading providers, such as Microsoft, Amazon, etc.
2. Since it’s pay as you use, you have to limit your usage if you have to get some benefit out of. When I say that, I mean, I may not have one live environment and one test environment for the price of only one environment. If I insist to have, I may have to pay for that.
3. If I have to restore a backup due to a severe mistakes, I can’t do it immediately. I don’t even know whether my service provider maintains a backdated backup or not.
4. No Accounting Software is used AS IS, without a single customization(s). If I do require a customization, then my online accounting software should have an ability to import it and get updated with.
5. Whenever there is a major update to the parent product, I may or may not have a choice to decide on whether I actually want it or not. As always, a major upgrade also include additional cost depending on HOW major it is.
6. People may not feel like THEY ARE CONTROLLING THEIR DATA. I capitalized that, because, that’s a huge question everyone would want to ask before adapting to the change.

In my humble opinion, everything else could be 100% online (Public Cloud), but Accounting Software should be a hybrid (Private Cloud). In that way, there will be a balance between cost, maintenance and others.

VAIDY

Using substring() with Text Fields – David


Back from my vacation, several posts grabbed my interest as a developer. This post from David is one of them.

David explains how to resolve an issue that was found in Sivakumar’s SDT (Support Debugging Tool) based solution. In a nutshell, the issue was with Text type fields and dexterity function substring().

Read it here; Quick Tip: Using substring() with a text field datatype.

VAIDY

Dynamics GP Developer Insights – Series of Posts on Developing For Dynamics GP


Brian Roney and his team at Microsoft (Dynamics GP Technical Division) is going to post series of articles which will enlighten us on what’s been going on with Dynamics GP development.

Series titled as Dynamics GP Developer Insights.

GP developers across world, stay tuned for a brilliant series.

VAIDY

Best Practice for Dexterity Version & Build Numbers – David


David’s post, Best Practice for Dexterity Version and Build Numbers, explains a very important concept in chunk creation process.

We must version our products which is very important and also ethical. Small-time Dex developers do not understand this process when they deliver a simple customization. 
I sincerely believe that this post from David would enlighten people about this.
VAIDY

Dynamics GP Insights – From BKD Technologies


A new blog out there launched by BKD Technologies which is going to be a dedicated GP blog.

Check out: BKD GP Team Blog – Dynamics GP Insights.

VAIDY

Common Support Debugging Tool (SDT) Myths – Fact or Fiction?


I am too late in reading this post from David (how bad I am?). But better late than never, right?

The post lists out some of the common myths circling around the best admin tool GP has ever seen and solves the mysteries. Read it here: Common Support Debugging Tool (SDT) Myths – Fact or Fiction?

Watch out for some cool myths pointed out at the end (original idea behind those is from our own Mark Polino).

David, you got to be an Alien for certain. Not just this tool, but also your futuristic steps that we witnessed not too far in the past.

VAIDY

Required Fields – Additional Tip


This one is a simple tip, yet very useful one. Frank reminds us on where and what would be the problem if we don’t see required fields as we wished to.

Now, this one is for developers. If it’s a customization that we have developed and on that if users are not able to see required fields as they wish, then you know what the problem is: Set Required property to TRUE without fail for all fields that are suppose to be REQUIRED and make sure that you have linked the prompts (Link Prompt action) for those fields correctly.

VAIDY

Microsoft Dynamics GP 2010 – Reporting (By David Duncan & Christopher Liley)


I just added one more treasure on my kit, in the form of a new book called Microsoft Dynamics GP 2010 – Reporting, written by David Duncan (I.B.I.S.) and Christopher Liley (I.B.I.S.), published by Packt Publishing.

I have started reading this book from today and hopefully in a week, I will be able to grab hold of the vast set of chapters.

To give you an overview of what is there inside this book: The book covers everything “reporting” in GP. From Report Writer reports to Smartlist to Excel Reports to SSRS to Analysis Cubes to Management Reporter. Every single thing about GP Reporting.

However, the book does not talk about two things:

1. Crystal Reports and the way you can access crystal reports from GP quite understandably because Crystal Reports is NOT supported out of the box by Dynamics GP. It can be used with the help some 3rd Party solutions, such as GP Report Viewer (from Flexible Solutions) or even a simple code piece written by any Consultant who knows GP, Crystal Reporting and .NET coding.

2. FRx, as this is already been replaced by Management Reporter. There is of course a section in this book where the difference between FRx and Management Reporter is explained.

I shall be writing a review of this book in a week’s time (hopefully). Just could not wait to tell you all that this book really going to be a great treasure for those who wants to understand how effectively GP data can be visualized and analyzed.

Until next post.

VAIDY