Financial statement setup (form)
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Click General ledger > Setup > Financial statement (traditional) > Financial statement (traditional).
Use this form to create traditional financial statements and define their basic structures.
Note
This topic includes information about features that were added or changed for cumulative update 6 or later for Microsoft Dynamics AX 2012 R2. This information also applies to AX 2012 R3.
In the upper pane, you name the traditional financial statement and select the financial dimension sets and row definitions for the traditional financial statement.
In the lower pane, you set up the column structure for the traditional financial statement and specify the printed format for the columns.
Note
The fields that are available in the lower pane depend on the value that you select in the Column type field.
To print financial statements, you can use Management Reporter, or you can use the traditional financial statements that are included with Microsoft Dynamics AX. For more information about how to print financial statements by using Management Reporter, see Management Reporter for Microsoft Dynamics ERP.
This form is available only when the Financial statement (traditional) configuration key is selected.
Tasks that use this form
Design the row structure of a traditional financial statement
Design the rows and columns of a traditional financial statement
Generate, print, and export a traditional financial statement
Set up file formats for the export of a traditional financial statement
Navigating the form
The following tables provide descriptions for the controls in this form.
Tabs (Upper pane)
Tab | Description | |
---|---|---|
Overview | Create a traditional financial statement, and define an overall structure that includes primary and secondary dimension sets. | |
General | View information for the traditional financial statement that is selected on the Overview tab. | |
Setup | Set up the row structure and general printing parameters for the traditional financial statement that is selected on the Overview tab. |
Tabs (Lower pane)
Tab |
Description |
---|---|
Overview |
Set up columns for the traditional financial statement that is selected in the upper pane. |
General |
View information for the column that is selected on the Overview tab. |
Setup |
Set up the date interval, currency, and factor, if a factor is relevant, for the column that is selected on the Overview tab. |
Calculation |
Enter a calculation expression and the column for which a percentage will be calculated. |
Formatting |
Set up the formatting, if formatting is relevant, for the column that is selected on the Overview tab. |
Transactions |
Enter and select information. The information that you enter or select depends on the value that you select in the Column type field for the column that is selected on the Overview tab. |
Buttons
Button |
Description |
---|---|
Copy |
Copy an existing traditional financial statement to use as the basis for a new statement. |
Add |
Add a column to the traditional financial statement. |
Remove |
Remove the selected column from the traditional financial statement. |
Up |
Move the selected column up in the list of columns. |
Down |
Move the selected column down in the list of columns. |
Select |
Select information for the selected column. The selection that you make here is proposed when you print the traditional financial statement. Whether this button is available depends on the value that you select in the Column type field. |
Fields
Field |
Description |
|||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Financial statement |
Select the identifier of the traditional financial statement. |
|||||||||||||||
Description |
Enter a short description of the traditional financial statement. |
|||||||||||||||
Primary dimension set |
Select the primary financial dimension set for the traditional financial statement. Financial dimension sets are used to sort information on the traditional financial statement. |
|||||||||||||||
Secondary dimension set |
Select the secondary financial dimension set for the traditional financial statement. |
|||||||||||||||
Page break per primary dimension set |
Select this check box to print a separate traditional financial statement for each primary dimension set. If this check box is cleared, the primary dimension set is displayed as a line on a traditional financial statement, and the secondary dimension set is displayed as detailed information. You can select this check box only if a secondary dimension set is selected in the Secondary dimension set field. |
|||||||||||||||
Row definition for primary dimension set |
Select the row definition to use for the primary dimension set on the traditional financial statement. |
|||||||||||||||
Row definition for secondary dimension set |
Select the row definition to use for the secondary dimension set on the traditional financial statement. |
|||||||||||||||
Primary dimension set 100 percent |
Select a primary dimension set to display the amounts as a percentage of the total. Then, in the lower pane, on the Calculation tab, in the Percentage column field, specify which column the percentage will be calculated for. Use this field only if the row definition on the traditional financial statement contains columns that have a column type of 100%. An individual account's share of the primary dimension set is calculated as a percentage. For example, your total revenue account is 400900, and you select that account in this field. The following information will be printed in the columns that have a column type of 100%.
|
|||||||||||||||
Print range |
Select this check box to print a range description before the traditional financial statement. |
|||||||||||||||
Cover page |
Select this check box to include a cover page for the traditional financial statement. |
|||||||||||||||
Skip zero |
Select this check box to skip accounts or dimensions on the traditional financial statement if the balance of the account or dimension is 0 (zero). |
|||||||||||||||
Header line |
Select this check box to print header rows or header accounts. |
|||||||||||||||
Transaction line |
Select this check box to print details, elements, rows, or account numbers for transaction account lines. |
|||||||||||||||
Total line |
Select this check box to print total rows, or both total rows and account numbers for main accounts that have a main account type of Total. |
|||||||||||||||
Column |
The number of the current column. The number increases by one for each column that is created. The numbering determines the layout of the columns on the traditional financial statement. You can change the numbering by clicking the Up and Down buttons. |
|||||||||||||||
Name |
Specify a name for the column. The name is used as a header for the column. |
|||||||||||||||
Column type |
Select a column type, which specifies the type of content in the column:
|
|||||||||||||||
Select this check box to print the column on the traditional financial statement. |
||||||||||||||||
Number of columns |
Specify the number of columns to print for a logical column. For example, enter 2 for a debit column and a credit column. |
|||||||||||||||
Date interval code |
Select the code for date intervals for the current column, if a code exists. The date interval is displayed when you print the traditional financial statement from the Reports group on the General ledger area page. (Click General ledger > Reports > Transactions > Financial statement (traditional).) However, you can change the date interval. |
|||||||||||||||
From date |
If the Date interval code field is blank, you can enter the starting date for the information to include on the traditional financial statement. |
|||||||||||||||
To date |
If the Date interval code field is blank, you can enter the ending date for the information to include on the traditional financial statement. |
|||||||||||||||
Currency |
Select the currency for the column. |
|||||||||||||||
Factor |
Select how to print the column amounts:
|
|||||||||||||||
Calculation expression |
The formula that is used to calculate columns that have a column type of Calculation. Any operators that are recognized by the X++ language are accepted. During calculation, #1, #2, #3, and so on are replaced by the columns that are currently specified as columns 1, 2, 3, and so on. Examples
|
|||||||||||||||
Percentage column |
Enter the column for which to calculate a percentage, if you selected a column type of 100%. |
|||||||||||||||
Decimal separator |
Select the character to use as a decimal separator. |
|||||||||||||||
Thousands separator |
Select the character to use as a thousand separator. |
|||||||||||||||
Show zero |
Select how the figure 0 (zero) will be displayed if the value is 0. |
|||||||||||||||
Invert sign |
Select this check box to invert the sign on the traditional financial statement. For example, if you select this check box, credit amounts are displayed as positive amounts. |
|||||||||||||||
Sign |
Select how a sign will be displayed for negative figures. |
|||||||||||||||
Decimals |
Specify the number of decimal places. |
|||||||||||||||
Negative adjustment |
Enter the number of positions that negative figures will be moved to the left. Figures are typically moved to the left in a column that contains debit and credit amounts. |
|||||||||||||||
Length |
Enter the maximum number of positions that the column can print across. |
|||||||||||||||
Company accounts |
Select the legal entity for the transactions in the selected column. |
|||||||||||||||
Include opening |
Select this check box to include opening transactions on the traditional financial statement. |
|||||||||||||||
Include operating |
Select this check box to include operating transactions on the traditional financial statement. |
|||||||||||||||
Include closing |
Select this check box to include closing transactions on the traditional financial statement. |
|||||||||||||||
Posting layer |
Specify how the posting layers will be included for the selected column:
This field is not available when you print the traditional financial statement. For example, you want to print the Current posting layer for account 11005 and the Tax posting layer for account 11010 on the same traditional financial statement. In this case, you must select Total in this field. Then, in the Structure designer form, in the Posting layer field, select Current for account 11005 and Only tax for account 11010. |
|||||||||||||||
Debit/Credit |
Select whether the column will display only debit balances or only credit balances. |
|||||||||||||||
Budget model |
Select a budget model, if you want to add the budget amounts for a specific model on the traditional financial statement. By default, if you do not select a budget model, all budget register entries in the selected date interval are included. |
|||||||||||||||
Include submodel |
Select this check box to include submodels of the specified budget model in the calculation. |
|||||||||||||||
Original or revised budget |
Select whether the budget is the original budget, or if it has been revised. |
See also
Financial dimension sets (form)
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).