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: http://winthropdc.com/GPPT
Find this page using the URL: http://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
Must Have Free Customizations
- #GPPT Tracking changes to Customer and Vendor Cards
- #GPPT Free SQL Search across Multiple Fields Lookup Example
- #GPPT Free Automatic Lookup Example
Allowing users to run SQL Scripts
- #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
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
Changing the default behaviour 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
Enhancing Dynamics GP Functionality
- #GPPT Free SQL Search across Multiple Fields Lookup Example
- #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
Auditing and Change Tracking
- #GPPT Tracking changes to Customer and Vendor Cards
- #GPPT Using GP Power Tools to track specific changes Revisited
- #GPPT Using GP Power Tools to track specific changes
Working with Security
Programming Techniques
- #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
- 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 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
Understanding Triggers and Logging Modes
- 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: 19-Jan-2022.
David Musgrave's Winthrop Development Consultants Blog 