Developing for Microsoft Dynamics GP

May 2009 - Posts

• 0 Comments 1,162 Views

  Bing is here Going live this week is Bing . Not just another search engine, it is decision engine. Please watch this video to understand what makes Bing so cool. Bing - A better way to search from Microsoft Bing is a new search engine designed to do more than merely... Read More... Published: Sunday, May 31, 2009, 05:00 PM Tags: Blogsphere, News, General

• 0 Comments 1,780 Views

  Understanding how Microsoft Dynamics GP works with Microsoft SQL Server continued 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... Read More... Published: Thursday, May 28, 2009, 05:00 PM Tags: Dexterity, History, Application, SQL

• 0 Comments 1,623 Views

  Controlling the size of the Body section on Reports 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... Read More... Published: Wednesday, May 27, 2009, 01:00 AM Tags: Application, Report Writer

• 0 Comments 1,606 Views

  RW - Showing the Full Item Description on Invoices Example 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... Read More... Published: Sunday, May 24, 2009, 05:00 PM Tags: RW Functions, ADO, VBA, Report Writer

• 0 Comments 1,970 Views

  Understanding how Microsoft Dynamics GP works with Microsoft SQL Server 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 product... Read More... Published: Thursday, May 21, 2009, 05:00 PM Tags: Dexterity, History, Application, SQL, SmartList Builder

• 0 Comments 1,185 Views

  What Happens to your Product Feedback? 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... Read More... Published: Wednesday, May 20, 2009, 05:00 PM Tags: Features, General, Application, Enhancements, Suggestions

• 0 Comments 1,521 Views

  Development White Papers for Download 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 This... Read More... Published: Tuesday, May 19, 2009, 05:00 PM Tags: eConnect, Dexterity, Visual Studio Tools, C#, VB

• 0 Comments 1,476 Views

  Cannon P.I. - To Catch An Eagle - The Secret Platform Just when you thought it was safe ..... Cannon P.I. is back. 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 their web developer platform setup and ready... Read More... Published: Monday, May 18, 2009, 05:00 PM Tags: Blogsphere, Fun

• 0 Comments 1,255 Views

  RW - Making a One-to-Many Table Relationship behave as One-to-One 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... Read More... Published: Sunday, May 17, 2009, 05:00 PM Tags: Report Writer

• 0 Comments 1,613 Views

  How to access a Third Party Table Buffer on a Cross Dictionary Procedure Trigger 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... Read More... Published: Thursday, May 14, 2009, 05:00 PM Tags: Dexterity, Best Practice

• 0 Comments 1,389 Views

  How Many Lines can a Transaction have? and more Dynamics GP blogs 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 given... Read More... Published: Wednesday, May 13, 2009, 05:00 PM Tags: eConnect, Blogsphere, Application

• 0 Comments 1,855 Views

  RW - Can I print Page Numbers including the Total Number of Pages? 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... Read More... Published: Tuesday, May 12, 2009, 05:00 PM Tags: ADO, VBA, Report Writer

• 0 Comments 1,460 Views

  Cannon PI hits the screens 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. Enjoy. David Read More... Published: Monday, May 11, 2009, 05:00 PM Tags: Blogsphere, Fun

• 0 Comments 1,326 Views

  Using the Support Debugging Tool with Function and Procedure parameters 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... Read More... Published: Sunday, May 10, 2009, 05:00 PM Tags: Tools, Dexterity, Support Debugging Tool

• 0 Comments 1,571 Views

  VBA - Preventing backdated transactions using Visual Basic 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... Read More... Published: Thursday, May 07, 2009, 05:00 PM Tags: VBA

• 0 Comments 1,517 Views

  RW - Getting RW_ConvertToWordsAndNumbers() to work with multi-currency 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... Read More... Published: Tuesday, May 05, 2009, 05:00 PM Tags: RW Functions, Report Writer

• 0 Comments 1,470 Views

  Upcoming Microsoft Dynamics GP Workshops 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... Read More... Published: Sunday, May 03, 2009, 05:00 PM Tags: Training, eConnect, Workshops, Integration Manager