(RUS) Create query (form)
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Click General ledger > Setup > Financial reports generator > Queries. Click New.
Use this form to create or update queries that you can use to retrieve values from database tables. You can retrieve values from any database table.
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 |
---|---|
Parameters |
Set up the query and table details. |
Query |
View the query. |
Buttons
Button |
Description |
---|---|
Settings |
Open the Document requisites form, where you can create requisites for electronic reporting. Note This button is available only if you select Document requisites in the Table field. |
Query |
Open the Inquiry form, where you can select the required related tables and set limits to field values. Note This button is available only if you select a main query table in the Table field. |
Reset |
Reset the query. Note This button is available only if you select a main query table in the Table field. |
Fields
Field |
Description |
---|---|
Query |
Enter an identification code for the query. |
Name |
Enter a name for the query. |
Query type |
Select the type of query from the following options:
|
Create requisites |
Select this check box to create requisites in the query directory when you create the query. Note This check box is available only when you select VAT declaration in the Query type field. |
Table |
Select a main query table. Note This field is available only when you select Simple in the Query type field. |
Table name |
The name of the table. |
SQL statement |
The query as a structured query language (SQL) statement. |
See also
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).