(EEUR) Query wizard (form) [AX 2012]

Updated: November 8, 2012

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

Click General ledger > Setup > Financial reports generator > Financial reports generator. On the Report form, click Setup. On the Field setup form, in Operations section, click Add. In the Line type field, select Function query. Click Setup and then click Edit the query.

Use the Query wizard to create and set up query parameters to calculate values for cell operations for the Function query data type.

NoteNote

This topic has not been fully updated for Microsoft Dynamics AX 2012 R2.

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

Button

Description

>

Add tables from All tables to Selected tables.

<

Remove tables from Selected tables.

<<

Remove all tables from Selected tables.

Field

Description

Show system names of tables, fields, and methods

Select this check box to view the names for tables and fields in the query wizard.

All tables

The list of names of all main tables.

Selected tables

The selected main table on which the calculation is performed.

Table that are related to the Selected tables

The tables related to the selected main table.

(Field)

Available fields

Select the field to be calculated and click > to move it to the Field name field.

Field name

The field name that is selected from the main table.

Operation

Select the operation to be used for the calculation from the following options:

  • Average

  • Sum

  • Minimum

  • Maximum

  • Quantity

(Base date)

Available fields

Select the field to be used for filter setup and click > to move it to the Field name field.

Table name

The table name whose data is used as the source to create a query.

Field name

The unique field name whose data is used as the source to create a query.

Period

Select the date interval code if it is different from the default value determined for the cell or report.

NoteNote

This field is activated only if you select a table with a date. The Base date page determines the date on the basis of which data for the calculation is selected.

(Range)

Available fields

Select the fields to be used for filter setup.

(Selected fields)

Available fields

The main table and the fields to be used for filter setup.


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

Community Additions

Show: