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
- #GPPT Replacing VBA with GP Power Tools – Developer Tools
- #GPPT Moving on from the Visual Basic for Applications (VBA) Mindset
- #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 2
- #GPPT Tracking changes to Item Cards Version 2
- #GPPT Free SQL Search across Multiple Fields Lookup Example Version 2
- #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 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 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
Automating Dynamics GP Functionality
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
Auditing and Change Tracking
- #GPPT Tracking changes to Customer and Vendor Cards
- #GPPT Tracking changes to Customer and Vendor Cards Version 2
- #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
Working with Security
Programming Techniques
- #GPPT Automating or Customizing the Report Destination Window Revisited
- #GPPT Creating Additional .Net Dialog Windows using Scripts
- #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 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
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: 06-Mar-2023.