Dynamics GP 2010 - Issue in Editing Word Template in MS Word

I had mentioned in my previous article about OpenXML Plugin that must be installed on our system to run Word Template Report.

Once this was done on my test environment, I still could not see my Word Template report displaying all information as demonstrated in some Teaser Demos. The following was my Sales Order output:

The Header & Footer information were never shown and I am puzzled again as to how I could solve this issue.

When I tried modifying the Template from Word, the Microsoft Dynamics GP Add-In for Microsoft Word was loaded successfully on my MS Word, but I could never see "Developer" tab which will enable me to modify Word Report by adding / removing fields, logos etc.

I am still trying to find why this happens.

VAIDY

Editing VBA Code With Only Customization Site License - In Touch With Dynamics (GP)

Another informative and hidden tip from In Touch With Dynamics (GP) blog.

I myself got enlighten after reading this article: How to edit VBA when client only has Customization Site License.

I had never thought this was possible and it is.

Must read for all Dex/Modifier/VBA Developers out there.

VAIDY

Dynamics GP 2010 - Analysis Cube Error Message

I was testing Dynamics GP 2010 Analysis Cube Configuration for SQL Server 2008.

I entered the SQL Server 2008 Instance where GP is installed and I was able to successfully enter Setup Information for Analysis Cube Data Warehouse information.

When I tried selecting TWO Company on which I wanted to configure and deploy Analysis Cubes, I got the following message:

I honestly do not understand the term "Dynamics GP Professional".

While I am still wondering how to solve this issue, I would be immensely grateful if someone shed some light on this.

VAIDY

Generate Charts Using SSRS

MichaelJ2 has pointed out to a very good article in SQL Server Central portal, which explains step-by-step on how to generate charts using SSRS.

As he mentioned in the end, it's worth to have a look since GP is moving more towards SSRS and it would be great to see more Decision Making charts generated right from GP.

VAIDY

Creating Detail Window in Extender - Error & Resolution

I am working on Extender features after quite some time.

I was creating a Detail Window for Service Call Entry/Update window in Field Service. I entered Window ID, Description, Product, Series, Form & Window. I selected a Key Field and entered one Line Field.

I tried saving the Detail Window and I got this error message:

Certain Extender features and data may no longer be available with the installation of this product. It is recommended you reference your product manual before continuing.

I was quite puzzled to see this message as this is conveying something more like, I am not suppose to create a Detail Window at all. Or probably I perceived it in that sense.

I thought I would check KB before I conclude my defeat. I found a KB article which addresses this exactly: KB#947934.

My mistake. I did not select R1 or R2 for the Line Field that I tried creating. Obviously, we must specify whether the field which we are trying to create should be in first line or second line. And if we do not specify, Extender does not understand and create it automatically.

Having said that, the Error Message could have been a bit relevantly meaningful.

VAIDY

Microsoft Dexterity 11.0 - What's New? (Mariano)

Mariano walks us thru' his analysis on What's new in Dexterity 11.0.

Must see for all those Dex Developers out there.

VAIDY

Removing Extender Records - David (Critical Reference)

We all owe a lot to this guy, for timely and qualified solutions that he provide.

We have been facing this issue long time now. When we delete a Parent Transaction, the dependent Extender Information is orphaned and we do not know that. Over a period of time, this gets accumulated and lots of junk.

David nails this issue with his solution. Read it here: Removing Extender Data When Deleting Transactions or Lines.

This is very critical reference and we MUST treasure this. And I sincerely mean it.

VAIDY

GP Login with Active Directory - Is it really required?

Customers & Most of the Consultants vote YES. But some still believe that it's OK to have separate Login Credential for GP.

I also wonder whether we really require Active Directory Integrated Login for GP. What's so bugging if we have a separate login?

Pour your ideas and thoughts in here.

VAIDY

Microsoft Dynamics GP & CRM Adapter - Feature Pack 1 SDK Released

Inside Microsoft Dynamics GP announces the Release of Microsoft Dynamics GP 10.0 & CRM 4.0 Adapter Feature Pack 1 & SDK.

And this would mean a lot to existing customers who have implemented this Integration or on the verge of implementing it.

Personally I would like to explore this release to gain more information how to leverage my current GP CRM Integration Process.

All Consultants, Partners & Existing Customers, please do make a visit to the Article (link given above).

VAIDY

FRx 6.7 SP11 - Available Now

This is covered by In Touch With Dynamics. FRx 6.7 SP11 is available and it is the correct version.

VAIDY