I found a couple of very old threads on this topic so am curious if anyone has found the date of when a sales order was closed?
From one thread, it sounded like a suggestion is the find the oldest change date (OrderRel.ChangeDate) of a line release that has been shipped (OrderRel.RelStatus = ?). We would have to assume the change date is the date shipped i guess?
Any better suggestion?
We use the Change Log for this purpose plus to monitor changes to many other fields on the Order tables. It’s a very easy BPM to setup.
We monitor the OrderRel, OrderDtl, and OrderHed Open fields so we can tell when the over all order plus when any release or line have been closed.
We do what Randy already mentioned. Change log on all three main order tables. We also have a BPM that sets a custom close date field that we sync to SF.
This is the way.
Well, what are you needing this for? A report/dashboard? Research?
Change log is recommended anyway as you can monitor when key fields change. However, reporting off of the change log is a PITA so if you want this on a dashboard then you may want to use @chaddb’s suggestion of a BPM to set a UD field.
Appreciate the quick replies – yes, we want this for reporting so we can measure order duration between different “stage gates” to completion (we have a heavy ETO product line that has a large range in sales order life cycles).
Then I’d go with a UD field. Do you ship order complete or partials?