Modifier with VBA for Microsoft Dynamics GP 2010 Sample Applications

Use these Modifier with VBA sample applications as examples of code that you can use in your applications.
  • Version:


    File Name:


    Date Published:


    File Size:

    510 KB

      This download contains various sample applications created and tested for use with Microsoft Dynamics GP 2010. Each .zip file contains a readme that explains what is supported with the sample and how to effectively use it.

      The following samples are included:
      • – Demonstrates the addition of batch-level security for Sales Transaction Entry.
      • Customer – Demonstrates how to default the sort order of the Customer and Prospects lookup window by Customer Name instead of by Customer ID.
      • – Shows how to use a Microsoft Dynamics GP customer report and VBA along with Excel.
      • – Demonstrates how to use the new 'UserInfoGet' connection object along with Microsoft ActiveX Data Objects (ADO) to retrieve data from a Microsoft Dynamics GP company database.
      • – Demonstrates how to use ActiveX Data Objects (ADO) to display the total quantity available for each item in the Item Lookup window.
      • – Demonstrates how to place the Due Date field in the Payables Transaction Entry window so the due date can be viewed. Also explains how to update the value from the Payables Payment Terms Entry window.
      • – This sample uses ADO to query the company database to display the Customer PO Number for each document in the Apply Sales Documents detail window.
      • – Automatically opens the SOP Markdown Entry window after a user enters an item number in the SOP Sales Transaction Entry window. This example also prevents the user from entering flat amounts and requires them to enter only a markdown percentage.
      • – Shows how to use VBA code to make Sales Order Processing (SOP) User Defined fields required when entering a SOP document in the Sales Transaction Entry window.
      • – Shows how to use VBA code to allow the user to display and update Sales Order Processing User Defined fields from the main Sales Transaction Entry window.
      • – demonstrates how to default the sort order of the Vendors lookup window by Vendor Name instead of by Vendor ID.
  • Supported Operating System

    Windows 7, Windows Server 2003, Windows Server 2008, Windows Vista, Windows XP

      • To view the .rtf documents, you'll need a copy of Microsoft Office Word 2007, or Microsoft Word 97 or later with the free Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats.

      • For information about the system requirements for Microsoft Dynamics GP 2010, see the documentation and resources for Microsoft Dynamics GP 2010.
      1. Click Download to save the file to your computer.

      2. Double-click the GP2010ModifierVBASamples.exe file on your computer and extract the contents.

      3. Double-click each .zip file and extract the individual components for the samples.
    • All sample code used in production applications will need to be fully understood and maintained by the application developer.