I don’t usually post but I’m stumped by this issue I’m having.
Im on Epicor 10.0.700.4
All my users are on one apppool.
This seems so simple, yet it doesn’t always fire in my production environment.
The idea is I want to copy the value from OrderComment from OrderDtl and then insert it into the WarrantyComment field when a user adds/save a comment.
In my test environment, the method fires 100% of the time and I tried all sorts of ways to try and find bugs but every time the data is copied over correctly.
Yet in production it copies it 20% of the time.
Here is my method.
In Pre-Processing of ERP.SalesOrder.Update
the condition is pretty basic.
If the field OrderComment has been changed from “” to another.
from empty to anything else.
My understanding is that the OrderComment field cannot be null but is empty so technically my method should fire every time someone enter a brand new comment.
This will only work for updated records. Are you sure you are not creating a new OrderDtl record, then updating the OrderComment, and then saving the OrderDtl? If that is the case you also need to add a condition for Added records and in your Set Field change “the updated row” to “the changed row”.
@Brian is correct… your condition should also have an “OR” looking for an ADDED record. That way if someone puts the comment while they are adding a new line item, it will also be processed.
The WarrantyComment field of the addedRow is not equal to ttOrderDtlRow.OrderComment being empty.
So if my ordercomment isn’t empty and my warranty is. it pushes the OrderComment Value into the warrantyComment field.
Other Scenario,
If I create a new line, hit save then add an ordercomment, the update condition fires and it writes it’s value into warrantyComment field.
Other Scenario,
If I go into an existing line with a comment and modify it from a value to another, nothing fires.
This is what I wanted.
If I remove the comment, it becomes empty, I hit save and then add a brand new comment. The Method fires again.