Developing for Dynamics GP

by Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Browse by Tags

Tagged Content List
  • Blog Post: Identifying where SmartList Column Data comes from

    Recently, I had a support case which asked the following: "When I go to Add the Sales Account Number to the Sales Line Items SmartList, there are three Sales Account Number Columns available. What is the difference between them?" So, I wanted to work out a method to make it fairly easy for customers...
  • Blog Post: Quick Tip: Where does that customisation come from?

    I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots. The answer to the question is that the method to change the URL depends on what tool was...
  • Blog Post: Quick Tip: VBA ADO Connection Run-time error '3709'

    It has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while. When using VBA on a window with ActiveX Data Object (ADO) to connect to SQL Server to read and/or write data to tables, the best practice is to...
  • Blog Post: Edits To Dynamics Launch File Won't Save

    My blog post today isn't anything earth shattering but something a partner ran into that was unexpected. Logical - but unexpected nonetheless. A recent forum post detailed how the user was trying to set forms & reports dictionary paths using the Edit Launch File window. What they found was that...
  • Blog Post: Changing the Phone Number Format

    One of the most common customisations outside of North America is changing the Phone Number Format. The North American default format of (XXX) XXX-XXXX Ext. XXXX is not always suitable for other countries. For example: Australia, Singapore and Malaysia now use a domestic format of a 2 digit area code...
  • Blog Post: Why does Microsoft Dynamics GP 10.0 and later use a Data Folder?

    I recently responded on a forum post which asked why the paths for the custom forms and reports dictionaries in the Dynamics.set launch file where pointing to the Data folder. The post also asked why the application did not complain about the fact that the dictionaries listed in the Dynamics.set did...
  • Blog Post: Quick Tip: Solving "Do you want to Save?" dialog appearing after VBA customization

    Have you ever used Modifier and Visual Basic for Applications (VBA) to add an additional field to a window? Have you then had the issue when navigating through records on that window, it keeps coming up and asking " Do you want to Save, Discard or Cancel? " or " Do you want to Save, Delete or Cancel...
  • Blog Post: 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...
  • Blog Post: Avoiding VBA Circular References when using a Dynamics GP Lookup

    Honestly, I struggled a bit on the title of this article. Is this article to show one way to use a Dynamics GP lookup window in your Modifier/VBA customization? Or is it an article that shows a way to work around the circular reference problem that you can get yourself into when using VBA across projects...
  • Blog Post: Errors when importing Customization Maintenance Packages

    Today, I had a support case that was asking about errors when importing a package via Customization Maintenance (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance). The partner was unable to find an explanation of the errors on the Internet and so I thought I...
  • Blog Post: 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...
  • Blog Post: Smartlist: Splitter control in Smartlist window doesn't work

    Last week , I enumerated several questions that I've been asked and have seen posted to the public Dynamics GP newsgroups. These questions are typically of the "Why doesn't Smartlist..?" variety. In this post and a few planned future posts, I'll look at each of these questions individually and give...
  • Blog Post: 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...
  • Blog Post: Smartlist: Only the data area should grow

    I've seen several questions over the years on Smartlist of the "Why doesn't it?" variety such as: Why does Smartlist export to Excel so slowly? Because Smartlist exports row by row and sets each cell individually. Why does Smartlist automatically try to display the default Smartlist when...
  • Blog Post: Checklist for creating a new Dexterity Window

    Today, we go back to basics. It is always good to make sure that we have the foundations handled properly. When I teach the Dexterity, I always go through the standard checklist below for creating (or modifying) Dexterity windows. This checklist is valid for Dexterity when creating new windows or...
  • Blog Post: Hybrid - Setting a push button to Hyperspace

    Trivia question for today: Given the following sequence of events: In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in "AARON". The user then presses the associated lookup button. What happens? A. Focus moves to the button causing the field change script...
  • Blog Post: Hybrid Development and Continuum

    In the past, I was known for my pioneering work with and promotion of Cross Dictionary Dexterity Development . More recently I have been talking up the benefits of Hybrid Development and Developing Outside of the Box . With all the tools available to the Microsoft Dynamics GP developer, and each tool...
  • Blog Post: Understanding Cross Dictionary Dexterity Development

    A recent newsgroup post has raised the question of whether it is possible to customise an alternate form using Dexterity. This is covered on my earlier blog post: Can I customise a 3rd party form with Dexterity? However, I thought I would try and clarify what can be achieved with Dexterity for each...
  • Blog Post: Modifier - How to Expand the GL Transaction Entry Scrolling Window Example

    One of the customisations that I have heard requests for a number of times is to open the General Ledger Journal Entry (GL Transaction Entry) window's scrolling window (grid) to its expanded state when the window is opened. The method to make this happen is to use Visual Basic for Applications (VBA...
  • Blog Post: Removing References to Fields in VBA Revisited

    Michael Johnson (the MBS Guru ) has posted a great article about removing invalid references from a Visual Basic for Applications (VBA) project. This has prompted me to revisit the topic and gather together all the relevant resources from a number of blog authors. A few months back, Mohammad Daoud...
  • Blog Post: 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...
  • Blog Post: What is the Dynamic User Object Store (DUOS)

    The Dynamics GP Blogster , Mariano Gomez, has written a great article on the Dynamic User Object Store (DUOS). One of the great things about the DUOS is that it is a table easily available for a developer to use however they want from Dexterity (table SY_User_Object_Store), from SQL Server (SY90000...
  • Blog Post: Creating SQL Views of DUOS Data

    Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields. The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in a string field 132 characters long. Below is...
  • Blog Post: Free Visual Basic for Applications Workshop

    Mariano Gomez aka The Dynamics GP Blogster is running an online (blog based) workshop to show how to use Modifier and VBA (Visual Basic for Applications). Have a look at the introductory post using the link below. It will explain the prerequisites and has the links to the posts for Workshop Days 1...
  • Blog Post: Handling Translation when Customizing with VBA

    From the Translating Dexterity Applications Series . The final topic in the series is one that was added later after I was asked about how to handle translated applications when writing customizations. Most code would work fine as it is independent of the language. However, it is common in Visual...
Page 1 of 2 (49 items) 12