Financial statement report (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 > Reports > Transactions > Financial statement (traditional).

Use this form to print the traditional financial statements that you defined in the Financial statement form. (Click General ledger > Setup > Financial statement (traditional) > Financial statement (traditional).)

The values from the selected traditional financial statement are used as default values for the fields in this form, but you can change the values.

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.

To print financial statements, you can use the traditional financial statements that are included with Microsoft Dynamics AX, or you can use Management Reporter. For more information about how to print financial statements using Management Reporter, see Management Reporter for Microsoft Dynamics ERP.

This form is available only when the Financial statement (traditional) configuration key is selected.

Example

On March 5, you close the accounts for February and are ready to report to management the accumulated figures for the first two months of the year. The dynamic date interval, Current quarter, includes all transactions that have been posted. This interval includes March 5. However, you require the figures for the months of the quarter that have been closed. Therefore, you require a report that includes only transactions that occurred in January and February.

In this case, you can manually enter a date interval of January 1 to February 28 in each column of the report. However, this is time-consuming if you have columns for current amounts and budgeted amounts. You must also repeat these steps for each legal entity that is included on the same report. Additionally, you might accidentally enter a wrong date in some columns.

Instead, you enter February 28 in the End date field. Then, only transactions that were posted in January and February are included on the traditional financial statement.

Task that uses this form

Generate, print, and export a traditional financial statement

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

Tabs

Tab

Description

Financial statement

Select the output type, financial dimension sets, and row definitions for the report.

Columns

Select the date interval and budget model for the transaction columns in the table.

Setup

Select additional parameters for the layout of the report.

Export to

Select the file format, enter a file name, and then click OK to export the traditional financial statement.

Click Setup to select the file formats to use.

This tab is available only if Export to is selected in the Output type field.

XBRL

Enter a file name, select a version of the eXtensible Business Reporting Language (XBRL) specification, and then click OK to print the selected version to the file.

This tab is available only if XBRL is selected in the Output type field.

Save to

Enter a file name, and then click OK to save the selected version to a file.

This tab is available only if Microsoft Excel is selected in the Output type field.

Button

Button

Description

Select

Open the Inquiry form, where you can filter and sort the records to print on the traditional financial statement. You can also define more specific criteria for the transactions that are included on the traditional financial statement.

Fields

Field

Description

Financial statement

Select the traditional financial statement to print.

Description

The description of the traditional financial statement. You cannot edit this field.

Output type

Select an output type.

  • XBRL – Print the traditional financial statement report as a file that can be used for XBRL reporting.

  • Export to – Print the traditional financial statement report to a file. An extension is added automatically to export files, such as files that are created for country/region-specific file formats.

  • Microsoft Excel – Print the traditional financial statement report to a Microsoft Excel file.

You can export to Excel only if Excel or Excel Viewer is installed.

Primary dimension set

Select the default group of financial dimensions or financial dimension combinations.

Description

The description of the primary financial dimension set. You cannot edit this field.

Secondary dimension set

Select the default group of financial dimensions or financial dimension combinations.

Description

The description of the secondary financial dimension set. You cannot edit this field.

From

Enter the value of the lowest level that is being specified under a single account or dimension.

For example, you want to specify sales accounts and cash accounts for each dimension, but you do not want to specify other receivables accounts. In this case, mark sales accounts as level 1, cash accounts as level 2, and other receivables accounts as level 3. Then enter 1 in the From field and 2 in the To field to set the level interval to 1 to 2.

To

Enter the value of the highest level that is being specified under a single account or dimension.

End date

Enter an end date to additionally restrict information in the date intervals that are selected.

For example, if you enter 12/31/2013 in the To date field, but you enter 12/15/2013 in the End date field, information after December 15, 2013, is not included on the traditional financial statement.

If you enter a value in this field, you cannot use the Reference date field.

Reference date

Enter a reference date for the period. This date is used as the system date for the report, and date intervals that are defined on the Columns tab use this reference date and are adjusted accordingly. For example, the system date is February 2, 2013, Current year is defined as the date interval, and you enter November 15, 2012, in the Reference date field. In this case, the current year is 2012 instead of 2013. If you leave both this field and the End date field blank, the system date determines how the intervals in the From date and the To date fields work.

If you enter a value in this field, you cannot use the End date field.

Row definition for primary dimension set

Select the row definition to use for the primary dimension set on 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 the 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 secondary dimension set

Select the row definition to use for the secondary dimension set on the traditional financial statement.

Print the primary dimension set subtotal amount

Select this check box to print a subtotal amount for the primary set of financial dimensions or financial dimension combinations.

Name

The names of the transaction columns from the Financial statement form.

Date interval code

Select the code for the default date interval.

From date

If the Date interval code field is blank, enter the starting date for the information that is included on the traditional financial statement.

To date

If the Date interval code field is blank, enter the ending date for the information that is included on the traditional financial statement.

Budget model

Select the default budget model for budget columns.

Include submodel

Select this check box to print submodels on the traditional financial statement.

Original or revised budget

Select the budget type to display on the traditional financial statement.

Print range

Select this check box to print a description of the range 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 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.

File name

Enter the file path and name of either the traditional financial statement that you are exporting or the XBRL specification.

Important

The default value is the file path and name that were specified the last time that the traditional financial statement was printed. If you do not change this value, any existing file that has the same path and name is overwritten.

File format

Select the file format for the traditional financial statement that you are exporting. To specify the file formats that you can select from, click Setup.

This field is available only if Export to is selected in the Output type field.

XBRL specification version

Select a version number for the XBRL specification.

This field is available only if XBRL is selected in the Output type field.

See also

Financial statement setup (form)

About traditional financial statements

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