<div>
<a href="http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/10/05/finding-table-and-field-information-in-microsoft-dynamics-gp.aspx" rel="ugc">http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/10/05/finding-table-and-field-information-in-microsoft-dynamics-gp.aspx</a>
</div>


http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/10/05/finding-table-and-field-information-in-microsoft-dynamics-gp.aspx [http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/10/05/finding-table-and-field-information-in-microsoft-dynamics-gp.aspx]

<div>
I've tried that. &nbsp;It is not giving me the table names.
</div>


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

<div>
Not a Dynamics expert, but here is a SQL method that may work. &nbsp;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. &nbsp;(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. &nbsp;That may help you find it. &nbsp;However, the simplest way is usually the Entity Relationship Diagram (Schema) provided in documentation if exists. &nbsp;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.
</div>


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.

<div>
<div class="content wysiwyg-content">
Can someone tell me what sql table the mo variance window info is stored in? &nbsp;I'm looking for the table that stores the production costs that are on the variance window. &nbsp;Thank you
</div>
</div>


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

Dynamics GP - Manufacturing Order Variance Window

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.