BPM Method Directive Store Previous Value

Epicor ERP 10
,
1

Hello,

I created a Pre-Processing directive that sends an email notification when the JobHead Required Due Date changes.

image

It works, but I have a problem with a requirement. The email should contain the old and the new date.

I created a variable to store the old date, but it is not working. Once the email is sent, the old and new date are the same, both have the new date.

How can I store the old date and then use it in the email?

Thanks.

2

You’re going to want to store the old date in a local variable and reference the new date (hint: Updated Row) and display the local variable and the new date in the email

3

@Aaron_Moreng

This is what I got:
I created a variable named PreviousReqByDate and set the value with the dsJobHeadRow.ReqDueDate.

image
image.png748×676 27.9 KB

I set the value here by clicking on the Action link:

image
image.png706×564 15.7 KB

However, the old date is not there. Only the new date.

Thanks.

4

Store the old data in pre processing in a callcontex field

5

@josecgomez

I stored the date in a callcontext field like this, one for the dsJobHeadRow and one for the ttJobHeadRow:

image
image.png899×647 41.5 KB

image
image.png904×672 41.5 KB

However, I still can’t get the old date. Both fields contain the new date. Am I doing it right?

Thanks.

6
7

You have to pull the OLD date out of the database, you can’t assign it form the ttTable.

2 Likes
8

So in your Specify Expression Window, replace dsJobHeadRow.ReqDueDate with this

(from x in Db.Jobhead where x.Company == dsJobHeadRow.Company && x.JobNum == dsJobHeadRow.JobNum select x.ReqDueDate).FirstOrDefault()
1 Like
9

Thank you all.
I created the query and retrieve the old value. Everything is working now.

Thanks again.

1 Like