(RUS) Queries (form)

项目
10/19/2018

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Click General ledger > Setup > Financial reports generator > Queries.

Use this form to configure and update queries to retrieve values from database tables for electronic reporting. Configured queries are used to create values for fixed requisites that are used to customize document templates.

Task that uses this form

(RUS) Create a query for electronic reporting

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab	Description
Overview	View the query identification code and name, and the table that the query refers to.
General	Update the query name if required, and view the query and table details.
Query	View the query as a Structured Query Language (SQL) statement.

Buttons

Button	Description
Query	Open the Inquiry form, where you can select the required related tables and set limits to field values.
Reset	Reset the query.
Create requisites	Open the Create requisites form, where you can create requisites.
Fixed requisites	Open the Fixed requisites form, where you can view the requisites with values that are created based on the query.

Fields

Field	Description
Query	The identification code for the query.
Name	Update the name of the query, if required.
Table	The name of the main query table.
Query type	The type of query. The options are Simple, VAT declaration, and Document requisites.
Table name	The table name.
SQL statement	The query as an SQL statement.