Sign In
Developing for Dynamics GP
by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)
Search Form
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Tags
ADO
Advanced Topic
Application
Best Practice
Blogsphere
C#
Community
Conference
Cross Dictionary
Customizations
Developer Toolkit
Development Tools
Dex.ini
Dexterity
eConnect
Exception
Extender
Fun
General
GP 2010
History
Hybrid
Inside Track
Integration
Integration Manager
Karl Gunderson
Language
Modifier
News
Newsgroups
Pages
Performance
Quick Tips
Report Writer
RW Functions
Security
Service Packs
SmartList Builder
SQL
Support
Support Debugging Tool
Tools
Training
Translation
VB
VBA
Visual Studio Tools
Web Services
Windows 7
Windows Phone
News
Dates of Interest
11-Jul-2008: Blog Created by David Musgrave.
03-Oct-2008: Syndicated to the
Dynamics Communities
.
10-Oct-2008: First Post by Scott Stephenson.
04-Nov-2008: First Post by Dave Dusek.
11-Nov-2008: First Post by Beth Gardner.
28-Nov-2008: First Post by Chris Roehrich.
30-Dec-2008: First Post by Patrick Roth.
24-Feb-2009: First Post by Greg Willson.
22-Apr-2009: First Post by David Clauson.
04-May-2009: First Post by Ryan Wigestrand.
19-Jun-2009: First Post by Dawn Langlie.
03-Jul-2009: First Post by Emily Halvorson.
23-Sep-2009: Created
Twitter account
with blog feed.
20-Nov-2009: First Post by Alice Newsam.
21-Apr-2010: First Post by Allan Cahill.
19-May-2010: First Post by Marian Verzosa.
24-May-2010: Blog Migrated to new Platform.
28-May-2010: Created
Facebook account
with blog feed.
15-Aug-2011: First Post by Development team.
05-Sep-2011: Created
http://aka.ms/Dev4DynGP
and
http://aka.ms/SDT
Shortened URLs.
Social Networking & Syndication
Follow David Musgrave and the blog on:
This blog at
Dynamics Communities
Shortened URLs
This Blog:
http://aka.ms/Dev4DynGP
SDT Portal:
http://aka.ms/SDT
Menus for VST:
http://aka.ms/MVST
Disclaimer
This blog is provided "AS IS" with no warranties, and confers no rights.
The links in this blog may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.
WorldMaps
WorldMaps Statistics since 24-Feb-2009:
Click for WorldMaps Stumbler
Translator Tool
Translate this page
Powered by
Microsoft® Translator
Links
Contents
General Articles & Links
Modifier & VBA Articles & Links
Dexterity Articles & Links
Developer Toolkit Articles & Links
Modifier & VBA Samples
Dexterity Samples
Developer & Consultant Articles & Links
Report Writer Articles & Links
Developer Toolkit Samples
Microsoft Dynamics GP Blogs
Support Debugging Tool Portal
Newsgroups & Forums Links
Microsoft Dynamics GP Community Forum
Great Plains Tek Tips Forum
Microsoft Dynamics GP Partner Forum
Microsoft Dynamics GP Blogs at Dynamics Communities
Blog Links
Dynamics GP Support and Services Blog
DynamicAccounting.net (Mark Polino's Blog)
The Dynamics GP Blogster (Mariano Gomez's Blog)
Microsoft Dynamics GP UK Blog
Microsoft Dynamics GP (Duke DelPrado's Blog)
Microsoft Dynamics GP Blogs Page
VSToolsForum.com (Steve Gray's Blog)
About Dynamics, Development and Life (Jivtesh Singh's Blog)
DynExtra (Habib Salim's Blog)
MSDynamicsWorld.com
The Death of Reason (Dwight Specht's Blog)
BlogMS - Official Microsoft Team Blogs
Dynamics GP Land (Christina Phillips, Steve Endow & Lorren Zemke's Blog)
Victoria Yudin's Blog
Dynamics GP Learn & Discuss (Vaidy Mohan's Blog)
Mohammad Daoud's Blog
Catherine Eibner's Blog
Rose Business Solutions Blog
Merit Matters Blog
GP2theMax (Frank Hamelly's Blog)
Dynamics Confessor Blogspot (Leslie Vail's Blog)
Interesting Findings & Knowledge Sharing (Sivakumar Venkataraman's Blog)
Njevity's Blog
Dynamics GP Middle East (Feradh Zain's Blog)
MBS Guru (Michael Johnson's Blog)
Inside Microsoft Dynamics GP (Official Blog)
ComputerationDynamics (Gloria Braunschweig's Blog)
Microsoft Dynamics Partner Community Blog
Q Factor's Blog (Constance Gilleland's Blog)
Dynamics Small Business (Matt Landis' Blog)
DynamicsBlogger (Janakiram M.P.'s Blog)
DynamicsGP.ie (Ian Stewart's Blog)
Dynamics Solution Edge (AMLLP Consulting's Blog)
Great Plains Guy (David Patrick's Blog)
Dynamics CPM (Corporate Performance Management)
Waqas Butt's Microsoft Dynamics GP Blog
eOne Business Solutions Blog
Real Life Dynamics User (Ron Wilson's Blog)
In Touch with Dynamics GP (Touchstone Group's Blog)
Dynamics GP - Knowledge Share (Sandip Jadhav's Blog)
Andy Nifong's Blog
Dynamics GP Builders & Reporting (Devon Southall's Blog)
Summit Group Software Blog
Belinda, the GP CSI (Belinda Allen's Blog)
GPWindow.com - Your window into Dynamics GP Resources
Dynamics Latam Blog
Dynamics for Distribution (Todd McDaniel's Blog)
Omar H. Kloub's Blog
Kuntz Consulting Blog (Jen Kuntz's Blog)
Aaron Berquist - High Dynamic Range
Dynamics GP Blog (Imtiaz Ahmed's blog)
Dynamics GP Help (Rubalpal Kaur's Blog)
Inside Dynamics GP Blog
Microsoft Dynamics GP Discussion (Samuel Mathew's Blog)
BKD Dynamics GP Insights Blog
Andrew Karasev's Blog
MonzerOsama.com (Monzer Osama's Blog)
azurecurve (Ian Grieve's Blog)
Microsoft Dynamics GP DBA (John Lowther's Blog)
Accidental Administrator (John Lowther's other Blog)
Resources Links
PartnerSource
CustomerSource
Microsoft Dynamics
Create Support Incident
Search Knowledge Base
Microsoft Dynamics GP Developer Center
Microsoft Connect: Add a Product Suggestion
Microsoft Dynamics GP Demo Site
Microsoft Dynamics Partner Solutions
ISV Central
Microsoft Dynamics Partner Community
Microsoft Dynamics ISV Solutions (PartnerSource)
Microsoft Dynamics GP Solution Center (PartnerSource)
GPWindow.com - Your window into Dynamics GP Resources
Microsoft Dynamics GP Community
Favourite Posts
GP Logos through the years
Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0
Support Debugging Tool for Microsoft Dynamics GP
Cross Dictionary Dexterity Development
How to get started with Dexterity
Support Debugging Tool - The wait is over
Choosing a Development Tool
Microsoft Dynamics GP Technical Airlift 2008
Menus for Visual Studio Tools - The wait is over
Finding Table and Field Information in Microsoft Dynamics GP
Microsoft Dynamics GP Application Level Security Series
Useful SQL Scripts Series
Support Debugging Tool Build 10 released
Translating Dexterity Applications Series
Why does Microsoft Dynamics GP encrypt passwords?
Support Debugging Tool Build 11 released
Automating Distribution of Customizations
Installing the Support Debugging Tool for Microsoft Dynamics GP FAQ
Understanding Cross Dictionary Dexterity Development
Microsoft Dynamics GP Technical Conference 2009 Wrap Up
Support Debugging Tool Build 12 released
Support Debugging Tool for Microsoft Dynamics GP 2010 Beta
Microsoft Dynamics Convergence Atlanta 2010 Wrap Up
Support Debugging Tool Build 13 released
Menus for Visual Studio Tools Build 9 Released
Getting the most out of your Microsoft Dynamics GP Community
Why can't I run Microsoft Dynamics GP via ODBC over a WAN?
Support Debugging Tool Build 14 released
Microsoft Dynamics GP Technical Conference 2011 - Wrap Up
The Great West Australian Bike Ride - Wrap Up
Microsoft Convergence 2011 Atlanta - Wrap Up
Support Debugging Tool Build 15 released
Support Debugging Tool Build 16 released
Microsoft Convergence 2012 Houston - Wrap Up
Archives
Archives
May 2012
(16)
April 2012
(14)
March 2012
(20)
February 2012
(13)
January 2012
(10)
December 2011
(10)
November 2011
(13)
October 2011
(10)
September 2011
(19)
August 2011
(17)
July 2011
(7)
June 2011
(12)
May 2011
(10)
April 2011
(21)
March 2011
(28)
February 2011
(13)
January 2011
(15)
December 2010
(13)
November 2010
(16)
October 2010
(18)
September 2010
(20)
August 2010
(22)
July 2010
(22)
June 2010
(22)
May 2010
(23)
April 2010
(22)
March 2010
(17)
February 2010
(20)
January 2010
(19)
December 2009
(14)
November 2009
(19)
October 2009
(18)
September 2009
(19)
August 2009
(23)
July 2009
(19)
June 2009
(17)
May 2009
(17)
April 2009
(19)
March 2009
(24)
February 2009
(20)
January 2009
(20)
December 2008
(17)
November 2008
(21)
October 2008
(23)
September 2008
(17)
August 2008
(15)
July 2008
(31)
May, 2009
MSDN Blogs
>
Developing for Dynamics GP
>
May, 2009
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Developing for Dynamics GP
Understanding how Microsoft Dynamics GP works with Microsoft SQL Server continued
Posted
over 3 years ago
by
David Musgrave
6
Comments
As a followup to last week's post about Understanding how Microsoft Dynamics GP works with Microsoft SQL Server , I am adding a few more topics about why Microsoft Dynamics GP works the way it does with Microsoft SQL Server. So here goes .... Transactions...
Developing for Dynamics GP
Controlling the size of the Body section on Reports
Posted
over 3 years ago
by
David Musgrave
3
Comments
The question of how to control the size of the body section of a document such as Sales Order Processing (SOP) Orders and Invoices or Purchase Order Processing (POP) Purchase Orders has come up a number of times before. It was asked again on a Community...
Developing for Dynamics GP
RW - Showing the Full Item Description on Invoices Example
Posted
over 3 years ago
by
David Musgrave
5
Comments
When the inventory module of Microsoft Dynamics GP was first written the Item Description field was 60 characters long. A few versions ago it was extended to 100 characters. While this allows for a longer description to be entered, it has created three...
Developing for Dynamics GP
Understanding how Microsoft Dynamics GP works with Microsoft SQL Server
Posted
over 3 years ago
by
David Musgrave
13
Comments
Many people who have not been working with Microsoft Dynamics GP since the early non-SQL versions of Great Plains Dynamics sometimes wonder about the way that the application works with Microsoft SQL Server. The answer is in the long history of the...
Developing for Dynamics GP
What Happens to your Product Feedback?
Posted
over 3 years ago
by
David Musgrave
0
Comments
A while back Scott Stephenson took us through the process of providing product feedback and suggestions for enhancements with his Providing product feedback using Microsoft Connect post. Now, on the Inside Microsoft Dynamics GP blog, Pam Misialek explains...
Developing for Dynamics GP
Development White Papers for Download
Posted
over 3 years ago
by
David Musgrave
2
Comments
I recently came across some development tool based White Papers which are available for download from Microsoft Downloads. I thought I would highlight them as they are worth a read: Creating a Windows Service That Uses eConnect to Integrate Data ...
Developing for Dynamics GP
Cannon P.I. - To Catch An Eagle - The Secret Platform
Posted
over 3 years ago
by
David Musgrave
2
Comments
Just when you thought it was safe ..... Cannon P.I. is back. Following on from the Title Sequence video.... Welcome to Episode #1. In this episode watch Cannon PI, a no-nonsense problem solver and his sidekick "Jim" as they help two developers get...
Developing for Dynamics GP
RW - Making a One-to-Many Table Relationship behave as One-to-One
Posted
over 3 years ago
by
David Musgrave
2
Comments
One of biggest issues people have with the Microsoft Dynamics GP Report Writer is not being able to create the desired table relationships from tables on the report to other tables so that the other tables can be added to the report and behave correctly...
Developing for Dynamics GP
How to access a Third Party Table Buffer on a Cross Dictionary Procedure Trigger
Posted
over 3 years ago
by
Dave Dusek
0
Comments
This particular situation has come up in a number of support incidents and I also run into this myself on occasion. The situation is that you have a cross dictionary procedure or function trigger on a script and one of the parameters is a third party...
Developing for Dynamics GP
How Many Lines can a Transaction have? and more Dynamics GP blogs
Posted
over 3 years ago
by
David Musgrave
1
Comments
The blogsphere continues to be a source of great information for the entire Microsoft Dynamics GP community. The Dynamics GP Blogster , Mariano Gomez, has tackled the age old question of Is there a maximum number of lines that can be inserted in any...
Developing for Dynamics GP
RW - Can I print Page Numbers including the Total Number of Pages?
Posted
over 3 years ago
by
David Musgrave
5
Comments
The question in more detail is whether it is possible to print "Page: Y/X" or "Page: Y of X" on a Report Writer report, where Y is the current page number and X is the total number of pages for the report. This question was asked again on the Partner...
Developing for Dynamics GP
Cannon P.I. hits the screens
Posted
over 3 years ago
by
David Musgrave
0
Comments
Hi there This is a teaser video for a series of videos that the Microsoft Web Platform team are putting together. If you remember the TV show Magnum P.I., you will love this. Have a look at the first episode: To Catch An Eagle - The Secret...
Developing for Dynamics GP
Using the Support Debugging Tool with Function and Procedure parameters
Posted
over 3 years ago
by
David Musgrave
1
Comments
The Support Debugging Tool for Microsoft Dynamics GP has the ability to create triggers against Functions and Procedures (both global level and form level). While this functionality allows us to identify when a particular function or procedure has been...
Developing for Dynamics GP
VBA - Preventing backdated transactions using Visual Basic
Posted
over 3 years ago
by
David Musgrave
1
Comments
Another recent request was to provide a method to prevent backdated transactions from being entered into Microsoft Dynamics GP. This means that we needed to validate the document date of a transaction as it as entered and again when it is saved. This...
Developing for Dynamics GP
RW - Getting RW_ConvertToWordsAndNumbers() to work with multi-currency
Posted
over 3 years ago
by
David Musgrave
5
Comments
I recently had a support case where the partner consultant was trying to use the RW_ConvertToWordsAndNumbers() report writer user defined function to display the Purchase Order total in words at the bottom of the document. They were using the POP Purchase...
Developing for Dynamics GP
Upcoming Microsoft Dynamics GP Workshops
Posted
over 3 years ago
by
Ryan Wigestrand [MSFT]
4
Comments
There are two Microsoft Dynamics GP workshops that have been scheduled to take place in Fargo, ND, USA the first week of June. We will be offering this workshop to both Partners and Deluxe/Premier Customers. The instructors for these workshops will be...
Developing for Dynamics GP
Adding AutoComplete Items with Dexterity
Posted
over 3 years ago
by
Dave Dusek
2
Comments
This is a quick and easy way to add items to the AutoComplete list for a field. I'm talking specifically about the AutoComplete property on a field. In this case, the customer didn't want to use the lookup window to select an existing item number,...
Page 1 of 1 (17 items)