MVP updates: Victoria Yudin's MVP status renewed and Leslie Vail's Developing Microsoft GP Business Applications book

I am still on leave for another week, but thought I would post about some updates from our Most Valuable Professional (MVP) community. Victoria Yudin has been awarded MVP status for the ninth consecutive year. Well done on the fantastic achievement. Have a look at her article below: Happy New Year – 2013   Leslie Vail…

1

Quick Tip: Working with VBA, Extender and Sales Transaction Entry

I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server. The project involved…

1

The Importance of Selecting the Correct Extender Key Fields

I have had a couple of recent cases which highlighted the importance of selecting the correct Key fields when creating Extender objects. Both of the cases involved adding additional user defined fields to an existing Microsoft Dynamics GP window using an Extender Window Object. In both cases, the incorrect fields were selected in the Key…

2

How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool

Here is another support case that was resolved simply and quickly using the Support Debugging Tool. The customer was using Extender to add an additional comment to the inventory stock transfer transaction. They created an Extender ID “ST_COMMENTS” and used the Long String field type in Extender which is a 255 character string. This worked…

3

Determining Role Access To Extender Objects

An Extender case came up recently where the customer was having security issues with Extender forms. To solve the issue, we needed to determine which Security Roles have access to particular Extender forms. Note: This method uses the DYNAMICS.dbo.EXT00001 table which was added for version 10.0 Service Pack 4 and later. We were able to…

1

Dynamics GP Customizations Summary

First Jivtesh Singh creates the awesome portal site GPWindow.com and now he starts using it to gather all the best posts together. His latest blog post covers Microsoft Dynamics GP Customization with its many tools and methods and highlights a large number of fantastic posts from around the community. This post is well worth a…

1

VBA - Displaying Extender Data for GL Transaction Lines on the GL Inquiry window

You might remember last month when we had a support case where the customer wanted to use Extender additional information against the General Ledger Journal Entry (GL_Transaction_Entry) distribution lines.  We discovered that the Sequence Line field needed for the unique identifier for the line record was not populated until the line was saved.  This meant…

5

VBA - Adding Extender Windows to GL Transaction Entry Lines

Last week I had an interesting support case that I thought I would share with you. The customer had created an Extender window to capture additional information for distribution lines on the General Ledger Journal Entry (GL_Transaction_Entry) window. The unique identifier for a distribution line is the Journal Entry field from the main window and the Sequence Line field…


Microsoft Dynamics GP 2010 Technical Web Seminars

With the release of Microsoft Dynamics GP 2010 this is THE place to get ready to learn about this release, innovative development tools, best practices and more. Help ensure your PEOPLE are your most powerful asset by gaining technical readiness for Microsoft Dynamics GP 2010.  Learn about the new features and tools by attending the…

2

Microsoft Dynamics Convergence Atlanta 2010 Wrap Up

I am finally back home in Perth and the time has come to wrap up my first Convergence (and my first trip to Atlanta, Georgia, USA).  The trip was a great success and Mariano and I will hopefully be given the opportunity to come back and present again. It was worth the 27 hours flying to get to Atlanta…

2

Removing Extender Data when deleting Transactions or Lines Revisited

Last week, I tackled the subject of orphaned records in the Extender tables when the parent records were deleted and the Extender data was left behind.  If you have not read this post the link is below: Removing Extender Data when deleting Transactions or Lines If you read through the comments, you will see that…

1

Removing Extender Data when deleting Transactions or Lines

I was recently asked to assist a colleague with an Extender case.  The problem was that Extender data was not being removed from the Extender SQL tables when its parent record was deleted. The issue of Extender data being orphaned when the parent data is deleted is a known issue (KB 906242 see link below) and can be…

8

Dynamics GP 2009 Year End Update Warning

<BEEP>  Today’s post is a public service announcement.  We will return to our regularly scheduled blog next week. If using Microsoft Extender product DO NOT use the 2009 U.S. Year End Update for Microsoft Dynamics GP 10.0 that is found at https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye10.htm?printpage=false . The specific issue is that the update will delete your Extender definitions and data with the only…

1

Microsoft Dynamics GP Technical Conference 2009 Training Opportunities

As you know, I have been encouraging all technical partner consultants and developers to register for and attend the upcoming Microsoft Dynamics GP Technical Conference 2009 in November.  Well, the reason is not just because I will be there presenting a couple of sessions with my good friend Mariano. Also, it is not just that the conference…

2

Extender is coming, what now for the other customization tools

You may has seen that Microsoft Dynamics GP v10.00 Service Pack 4 will include a number of new features to the Extender product. Please see the information on blog posts on the Inside Microsoft Dynamics GP blog and US Microsoft Dynamics GP Field Team blog: Get more out of your existing solution with Extender  New…

3

Tools Sessions at Convergence 2009

If you are going to Convergence 2009 in New Orleans between the 10th and 13th of March 2009, make sure you attend the various sessions about the Microsoft Dynamics GP development and customization tools. Below are the details of the sessions:  GP04 Building Personalized Solutions using Modifier with VBA for Microsoft Dynamics GP Beth Gardner Explore…

3

Creating SQL Views of Extender Data

Extender can create SQL views of the data in an Extender window which allows the data to be viewed as a single row in the view even though the actual data is stored as a multiple records across multiple tables (depending on data type). This view can then be used by SmartList Builder to show…

14

Report Writer Articles & Links

This is a page to provide links to Report Writer related articles and materials. Troubleshooting Knowledge Base (KB) Articles How to use and troubleshoot Report Writer in Microsoft Dynamics GP (KB 861803)  How to re-create the Reports.dic file in Microsoft Dynamics GP (KB 850465)    Report Writer Functions Knowledge Base (KB) Articles  How to access…