(RUS) Query function setup (form) [AX 2012]

Updated: January 4, 2013

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

Click General ledger > Setup > Financial reports generator > Functions. Select a line, and then click Setup.

Use this form to set up query functions that are used to calculate requisites.

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

Tab

Description

Type of transactions

Enter the parameters to filter transactions by.

NoteNote

This tab is available only when you select Transactions, Constant, or Function query in the Line type field.

Operations/Tax

Enter information to filter transactions by accounting type.

NoteNote

This tab is available only when you select Transactions in the Line type field.

Type of operation

Enter information to filter transactions by transaction type.

NoteNote

This tab is available only when you select Transactions in the Line type field.

Financial dimensions

Enter the dimension name and the dimension range to filter transactions by financial dimensions.

Budget

Enter parameters to filter budget-related transactions.

NoteNote

This tab is available only when you select Budget in the Line type field.

Tax registers

Enter information to filter tax-related transactions.

NoteNote

This tab is available only when you select Register in the Line type field.

Constant

Set up the constant value to filter transactions by.

NoteNote

This tab is available only when you select Constant in the Line type field.

Query

Set up the period of calculation for the query.

NoteNote

This tab is available only when you select Function query in the Line type field.

Contractor

Enter information to filter transactions for the Contractor line type.

NoteNote

This tab is available only when you select Contractor in the Line type field.

Requisite

Set up the fixed requisite to filter transactions by.

NoteNote

This tab is available only when you select Fixed requisite in the Line type field.

Button

Description

Account interval

Set up the range of ledger accounts and offset accounts that the cell values are calculated for during reporting.

NoteNote

This button is available only when you select Interval in the Account interval or Offset interval field.

Edit the query

Open the Query wizard form, where you can create and set up query parameters to calculate cell values for the Function query line type.

NoteNote

This button is available only when you select Function query in the Line type field.

Up

Move the selected line one position up.

Down

Move the selected line one position down.

Field

Description

Operator

Select the mathematical operator that is applied to the calculated value, from the following options:

  • +

  • *

  • /

Line type

Select the data source for the report, from the following options:

  • Transactions

  • Budget

  • Register

  • Constant

  • Function query

  • Contractor

  • Fixed requisite

Type of operation

Select the type of operation from the following options:

  • Balance – The ledger account transaction amount on a specific date is used to calculate the value of the report cell.

  • Credit balance – The credit ledger account transaction amount on a specific date is used to calculate the value of the report cell.

  • Debit balance – The debit ledger account transaction amount on a specific date is used to calculate the value of the report cell.

  • Turnover – The transaction amount for the ledger for the period is used to calculate the value of the report cell.

  • Credit activity – The credit transaction amount for the ledger for the period is used to calculate the value of the report cell.

  • Debit activity – The debit transaction amount for the ledger for the period is used to calculate the value of the report cell.

  • Active balance (debit) – Based on the line type that is selected, the balance for the ledger account across all combinations of financial dimensions is calculated. This balance is updated in the report cell.

  • Passive balance (credit) – Based on the line type that is selected, the balance for the ledger account across all combinations of financial dimensions is calculated. This balance is updated in the report cell.

Balance type

Select whether the balance on the starting date or ending of the reporting period is used on the report, from the following options:

  • Incoming – The balance on the starting date of the reporting period is used on the report.

  • Outgoing – The balance on the ending date of the reporting period is used on the report.

NoteNote

This field is available only when you select Balance, Credit balance, Debit balance, Active balance (debit), or Passive balance (credit) in the Type of operation field.

Period

Select a voucher calculation period.

Account interval

Select whether the mathematical sign is applied to the balance of a ledger account or account interval, from the following options:

  • Account

  • Interval

Account

Select the account number whose balance the mathematical sign is applied to.

NoteNote

This field is available only when you select Account in the Account interval field.

Offset interval

Select from the following options to specify one or several offset accounts:

  • Account – The account that is specified in the Offset account field is offset.

  • Interval – The account interval that is specified on the Offset interval tab in the Account interval form is offset.

NoteNote

This field is available only when you select Turnover in correspondence, Turnover in correspondence credit, or Turnover in correspondence debit in the Type of operation field.

Offset account

Select an offset account number.

NoteNote

This field is available only when you select Account in the Offset interval field.

Transaction usage

Select the type of transactions that are used to calculate the cell values, from the following options:

  • All – All of the transactions are used to calculate the cell value.

  • Only reversing entry – Only transactions that are reversed are used to calculate the cell value.

  • Without reversing entry – All transactions except the transactions that are reversed are used to calculate the cell value.

Posting layer

Select a posting layer that has transactions to include on the report, from the following options:

  • Current – Transactions that are posted to the Current posting layer are included.

  • Operations – Transactions that are posted to the Current or Operations posting layer are included.

  • Tax – Transactions that are posted to the Current or Tax posting layer are included.

  • Operations minus tax – Transactions that are posted to the Operations posting layer, except transactions that are also posted to the Tax posting layer, are included.

  • Only operations – Transactions that are posted to the Operations posting layer are included.

  • Only tax – Transactions that are posted to the Tax posting layer are included.

  • Operations plus tax – Transactions that are posted to the Operations and Tax posting layers are included.

  • Total – Transactions that are posted to the Current, Operations, and Tax posting layers are included.

  • Dual warehouse – Transactions that are posted to the dual warehouse posting layer are included.

NoteNote

This field is available on the Operations/Tax tab when you select Transactions in the Line type field.

Transaction type

Select a transaction type.

NoteNote

This field is available on the Type of operation tab when you select Transactions in the Line type field.

Reference

Select a dimension type.

From

Select the starting code for the dimension range for the transactions that are included on the report.

To

Select the ending code for the dimension range for the transactions that are included on the report.

Budget model

Select a budget model number for the report.

NoteNote

This field is available on the Budget tab only when you select Budget in the Line type field.

Register code

Select a register code.

NoteNote

This field is available on the Tax registers tab only when you select Register in the Line type field.

Register field

Select a register field.

Data

Enter a value that is used in the calculation.

NoteNote

This field is available on the Constant tab only when you select Constant in the Line type field.

SQL statement

The query as a Structured Query Language (SQL) statement.

Balance detail

Select an option to indicate whether the balance is from a document, agreement, or contractor.

NoteNote

This field is available on the Contractor tab only when you select Contractor in the Line type field.

Fixed requisite

Select a requisite for the report cell.

NoteNote

This field is available on the Requisite tab only when you select Fixed requisite in the Line type field.


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

Community Additions

Show: