(RUS) Set up the functions directory for electronic reporting
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
You can use the functions directory to create and update functional queries, which are used to calculate requisites based on data from databases. You can use configured functions to create values for fixed requisites.
The fixed requisite values are calculated based on the operator and line type that are selected in the Operator and Line type fields in the Query function setup form. For a Constant line type, when you create two consecutive lines that have numeric values, an arithmetic operation is performed, and the value is displayed in the cell. If one of the lines is a string, a line is created.
Example
For the values in the following table, the following line is created: 2500Rubles500Rubles900Rubles.
Operator |
Line type |
Data |
|---|---|---|
+ |
Constant |
50 |
* |
Constant |
50 |
/ |
Constant |
Rubles |
+ |
Constant |
500 |
+ |
Constant |
Rubles |
+ |
Constant |
300 |
* |
Constant |
3 |
+ |
Constant |
Rubles |
Use the following procedure to set up the functions directory for electronic reporting.
Click General ledger > Setup > Financial reports generator > Functions.
Click New, and then in the Function and Name fields, enter an identification number and a name for the function.
Click Setup, and then click New to create a query function.
In the Operator field, select the mathematical sign to apply to the requisite value.
Nota
The Operator field is used to set up the mathematical sign for the amount that is applied to the requisite value. The mathematical sign that you select in this field is also used when you set up multi-line composite vouchers. The Credit balance, Credit activity, and Turnover in correspondence credit voucher types use a minus sign (-).
In the Line type field, select the data source that is used to calculate the requisite value.
On the Type of transactions tab, do the following:
In the Type of operation field, select the type of operation. For more information, see (RUS) Query function setup (form).
In the Balance type field, select a balance type.
Nota
This field is available only if you select Balance, Credit balance, Debit balance, Active balance (debit), or Passive balance (credit) in the Type of operation field.
In the Period field, select the voucher calculation period.
In the Account interval and Account fields, select whether the mathematical operator is applied to an Account or an Interval, and an account number.
Nota
The Account field is available only if you select Account in the Account interval field.
In the Offset interval field, select whether an Account or Interval is offset.
Nota
This field is available only if you select Turnover in correspondence, Turnover in correspondence credit, or Turnover in correspondence debit in the Type of operation field.
In the Offset account field, select an account number.
Nota
This field is available only if you select Account in the Offset interval field.
In the Transaction usage field, select the rule for calculating the requisite value.
On the Operations/Tax tab, press CTRL+N to create a line, and then in the Posting layer field, select the posting layer that has transactions to include on the report.
On the Type of operation tab, press CTRL+N to create a line, and then in the Transaction type field, select a transaction type.
On the Financial dimensions tab, do the following:
Click Add to create a line, and then the Reference field, select a dimension type.
In the From and To fields, select the starting and ending codes for the dimension range for the transactions that are included on the report.
Do the following on the other tabs:
On the Budget tab, in the Budget model field, select a budget model number.
Nota
This tab is available only if you select Budget in the Line type field.
On the Tax registers tab, in the Register code and Register field fields, select a register number and a field. The data from the register field is used as the cell value.
Nota
This tab is available only if you select Register in the Line type field.
On the Constant tab, in the Data field, enter the value that is used in the calculation. The constant value can be a number or a line.
Nota
This tab is available only if you select Constant in the Line type field.
On the Contractor tab, in the Balance detail field, select an option to indicate whether the balance is from a document, agreement, or contractor.
Nota
This tab is available only if you select Contractor in the Line type field.
On the Requisite tab, in the Fixed requisite field, select a requisite for the report.
Nota
This tab is available only if you select Fixed requisite in the Line type field.
If you selected Interval in the Account interval or Offset interval field, do the following to indicate the account interval for the cell.
Click Setup > Account interval.
Press CTRL+N to create a line, and then in the From and To fields on the Account interval and/or Offset interval tab, select the starting and ending ledger account numbers that are used in the calculation. Close the form.
If you selected Function query in the Line type field, click Edit the query to open the Query wizard form. You can use this form to set up query parameters to calculate cell values.
Nota
The Edit the query button is available only if you select Function query in the Line type field.
After you create the lines, you can arrange them in the correct order. Select a line, and then click Up or Down to move the selected line one position up or down.
See also
(RUS) Query function setup (form)