I'm looking for a SQL table that will give me the date a MO was released (when the status was changed to released). In Dynamics GP if i go to the MO activity window i can see the date and time, but i need to pull this from sql for a report.
Microsoft DynamicsMicrosoft SQL Server
Last Comment
jnikodym
8/22/2022 - Mon
Kevin Cross
Try WO010032 (MOP_Order_MSTR) and WO010213 (MOP_Order_History).
jnikodym
ASKER
no, those tables don't hold the date the MO was released. I was hoping there was a table that held all the MO activity that shows when you view the MO activity window in GP.