Dynamics GP - Manufacturing Order Variance Window

Posted on 2011-05-05
Last Modified: 2012-05-11
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
Question by:jnikodym
    LVL 9

    Expert Comment


    Author Comment

    I've tried that.  It is not giving me the table names.
    LVL 59

    Expert Comment

    by:Kevin Cross
    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.
    LVL 10

    Accepted Solution

    It gets calculated upon opening the MO Variance form, and stored in a temporary table.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now