Is there any way to see the time a sales order was created ? I can only see the creation date in order entry ?
The OrderHed.OrderDate field IS technically setup as a datetime data type:
But unfortunately, it only records the date, and sets the time to 12:00AM.
You may be able to use a BPM to over-write the OrderDate column to include the time stamp and not just the date??
Haven’t attempted that anywhere so can’t give any finer points on how to pull that off.
Then, I guess you’d have to customize your form and change the format of the field to show both date and time.
This may work for orders going forward, but I have to assume any historical orders only saved the initial date and not the time.
Option 1: Add a UD field to the table and create a BPM thats writes DateTime.Now
Option 2: Add a change log to OrderHed
3 Likes
There is an Epicor Idea to make this default functionality… please vote!
3 Likes
Option 1 Working perfectly 
You’ve always got the book tables. Which tell you this information as well.
Option 2 here…OrderHed, OrderDtl and OrderRel…comes in handy.