Link to home
Start Free TrialLog in
Avatar of jnikodym
jnikodym

asked on

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.
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Try WO010032 (MOP_Order_MSTR) and WO010213 (MOP_Order_History).
Avatar of jnikodym
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.
ASKER CERTIFIED SOLUTION
Avatar of jnikodym
jnikodym

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That makes sense. MOP10213 is the table for Manufacture Order Activity. Nice work.

Best regards and happy coding,

Kevin
I found the correct answer