(EEUR) 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. 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. Notitie 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. Notitie This tab is available on the Type of transactions tab. |
Type of operation |
Enter information to filter transactions by transaction type. Notitie This tab is available on the Type of transactions tab. |
Operations/Tax |
Enter information to filter transactions by accounting type. Notitie 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. Notitie 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. Notitie This tab is available on the Type of transactions tab. |
Type of operation |
Enter information to filter transactions by transaction type. Notitie This tab is available on the Type of transactions tab. |
Operations/Tax |
Enter information to filter transactions by accounting type. Notitie 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 |
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:
|
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:
|
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. Notitie 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:
|
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:
|
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:
Notitie 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. Notitie 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:
Notitie 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:
Notitie 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 |
Select the account number that is used to calculate the value in the report cell. Notitie This field is available only if you select Account in the Account interval field. |
See also
(EEUR) Account interval (form)
(EEUR) Financial report generator parameters copying (form)
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).