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
Solved

Dynamics GP - Manufacturing, MO Release Date

Posted on 2012-12-26
5
680 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
  • 3
  • 2
5 Comments
 
LVL 59

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 59

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 Database Restore 4 39
Solar Winds can't see SQL Server Express 17 33
Where is the Help Section? 8 27
SQL Recursion 6 19
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

837 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