Set task Due Date to Milestone Date

Kinetic ERP
1

We have a classic screen that calls a BPM when a new task is added and the update button is clicked.

image
image1031×387 28.5 KB

image
image1039×370 23.9 KB

The Data Directive is an In-Transaction Data Directive.

image
image869×543 25.4 KB

The intent was to apply the due date of the milestone to the new task when a new task was added.

The logic in the custom code loops through the task temp table, then tries to find the details from the TaskSDtl table, do some logic and assigned task.DeDate

image
image1172×408 36.4 KB

From testing I have found the Task temp table row has no TaskSetID nor a TaskSetSeq resutling in no rows returned which makes the result for details null.

image
image1088×40 4.03 KB

Is this not possible in a In-Transaction Data Directive that runs just before writing to the table?

2

For some processes, the records are first created with blank data, and then immediately after are updated with the data. I’d put in messageboxes that display all the data from all rows in the temp table, find what exactly is happening. You can also do tracing though I don’t usually have much luck with it.