Solved

Dynamics GP - Manufacturing, MO Release Date

Posted on 2012-12-26
5
684 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

737 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