Financial statement setup (form)

Article
10/09/2018

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

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

Account	Amount	Percentage
Revenue account 1	360	30%
Revenue account 2	240	20%
Revenue account 3	600	50%
Total revenue (account 400900)	1200

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:

Primary dimension set code – Display the primary dimension set, which is the main account, the financial dimension, or a combination of the two.
Primary dimension set definition name – Display the name of the primary dimension set code.
Secondary dimension set code – Display the secondary dimension set, which is the main account, the financial dimension, or a combination of the two.
Secondary dimension set name – Display the name of the secondary dimension set code.
Current – Display the transaction amounts in the accounting currency.
Current quantity – Display the transaction amounts that are registered in the transactions. The amounts are displayed as quantities.
Current currency – Display the transaction amounts in the currency that is selected in the Currency field on the Setup tab.
Current accounting currency – Display the transaction amounts for transactions for which the same accounting currency is selected in the Currency field on the Setup tab.
Budget – Display the budgeted figures in the accounting currency.
Budget quantity – Display the budgeted figures that are registered in the transactions. The figures are displayed as quantities.
Budget currency – Display the budgeted figures in the currency that is selected in the Currency field on the Setup tab.
Budget default currency – Display the budgeted figures for transactions for which the same accounting currency is selected in the Currency field on the Setup tab.
100% – Display calculations of the share of the account that was selected in the Primary dimension set 100 percent field and in the Percentage column field on the Calculation tab. This calculation is useful when you print the statement of earnings, where the 100 percent account displays the total revenue.
Calculation – Display values that are calculated based on other columns. The current calculation is specified in the Calculation expression field on the Calculation tab.
Cash flow forecast – Display calculated cash flow forecast transactions in the accounting currency. By adding this column, you can summarize the realized figures and the calculated cash flow forecast for a period in the future.
Cash flow forecast currency – Display the calculated cash flow forecast transactions for transactions for which the same accounting currency is selected in the Currency field on the Setup tab.
Cash flow forecast default currency – Display the calculated cash flow forecast transactions for transactions in the default currency.
Reporting currency – Display the transaction amounts in the reporting currency.

Print

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:

None – Print the amounts as they are.
1,000 – Multiply the amounts by one thousand units, and print the results.
1,000,000 – Multiply the amounts by one million units, and print the results.

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

#1-#2 – The difference between columns 1 and 2.
#1+#2 – The sum of columns 1 and 2.
#1*#2 – The product of columns 1 and 2.
#1/#2 – The ratio of columns 1 and 2.
#1/#2 % – The ratio of columns 1 and 2, expressed as a percentage.
(#1-#2)/#2 % – The difference between columns 1 and 2, expressed as a percentage of column 2.
(#1-#2)/#1 % – The difference between columns 1 and 2, expressed as a percentage of column 1.
(#5+#6)/#3 – The sum of columns 5 and 6, divided by column 3.

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:

Current – The column will contain only transactions that have been posted to the Current posting layer.
Operations – The column will contain only transactions that have been posted to the Current or Operations posting layers.
Tax – The column will contain only transactions that have been posted to the Current or Tax posting layers.
Operations minus tax – The column will contain only transactions that have been posted to the Operations posting layer, minus transactions that have also been posted to the Tax posting layer.
Only operations – The column will contain only transactions that have been posted to the Operations posting layer.
Only tax – The column will contain only transactions that have been posted to the Tax posting layer.
Operations plus tax – The column will contain only transactions that have been posted to the Operations or Tax posting layers.
Total – The column will contain only transactions that have been posted to the Current, Operations, or Tax posting layers.

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.