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…

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

@Aaron_Moreng This is what I got: I created a variable named PreviousReqByDate and set the value with the dsJobHeadRow.ReqDueDate. [image] I set the value here by clicking on the Action link: [image] However, the old date is not there. Only the new date. Thanks.

Store the old data in pre processing in a callcontex field

@josecgomez I stored the date in a callcontext field like this, one for the dsJobHeadRow and one for the ttJobHeadRow: [image] [image] However, I still can’t get the old date. Both fields contain the new date. Am I doing it right? Thanks.

[image] BPM to email before and after values ERP 10 e10 epicor bpm When anyone changes an OrderHed.NeedByDate or OrderHed.RequestDate we w…

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

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()

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

BPM Method Directive Store Previous Value

Epicor ERP 10

Aaron_Moreng (Aaron Moreng) February 21, 2019, 3:43pm 6

Topic		Replies	Views
BPM to email before and after values Epicor ERP 10 e10 , epicor , bpm	10	3169	March 31, 2017
BPM to Email Changes Epicor ERP 10 bpm	12	2817	December 18, 2022
Data Directive Epicor ERP 10 e10 , bpm	18	10418	March 13, 2020
BPM data directive? store old data before update Yahoo Archive	3	2256	November 25, 2015
Get Original Value of Date Changed in Data Directive Epicor ERP 10 data-directive	3	1249	February 2, 2022

BPM Method Directive Store Previous Value

Related topics