This is another update to the previous versions of the change tracking projects for Customer and Vendor cards:
Based on the version 4 projects, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.
[Edit] Version 6 of the Customer and Vendor Change Tracking is now available for Build 32 or later:
Version 4 of the Customer and Vendor Change Tracking is available for Build 31 or earlier:
The project has been updated to use a Custom Table to define the GPPT_Vendor_Tracking and GPPT_Customer_Tracking SQL tables, and the triggers and runtime execute scripts have been updated use the Custom Table Buffer Helper Functions and Memory Parameters.
Below are screenshots of the two projects showing the components. Here is CUST TRACKING project:
And the VEND TRACKING project:
To enable the emailing, make sure you can send an email using the Send Email window. You can change the settings used in the Email Settings window.
Note: If you have issues with SMTP, try using the SMTP via .Net Addin mode rather than the SMTP via CDO mode as it can better handle modern authentication requirements.
Then edit the trigger scripts (1 to 4 for both projects) and insert the desired email address to send the notifications to in the MBS_Email_To field. You can also add MBS_Email_CC and MBS_Emal_BCC addresses, or change subject and body text, if you wish.
Customer Triggers: CUST TRACKING 1 to 4
Vendor Triggers: VEND TRACKING 1 to 4
WARNING: If you already have the previous versions installed, please make a note of the Fields included if you have changed the field lists before importing, so you can remake the changes after installing the updated projects.
Downloading and Installing
Download the example code, import using the Project Setup window. If importing over a previous version, select the Remove Project objects not being imported to remove the now obsolete components of the previous projects:
The code will be active on next login or after switching companies, or you can use start the triggers manually from the Project Setup window.
More Information
For more information see:
- #GPPT Tracking changes to Customer and Vendor Cards Version 6
- #GPPT Tracking changes to Customer and Vendor Cards Version 5
- #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 4
- #GPPT Using GP Power Tools to track specific changes
- #GPPT Using GP Power Tools to track specific changes Revisited
- GP Power Tools Portal: http://winthropdc.com/GPPT
- GP Power Tools Samples: http://winthropdc.com/GPPT/Samples
- GP Power Tools Videos: http://winthropdc.com/GPPT/Videos
Hope you like the updates taking advantage of the Custom Tables and Custom Table Buffers added in Build 32.
David
05-Aug-2025: Added links to Version 6 article.
This article was originally posted on http://www.winthropdc.com/blog.
5 thoughts on “#GPPT Tracking changes to Customer and Vendor Cards Version 5”