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
Navigating the form
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.
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).