(RUS) Field setup (form)

  • Article

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

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.

Note

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.

Note

This tab is available on the Type of transactions tab.

Type of operation

Enter the transaction type for filtering transactions by posting layer.

Note

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.

Note

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.

    Note

    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.

    Note

    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.

Note

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.

Note

This field is activated when you select the Manual data input check box.

Budget model

Select the default budget model number.

Note

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.

Note

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.

Note

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:

  • +

  • -

  • *

  • /

Note

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.

Note

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.

    Note

    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.

Note

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.

Note

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.

Note

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

Note

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.

Note

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.

Note

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).