A little while ago, I posted an example of Obscuring Table Data Fields using the Support Debugging Tool.
During my recent Dexterity Training class, I showed this example to the attendees and was asked about how the obscuring worked with reports.
So, as a test, we printed the RM Customer Report from the Customer Maintenance window to find that the Credit Card Number on the report was still obscured.
The RM_UNOBSCURE Non-Logging Trigger did not fire with the Report Writer and so the data is shown as it is stored in the table.
To resolve this issue I used the Support Debugging Tool's Runtime Execute window to create a Report Writer function based on the rw_TableHeaderString function.
To use the Report Writer function, modifiy the report and create a calculated field which calls the User Defined function rw_TableHeaderString in the system series.
Below are parameters you need to pass through to the rw_TableHeaderString function:
Then drag the calculated field on to the report and hide or remove the original field.
(c) Credit Card Number = FUNCTION_SCRIPT( rw_TableHeaderString 5261 "RW_UNOBSCURE" RM_Customer_MSTR.Credit Card Number 4 4 )
For a credit card number of 1234-5678-9012-3456, the calculated field above will show 1234-XXXX-XXXX-3456.
I have updated the archive attached to the original post (Obscuring Table Data Fields using the Support Debugging Tool) to include the RW_UNOBSCURE Runtime Execute script as well as a modified example of the RM Customer Report.
The Support Debugging Tool Debugger Settings file with these triggers is also attached as an archive to the bottom of this post.
Note: The function used for this example ito obscure the data is a very simple algorithm built into Dexterity and is only meant to stop the data from being easily readable. It is NOT secure and does not meet any compliance standards for encryption of personal data. Use at your risk.
If you want proper encryption of Credit Card details, there are solutions from Independent Software Vendors (ISVs) for Microsoft Dynamics GP.
Let me know what you think of the update.
Posting from Mark Polino at DynamicAccounting.net
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.