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.

Microsoft DynamicsMicrosoft SQL Server

Last Comment

jnikodym

8/22/2022 - Mon

Kevin Cross

12/26/2012

Try WO010032 (MOP_Order_MSTR) and WO010213 (MOP_Order_History).

jnikodym

12/26/2012

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

jnikodym

12/27/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Kevin Cross