Dynamics GP - Manufacturing, MO Release Date

jnikodym
jnikodym used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Kevin CrossChief Technology Officer
Most Valuable Expert 2011

Commented:
Try WO010032 (MOP_Order_MSTR) and WO010213 (MOP_Order_History).
jnikodym

Author

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.
Commented:
MOP10213 is the correct table for this.
Kevin CrossChief Technology Officer
Most Valuable Expert 2011

Commented:
That makes sense. MOP10213 is the table for Manufacture Order Activity. Nice work.

Best regards and happy coding,

Kevin
jnikodym

Author

Commented:
I found the correct answer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial