(RUS) Field setup (form)

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

Click General ledger > Setup > Financial reports generator > Financial reports generator. Click Setup.

Use this form to set up cell operations and to create cell reports.

Task that uses this form

(RUS) Create report cells for electronic reporting

Navigating the form

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

Tabs

Upper pane

Tab	Description
Cells	Enter a list of report cells and their main parameters.
General	Modify the cell requisite and alignment parameters of the selected report cell.
Type of transactions	Enter the parameters for filtering transactions.
Tax registers	Enter profit tax register details. Nota This tab is available only if you select Register in the Line type field.
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 the parameters for filtering transactions.
Reversing entry	Enter the transaction type for filtering transactions based on reverse entries. Nota This tab is available on the Type of transactions tab.
Type of operation	Enter the transaction type for filtering transactions by posting layer. Nota This tab is available on the Type of transactions tab.
Operations/Tax	Enter the current transaction codes or fiscal transaction codes for filtering transactions by accounting type. Nota 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

Upper pane

Button	Description
Setup	Open a menu that contains the following option: Convert to requisite – Set up the related data for the cell.
Functions	Open a menu with the following items to perform functions on the report or the report cells: Copy – Open the Copy report settings into a new report form, where you can copy report settings from any company to the current company on a new report. Create report cells – Open the Create report cells form, where you can create report cells based on a selected query.
Inquiries	Open a menu that contains the following option: Cell value – Generate inquiries that are related to a report cell.

Lower pane

Button	Description
Up	Move the selected line one position up.
Down	Move the selected line one position down.
Setup	Open a menu with the following items to set up related data for the operation: Account interval – Open the Account interval form, where you can set up account intervals and corresponding ledger accounts for which the cell operation values are calculated. Nota This menu item is activated when you select Interval in the Account interval or Offset interval field. Edit the query – Set up a free query that calculates values for cell operations. Nota This menu item is activated when you select Function query in the Line type field.

Fields

Field	Description
Requisite	Select the cell requisite for each section of the electronic report. Nota This field is available when you select the document template in the Template field in the Report form.
Cell	Enter the cell name from the template that was created.
Description	Enter a description of the cell.
Line type	Select a default data type for the report, from the following options: Transactions – Data about the posted vouchers for ledger accounts is available on the report. Budget – Data from the budget transactions is available on the report. Register – Data from tax register transactions is available on the report. Constant – Data is generated from a predefined constant. Function query – Data is generated from a predefined function query. Contractor – Data from the customer, vendor, or employee transactions is available on the report. Fixed requisite – Data is generated from a predefined fixed requisite.
Period	Select the default calculation period.
Manual data input	Select this check box to enter the cell values manually when opening a report from the Financial reports generator form.
By default	Enter the default amount value for the cell. Nota This field is activated when you select the Manual data input check box.
Budget model	Select the default budget model number. Nota This field is activated when you select Budget in the Line type field.
Alignment	Select the text alignment value.
String length	Enter the string length of the requisite value.
Empty symbol	Enter the empty symbol in the requisite format.
Fractional part	The number of decimal places for the amounts that are reported.
Register code	Select a tax register code. Nota This field is available on the Tax registers tab only if you select Register in the Line type field.
Register field	Select a register field. Nota This field is available on the Tax registers tab only if you select Register in the Line type field.
Reference	Select the dimension name.
From	Select the starting code for the dimension range for which the transactions should be included on the report.
To	Select the ending code for the dimension range for which the transactions should be included on the report.
Operator	Select the function to apply to the calculated value, from the following options: + - * / Nota The Operator field is used to set up the sign of the amount that is exported into the cell, and is also used as a mathematical sign when you set up multiple-line composite vouchers. By default, a new line, or a new voucher, uses a plus sign (+).
Data	Enter the value that is used in the calculation. Nota This field is activated 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. Credit balance – The credit ledger account transaction amount on a specific date. Debit balance – The debit ledger account transaction amount on a specific date. Turnover – The transaction amount for the ledger for the period. Credit activity – The credit transaction amount for the ledger for the period. Debit activity – The debit transaction amount for the ledger for the period. Turnover in correspondence – The transaction amount for the ledger, which corresponds to other ledger accounts for the period. Turnover in correspondence credit – The credit transaction total for the ledger, which corresponds to other ledger accounts for the period. Turnover in correspondence debit – The debit transaction amount for the ledger, which corresponds to other ledger accounts for the period. Active balance (debit) – Depending on the line type that is selected, the following lines are calculated: The balance for the ledger account across all combinations of financial dimensions. The calculated debit balances for dimensions are added. For example, this calculation is used for the Transactions line type. The active balance for the ledger account that is categorized by customer, contract, or documents. For example, this calculation is used for the Contractor line type. Passive balance (credit) – Depending on the line type that is selected, the following lines are calculated: The balance for the ledger account for all combinations of financial dimensions. The calculated debit balances for dimensions are added based on the line type. For example, this calculation is used for the Transactions line type. The passive balance for the ledger account that is categorized by counteragents, contracts, or documents. For example, this calculation is used for the Contractor line type. Nota The Active balance (debit) and Passive balance (credit) operation types are calculated differently, depending on the line type that is selected.
Balance type	Select the balance type from the following options: Incoming – The balance on the starting date of the period. Outgoing – The balance on the ending date of the period. Nota This field is available when you select Balance, Credit balance, Debit balance, Active balance (debit), or Passive balance (credit) in the Type of operation field.
Fixed requisite	Select the requisite for the electronic report. Nota This field is available when you select Fixed requisite in the Line type field.
Account interval	Select whether to calculate the cell for one account or for several accounts, from the following options: Account Interval
Account	Select the account number for posting in the ledger. Nota This field is activated when you select Account in the Account interval field.
Offset interval	Select whether one or several offset accounts are required, from the following options: Account Interval Nota This field is activated when you select, Turnover in correspondence, Turnover in correspondence credit, or Turnover in correspondence debit in the Type of operation field.
Corr. account	Select the ledger account that corresponds to the main account. Nota This field is available when you select Account in the Account interval field.
Balance detail	Select the level of detail to use when calculating the active-passive balance, from the following options: Document Agreement Contractor
Offset account	Select the offset account number for posting in the ledger.
Transaction usage	Select the type of transaction that is taken into account when the report is created, from the following options: All – View all transactions. Only reversing entry – View reverse transactions. Without reversing entry – Hide reverse transactions.
Transaction type	Select the transaction type. Nota The transaction type determines from which module the transactions are used when the report is generated.
Posting layer	Select the code for the current or fiscal transaction, from the following options: Current Operations Tax Operations minus tax Only operations Only tax Operations plus tax Total Dual warehouse

See also

(RUS) Report (form)

(RUS) Financial report generator parameters copying (form)

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