(EEUR) Field setup (form) [AX 2012]

Updated: January 7, 2013

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.

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

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.

NoteNote

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.

NoteNote

This tab is available on the Type of transactions tab.

Type of operation

Enter information to filter transactions by transaction type.

NoteNote

This tab is available on the Type of transactions tab.

Operations/Tax

Enter information to filter transactions by accounting type.

NoteNote

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.

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.

NoteNote

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.

NoteNote

This tab is available on the Type of transactions tab.

Type of operation

Enter information to filter transactions by transaction type.

NoteNote

This tab is available on the Type of transactions tab.

Operations/Tax

Enter information to filter transactions by accounting type.

NoteNote

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.

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.

    NoteNote

    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.

    NoteNote

    This button is available only when you select Function query in the Line type field on the General tab in the lower pane.

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.

NoteNote

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:

  • +

  • *

  • /

NoteNote

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.

NoteNote

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.

NoteNote

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.

NoteNote

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.

NoteNote

This field is available only if you select Account in the Account interval field.


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

Community Additions

Show: