Dynamics GP - Manufacturing, MO Release Date

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.
jnikodymAsked:
Who is Participating?
 
jnikodymConnect With a Mentor Author Commented:
MOP10213 is the correct table for this.
0
 
Kevin CrossChief Technology OfficerCommented:
Try WO010032 (MOP_Order_MSTR) and WO010213 (MOP_Order_History).
0
 
jnikodymAuthor Commented:
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.
0
 
Kevin CrossChief Technology OfficerCommented:
That makes sense. MOP10213 is the table for Manufacture Order Activity. Nice work.

Best regards and happy coding,

Kevin
0
 
jnikodymAuthor Commented:
I found the correct answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here