jkane
(John Kane)
October 8, 2025, 4:27pm
52
Everyone should do what I did for my Inspection Plan report and add the related to sysrowid to all of the tables. The BPM is really easy and I am sure there is a way to update the existing data.
BPMs
The first thing we need to do is create a UD Column for every InspResultsXXX table. I called the column RelatedToSysRowID and set the field as a string.
Next thing we need to do is create a Method Directive and some Data Directives. The Method directive is on Erp.ConfigurationRuntime.PreStartConfiguration and is Post Processing. We are capturing the GUID of the InspResults row and saving it to a BPM Data Field. Then we need to create an In-Transaction Data Directive for each InspResultsXXX table to put the SysRowID we captured in the UD column we created.
This allows us to ensure that if there are multiple plans on an operation that we can match the inspection data correctly.
3 Likes