GP, ODBC DSN & 64 Bit Systems

This post is long pending, since I had worked on the topic around 2 months back.

According to GP Installation Instruction, To set up an ODBC data source, enter the name you assigned to the SQL Server when you installed Microsoft SQL Server. A data source name called Dynamics GP also is created using SQL Native Client. If you don’t want to set up an ODBC data source, mark the Do not create a data source option.

It's very handy (and recommended too) to create the ODBC DSN thru' GP Installation, when we install GP on a 64 Bit System. We all know that GP is a 32 Bit Application. When we install GP on 64 Bit System, it gets installed with 32 Bit Compatibility.

Typically, on a 64 Bit System there are two ODBC Data Source Maintenance wizards available. One is for 64 Bit and other for 32 Bit. What you open from Control Panel -> Administrative Tools (or Start -> Run -> ODBCAD32.exe), is nothing but default 64 Bit ODBC DSN Maintenance wizard.

Microsoft Dynamics GP & CRM - A Gradual Progress

I am currently working on a realtime GP & CRM 2-Way Integration.

Needless to say, I have learned a lot and would like to share what I have learned. And moving forward, you would be seeing a mix of articles which talks about both Dynamics GP (my life) and Dynamics CRM (my interest).

As a first step, I will be posting my first CRM article about CRM - GP Adapter's Picklist Configuration utility in a couple of days.

I hope you all would be interested.

VAIDY

Management Reporter Features - Explained by Sandeep Walia

There are many articles across the Blogosphere on Management Reporter for MS Dynamics ERPs.

This one's pretty good in terms of explaining the basics of MR. And also the points which would make Customers migrate to MR from FRx.

Read the article, Management Reporter For Dynamics ERP – An Analysis, on ERP Software Blog.

UPDATE (19JUN2010): The above link to the original article on ERP Software Blog, seems to be broken and not working.

VAIDY

Niraj's First Birth Anniversary...!

KINDLY NOTE: This post is PERSONAL and nothing to do with Dynamics GP...


Time moves on... Moves on very fast...

Our beloved NIRAJ, Son of Shan & Uma, completes his first year in this world. :-) Yup tomorrow is his first Birth Anniversary...

Let's all join to wish him a Happy Birthday & Blissful Life...!!!

VAIDY

Avoiding Sign-Off Hell - Mark Polino

I had seen this not long ago. And this article by Mark Polino should have come a bit earlier.

Read it: Avoiding Sign-Off Hell.

MUST READ for all Partners / Consultants.

VAIDY

Why Extender Information does not get transferred?

I have been getting this query on WHY EXTENDER INFORMATION ON A SOP QUOTATION DOES NOT GET TRANSFERRED TO THE CORRESPONDING ORDER?

Well, there is obviously no logical reason behind it. Given the fact that SOP User Defined values are getting transferred from Quote to Order to Invoice, we expect the same thing from Extender Information also. Point substantiated.

Deploying GP SSRS Reports - maxRequestLength Error & Resolution

I was deploying GP SSRS Reports on SQL Server 2008 64 Bit and was facing the following error message:

There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

Googled it and here the resolution: http://www.developmentnow.com/g/115_2006_4_0_0_735861/Request-Length-Exceeded.htm

I hope this would be a useful tip for people out there deploying SSRS for GP.

VAIDY

Introducing SQL Server 2008 R2 - Reference Available for Limited Period

Microsoft has given us a limited period free availability of SQL Server 2008 R2 Features Introduction reference.

You can download this reference from the path: http://go.microsoft.com/fwlink/?LinkId=189147

And for more details on this offer: http://www.microsoft.com/learning/en/us/training/sql-server.aspx#tab1

VAIDY

How to Configure Word Templates in GP2010 - David Musgrave

This article seems like an extension to what Inside Dynamics GP explained us on GP2010 Word Templates (Feature of the Day Series). But that extended information is what matters for us. You may miss this information if you are not a Developer. Rather it may not sound relevant for you in that case.

David explains How to Configure, and most importantly, Where These Templates are Stored. Quite interesting.

Thanks David, for the insight.

VAIDY

RW_ConvertToWordsAndNumbersParse – In GP2010

This is a very good RW function which is available from GP 2010. More information in David’s Blog: Announcing Report Writer Function RW_ConvertToWordsAndNumbersParse.

This means, an amount of any length can be converted to Words and displayed on a RW report. And this also supports MC. That’s another great news.

VAIDY