(RUS) Query function setup (form)

项目
10/19/2018

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.

Task that uses this form

(RUS) Set up the functions directory for electronic reporting

Navigating the form

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

Tabs

Tab	Description
Type of transactions	Enter the parameters to filter transactions by. 备注 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. 备注 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. 备注 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. 备注 This tab is available only when you select Budget in the Line type field.
Tax registers	Enter information to filter tax-related transactions. 备注 This tab is available only when you select Register in the Line type field.
Constant	Set up the constant value to filter transactions by. 备注 This tab is available only when you select Constant in the Line type field.
Query	Set up the period of calculation for the query. 备注 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. 备注 This tab is available only when you select Contractor in the Line type field.
Requisite	Set up the fixed requisite to filter transactions by. 备注 This tab is available only when you select Fixed requisite in the Line type field.

Buttons

Button	Description
Account interval	Set up the range of ledger accounts and offset accounts that the cell values are calculated for during reporting. 备注 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. 备注 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.

Fields

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. 备注 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. 备注 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. 备注 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. 备注 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. 备注 This field is available on the Operations/Tax tab when you select Transactions in the Line type field.
Transaction type	Select a transaction type. 备注 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. 备注 This field is available on the Budget tab only when you select Budget in the Line type field.
Register code	Select a register code. 备注 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. 备注 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. 备注 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. 备注 This field is available on the Requisite tab only when you select Fixed requisite in the Line type field.