We are creating a business event to trigger an email if a POLine Promised Date changes by more than a certain amount. The logic for the comparison is, if the change in date of the Promised Date is greater than 20% of the difference between the old Promised Date and Today() we want to trigger the email. I cannot figure out how to reference both the old and new value in the Trigger Conditions to achieve the desired result. I can’t be sure, but from my testing, if I chose Operation: New Field Value or Old Field Value, the value of Promised Date field on both sides of the Condition are value as specified in the Operation. How can I get both new and old values together in an expression to compare these to decide if the date change was significant enough to trigger the Email Subscriber?
+10I don’t believe you can use Data Field as both side of equation. What you can do is to add a custom field to the POLine and either using a Graph Extension assign a true/false or days changed and then use this custom field in your BE
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
1 person likes this
VijayKumarU
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.