(RUS) Create query (form) [AX 2012]

Updated: January 3, 2013

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.

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

Tab

Description

Parameters

Set up the query and table details.

Query

View the query.

Button

Description

Settings

Open the Document requisites form, where you can create requisites for electronic reporting.

NoteNote

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.

NoteNote

This button is available only if you select a main query table in the Table field.

Reset

Reset the query.

NoteNote

This button is available only if you select a main query table in the Table field.

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:

  • Simple – A query type that you can use to retrieve data from database tables.

  • VAT declaration – A predefined, customizable query type that uses value-added tax (VAT).

  • Document requisites – A query type that uses the requisite that is specified in the Requisite field on the Document requisites form.

Create requisites

Select this check box to create requisites in the query directory when you create the query.

NoteNote

This check box is available only when you select VAT declaration in the Query type field.

Table

Select a main query table.

NoteNote

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.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

Show: