Does anyone know how the Previous Due Date field in the PO Rel table works? Would like to use the field to record the original Due Date of the PO if any changes are made to the Due Date.
Last I knew that field is not used by Epicor, and I think I have used it before.
I’ve seen the field there for about 14 years now, so I think it’s old and was either accidently abandoned or is used by a module that few have. You can make some tests and double check the Data Dictionary. A BPM to maintain the value you want probably would be safe.
I think a BPM to copy the Due Date into it when the release is created is probably a best bet.
That might work, but if they clear out the Due date, save and set it, it won’t work.
You should add a condition that checks if the PreviousDueDate is blank or null or something. That way if it’s been previously set it will not set it.
I think a third condition that checks that the DueDate is not Null would be needed too.
So the conditions would be:
- PreviousDueDate is Null (?)
- AND DueDate is Not Null
- AND DueDate has been changed from ? to any
That might do it, but test your different scenarios.
Ok will try that.
Try Added Row.
That condition may not even be needed.
With stuff like this, it can be tricky to know the current state of the data so it falls to trial and error and testing.
Tried added and that does not work either.
Hmm