[Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Dynamics GP - Manufacturing Order Variance Window

Can someone tell me what sql table the mo variance window info is stored in?  I'm looking for the table that stores the production costs that are on the variance window.  Thank you
1 Solution
jnikodymAuthor Commented:
I've tried that.  It is not giving me the table names.
Kevin CrossChief Technology OfficerCommented:
Not a Dynamics expert, but here is a SQL method that may work.  If you know of a report or form that queries the tables you are looking for, then (1) launch SQL profiler on your SQL server and then (2) open the report or form.  (3) stop the trace and look for the query that executed on the server -- you will have the details of the table(s) or view(s) involved.  That may help you find it.  However, the simplest way is usually the Entity Relationship Diagram (Schema) provided in documentation if exists.  With it being Microsoft, I suspect there is some documentation somewhere, especially given the link above eludes to this being retrieved off of a menu or through SDK.
It gets calculated upon opening the MO Variance form, and stored in a temporary table.

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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