Previous Due Date PO Release

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.

1 Like


I am only wanting to do this when the release is first created so would this simple BPM work?

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.

I tried the following but does not seem to work -

Should the condition be added row?

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