(EEUR) Field setup (form)

项目
10/19/2018

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

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

You can use the Russian financial reports generator (FRG) to generate reports in the Microsoft Word or Microsoft Excel template. Use this form to create report cells and to specify how report cells are updated.

Tasks that use this form

(EEUR) Create and copy report cells

(EEUR) Create report cell operations

Navigating the form

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

Tabs

Upper pane

Tab	Description
Cells	Create report cells, and specify report cell parameters.
General	Update report cell parameters, or enter cell alignment parameters for the selected report cell.
Type of transactions	Enter the parameters to filter transactions by. 备注 This tab is available only if you select Transactions, Constant, or Function query in the Line type field.
Reversing entry	Enter the transaction type to filter transactions based on reverse entries. 备注 This tab is available on the Type of transactions tab.
Type of operation	Enter information to filter transactions by transaction type. 备注 This tab is available on the Type of transactions tab.
Operations/Tax	Enter information to filter transactions by accounting type. 备注 This tab is available on the Type of transactions tab.
Financial dimensions	Enter the dimension name and the dimension range to filter transactions by financial dimensions.

Lower pane

Tab	Description
Operations	Enter the operators and the type of operations for the cell value that is selected in the upper pane of the form.
General	Modify the operations to set up the sign of the amount that is exported into the cell, and that is also used as a mathematical sign to set up multiple-line composite vouchers.
Type of transactions	Enter information to filter transactions by transaction type. 备注 This tab is available only if you select Transactions, Constant, or Function query in the Line type field.
Reversing entry	Enter the transaction type to filter transactions based on reverse entries. 备注 This tab is available on the Type of transactions tab.
Type of operation	Enter information to filter transactions by transaction type. 备注 This tab is available on the Type of transactions tab.
Operations/Tax	Enter information to filter transactions by accounting type. 备注 This tab is available on the Type of transactions tab.
Financial dimensions	Enter the dimension name and the dimension range to filter transactions by financial dimensions.

Buttons

Button	Description
Functions (In the upper pane)	Open a menu, and click Copy to open the Copy report settings into a new report form. In this form, you can copy a cell, all of its settings, and cell operations from any report for any legal entity into the current report.
Up	Move the selected line one position up.
Down	Move the selected line one position down.
Setup	Open a menu that contains the following items: Account interval – Open the Account interval form, where you can set up account intervals for ledger accounts that are used to calculate the report cell value. 备注 This button is available only when you select Interval in the Account interval field on the General tab in the lower pane. Edit the query – Open the Query wizard form, where you can set up a query to calculate report cell values. 备注 This button is available only when you select Function query in the Line type field on the General tab in the lower pane.

Fields

Field	Description
Cell	Enter the cell name from the template that is created.
Description	Enter a description for the cell.
Line type	Select the data source for the report from the following options: Transactions Budget Constant Function query
Period	Select the voucher calculation period.
Manual data input	Select this check box to enter cell values manually after you generate the report.
By default	Enter the default amount value for the cell.
Budget model	Select a budget model number. 备注 This field is available only if you select Budget in the Line type field on the Cell tab.
Alignment	Select how you want the data in the cell to be aligned. You can select Default, Left, Right, or Center.
String length	Enter the maximum number of characters that the cell can contain.
Empty symbol	Enter the character that is entered between the prefix and postfix values to complete the string length.
Fractional part	Enter the number of decimal places that the amounts are reported in.
Transaction usage	Select the type of transactions that are used to create the report, from the following options: All – All of the transactions are used to create the report. Only reversing entry – Only transactions that are reversed are used to create the report. Without reversing entry – All transactions except the transactions that are reversed are used to create the report.
Transaction type	Select the transaction type that is used to generate the report.
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 or Tax posting layer are included. Total – Transactions that are posted to the Current, Operations, and Tax posting layers are included.
Reference	Select the financial dimension name.
From	Select the starting code for the dimension range for which the transactions are included on the report.
To	Select the ending code for the dimension range for which the transactions are included on the report.
Operator	Select the mathematical operator that is applied to the calculated value, from the following options: + – * / 备注 The Operator field is used to set up the sign of the amount that is exported into the cell and also used as a mathematical sign when multiple-line composite vouchers are set up.
Data	Enter the value to use in the calculation. 备注 This field is available only when you select Constant in the Line type field.
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. 备注 The Active balance (debit) and Passive balance (credit) operation types are calculated differently, based on the line type that is selected.
Balance type	Select whether the balance on the starting date or ending of the reporting period is used in 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 if you select Balance, Credit balance, Debit balance, Active balance (debit), or Passive balance (credit) in the Type of operation field.
Account interval	Select how the value in the report cell is calculated, from the following options: Account– The mathematical sign that is specified in the Operator field is applied to the balance from the ledger account that is specified in the Account field, and the value is displayed in the report cell. Interval – The mathematical sign that is specified in the Operator field is applied to the balances from the ledger accounts that are specified in the Account interval field, and the value is displayed in the report cell.
Account	Select the account number that is used to calculate the value in the report cell. 备注 This field is available only if you select Account in the Account interval field.