Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Dynamics GP - Manufacturing, MO Release Date

Posted on 2012-12-26
5
Medium Priority
?
707 Views
Last Modified: 2013-01-01
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.
0
Comment
Question by:jnikodym
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 38721720
Try WO010032 (MOP_Order_MSTR) and WO010213 (MOP_Order_History).
0
 

Author Comment

by:jnikodym
ID: 38721806
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
 

Accepted Solution

by:
jnikodym earned 0 total points
ID: 38725144
MOP10213 is the correct table for this.
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 38725463
That makes sense. MOP10213 is the table for Manufacture Order Activity. Nice work.

Best regards and happy coding,

Kevin
0
 

Author Closing Comment

by:jnikodym
ID: 38734250
I found the correct answer
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question