This is the samples page for GP Power Tools for Microsoft Dynamics GP. On this page links to sample code for GP Power Tools customisations will be listed.
Go back to the main portal page using the URL: https://winthropdc.com/GPPT
Find this page using the URL: https://winthropdc.com/GPPT/Samples
Note: Examples listed for the Support Debugging Tool all work for GP Power Tools, but might not take advantage of the features added in later builds.
Benefits of using GP Power Tools
- #GPPT Replacing VBA with GP Power Tools – Developer Tools
- #GPPT Moving on from the Visual Basic for Applications (VBA) Mindset
- #GPPT Best Practices for Developing with GP Power Tools
- #GPPT Protecting Mission Critical Custom Code
- #GPPT Ensuring Custom Triggers Cannot Be Disabled
Must Have Free Customizations
- #GPPT Tracking changes to Customer and Vendor Cards Version 4
- #GPPT Tracking changes to Item Cards Version 3
- #GPPT Free SQL Search across Multiple Fields Lookup Example Version 2
- #GPPT Remotely requesting immediate Automatic Logout
- #GPPT Obscuring Bank Account Numbers in Microsoft Dynamics GP
- #GPPT Validating Australia Business Numbers (ABN)
- #GPPT Adding Multi Factor Authentication to the Microsoft Dynamics GP application
Allowing users to run SQL Scripts
- #GPPT Changing and Recalculating SOP Tax Rates
- #GPPT Building Self Service SQL Scripts
- #GPPT SOP Batch Maintenance Self Service Scripts
- #GPPT Renumbering SOP Transaction Lines
- Using the Support Debugging Tool to create user accessible SQL Scripts
- #GPPT Preventing Invalid Characters in Customer, Vendor and Item IDs
Adding Custom Fields to windows
- #GPPT Beginner’s Guide to Adding Custom Fields
- #GPPT Adding a Custom Salesperson ID Field with Lookup, Zoom and On-The-Fly Adds
- #GPPT Adding 6 Additional Item Category Fields
- #GPPT Adding a ListView (Grid) to any window
Adding Custom Windows
- #GPPT #VSIT Using a ListView to display data with a Custom Form
- #GPPT Implementing Custom Forms using GP Power Tools
- #GPPT Creating Additional .Net Dialog Windows using Scripts
- #GPPT Making the Multicurrency Access Setup window usable
Changing the default behavior of windows
- #GPPT Defaulting Customer ID and Vendor ID fields for new records
- #GPPT Using GP Power Tools to set default values on windows
- #GPPT Setting Default Sorts for Inquiry Windows
- #GPPT Reversing the sort order of the Item History window
- #GPPT Stopping Vendor ID Auto Populating on Payables Transaction Window
- #GPPT Making the Multicurrency Access Setup window usable
- #GPPT Preventing Invalid Characters in Customer, Vendor and Item IDs
Automating Dynamics GP Functionality
- #GPPT Automating Printing and Email of Sales Order Processing Documents
- #GPPT Controlling System Dialogs using Modal Dialog Focus Triggers
- #GPPT Automating or Customizing the Report Destination Window Revisited
- #GPPT Controlling Any Dialog. Automatic Email Login
Enhancing Dynamics GP Functionality
- #GPPT Adding Multi Factor Authentication to the Microsoft Dynamics GP application
- #GPPT Free SQL Search across Multiple Fields Lookup Example
- #GPPT Free SQL Search across Multiple Fields Lookup Example Version 2
- #GPPT Free Automatic Lookup Example
- #GPPT Preventing Inserting and Deleting of Sales Transaction Lines
- #GPPT Purchase Order Processing Lock Cost
- #GPPT Disabling Manual Entry of SOP Number Field
- #GPPT How to improve Dynamics GP with a little bit of GP Power Tools (Purchasing Transactions)
- Update: Resizing SmartList TreeView and ListView panes using the Support Debugging Tool
- Recurring Transactions and Record Notes
- #GPPT Validating Australia Business Numbers (ABN)
- #GPPT Linking to Document Management Systems
- Reminder to check Payables Remit to Address: #GPPT How to improve Dynamics GP with a little bit of GP Power Tools – Part 1
- #GPPT #VSIT Adding Windows to Microsoft Dynamics GP Menus with GP Power Tools
Auditing and Change Tracking
- #GPPT Tracking changes to Customer and Vendor Cards Version 4
- #GPPT Tracking changes to Customer and Vendor Cards Version 3
- #GPPT Tracking changes to Customer and Vendor Cards Version 2
- #GPPT Tracking changes to Customer and Vendor Cards
- #GPPT Tracking changes to Item Cards Version 3
- #GPPT Tracking changes to Item Cards Version 2
- #GPPT Using GP Power Tools to track specific changes Revisited
- #GPPT Using GP Power Tools to track specific changes
Importing Data
- #GPPT Using the Clipboard to copy from Excel into Microsoft Dynamics GP
- #GPPT Importing CSV Data using GP Power Tools
- #GPPT Automating Applying of Payables and Receivables Documents
- #GPPT Fixing ServiceUpdateVendor Web Service for Microsoft Dynamics GP 18.5
Working with Security
Customizing GP Power Tools
- #GPPT Remotely requesting immediate Automatic Logout
- #GPPT Automatic Logout Not Identifying Activity and Logging Out
- #GPPT Closing External Applications with Automatic Logout
Programming Techniques
- #GPPT Automating or Customizing the Report Destination Window Revisited
- #GPPT Iterating through a Dexterity Scrolling Window Sample
- #GPPT Moving on from the Visual Basic for Applications (VBA) Mindset
- #MSDynGP Development: Driving the User Interface of Microsoft Dynamics GP using Code
- #GPPT Best Practices for Programmatically Updating Fields on Windows
- #GPPT Forcing Exclusive Use of Microsoft Dynamics GP Windows
- #GPPT Parsing Returned SQL Data into Rows and Columns
- #GPPT Dexterity Samples for Datatype Conversions
- #GPPT Unknown Identifier Error when working against Modified windows
- How to dynamically modify Extender windows
Obscuring Table Data Fields
- #GPPT Obscuring Bank Account Numbers in Microsoft Dynamics GP
- Further Update: Obscuring Table Data Fields using the Support Debugging Tool
- Update: Obscuring Table Data Fields using the Support Debugging Tool
- Obscuring Table Data Fields using the Support Debugging Tool
Reports and Report Writer Functions
- #GPPT Speeding up Custom Report Writer Functions
- #GPPT Adding a QR Code to a GP Report Writer Report
- #GPPT Automating or Customizing the Report Destination Window Revisited
- #GPPT Modifying Reports based on Temporary Tables
- #GPPT Automating or Customizing the Report Destination Window
- #GPPT Reporting for Minnesota’s Wage Theft Law
- #GPPT Adding data from any SQL table to SOP Documents
- #GPPT Adding Vendor Item Number to SOP Documents
- How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool
- How to add Item Category Long Descriptions to reports using the Support Debugging Tool
- #GPPT Fixing the 80 character limitation for the rw_CreateSOPTrackingNumberString report writer function
Understanding Triggers and Logging Modes
- Understanding the Support Debugging Tool Series
- Understanding Support Debugging Tool Logging Modes
- Controlling Support Debugging Tool Manual Logging Mode
- Controlling Support Debugging Tool Automatic Debugger Mode
- Using Support Debugging Tool Non-Logging Triggers
Comments and Feedback
Please provide comments, feedback and suggestions for other GP Power Tools videos.
Last updated: 29-Apr-2024.
Winthrop Development Consultants Blog 