• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

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.
0
jnikodym
Asked:
jnikodym
  • 3
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
Try WO010032 (MOP_Order_MSTR) and WO010213 (MOP_Order_History).
0
 
jnikodymAuthor Commented:
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
 
jnikodymAuthor Commented:
MOP10213 is the correct table for this.
0
 
Kevin CrossChief Technology OfficerCommented:
That makes sense. MOP10213 is the table for Manufacture Order Activity. Nice work.

Best regards and happy coding,

Kevin
0
 
jnikodymAuthor Commented:
I found the correct answer
0

Featured Post

Independent Software Vendors: 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!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now