Configuring a 12-Month Periodic Trend Income Statement in D365 F&O

Welcome to our comprehensive guide on configuring a 12-month periodic trend income statement using Financial reports in D365 Finance and Operations (D365 F&O). This guide will walk you through the entire process, ensuring you can effectively set up your income statement to reflect monthly trends over the past year.

Understanding Financial Reports in D365 F&O

Financial reports are crucial for financial experts and accounting professionals. They provide insights into an organization’s financial health and performance over time. In this session, we will build upon previous discussions about financial reports in the General Ledger (GL) and budgeting module, focusing on enhancing the income statement with new features.

Setting Up the Report Definition

To start, we will select our existing report definition and click on "Edit." This action opens the report designer tool, displaying the report definition we created in our last session.

The report definition consists of two main components: the row block and the column block. The row definition outlines the various heads in our financial statement, specifically in this instance, the income statement. You will see row numbers alongside descriptions for each row, linked to financial dimensions or main accounts.

It's essential to remember that the row definition can be reused multiple times across different report definitions, maximizing efficiency in report creation.

Creating a New Column Definition

In today’s session, we will introduce a new column definition to explore the periodic trend within the income statement on a month-wise basis. This will allow us to visualize the income statement's performance from January to December, reflecting the income statement's periodic trend.

Defining the Column Structure

To begin, we will define a new column definition focusing on a 12-month periodic trend. The existing column definition had a fiscal period and year-to-date trend, but now we need to create a new one to capture monthly data.

Within the new column definition, we will:

• Set the first column (Column A) to display the descriptions from the row definition.
• In Column B, select the amount from the financial dimension (FD), which will showcase the balance for each row in the income statement.

Next, we will define the periods, starting with January (period 1). For the header, we will insert auto text to display the full month name (e.g., January).

Copying and Adjusting Monthly Columns

After defining January, we will copy this structure across the columns for the remaining months. Each subsequent column will simply reflect the month number, adapting the header name accordingly. Here’s how we will set it up:

1. Column 1: January
2. Column 2: February
3. Column 3: March
4. Column 4: April
5. Column 5: May
6. Column 6: June
7. Column 7: July
8. Column 8: August
9. Column 9: September
10. Column 10: October
11. Column 11: November
12. Column 12: December

In addition to these monthly columns, we will also insert an additional column for year-to-date totals, which will summarize the data from January to December.

Finalizing the Column Definition

Once we have arranged the columns, we will save this new column definition under a suitable name, such as "12 months periodic trend." It’s crucial to place this in the same folder as our previous definitions for easy access.

Creating the Report Definition

Now that we have our column definition set up, we need to create a new report definition. Unfortunately, there isn't an option to copy the existing definition directly, so we will create a new one from scratch.

During this process, we will:

• Select the relevant company.
• Set the detail level to financial account and transaction.
• Reuse our existing row definition.
• Select our newly created column definition for the report.

In the output and distribution settings, we’ll name the report "Income Statement 12 Months Periodic Trend" and proceed to the header and footer configuration.

Configuring the Header and Footer

In the header section, we will insert auto text for the company description and the reporting date. It’s also wise to include the generated date and time for clarity. This ensures that anyone reviewing the report can easily identify when it was created.

Additionally, we will adjust some settings, such as disabling the display of the currency symbol on the first row and ensuring that zero amounts are displayed as blank, enhancing the report's readability.

Running the Report

After saving the report definition, we can run it to generate the income statement. If for some reason the report doesn’t appear in the designated folder, a quick refresh (Control + Shift + F5) can resolve the issue.

Once generated, the report will display the income statement with data segmented by month, illustrating the organization's profitability over the last 12 months along with year-to-date balances for each head.

Reviewing the Income Statement

Upon reviewing the newly generated income statement, you will see the left side populated with the heads of the income statement and the right side showcasing each month’s performance. This structure provides a clear view of how the organization has performed financially throughout the year.

In summary, we have successfully maintained our row definition while adding a new column definition that captures monthly trends. By adjusting the period numbers for each month, we created a comprehensive income statement reflecting a full year of financial activity.

Looking Ahead

In our next session, we will delve deeper into management reporting, exploring additional features and functionalities available in D365 F&O. Thank you for joining this session, and I hope you found it informative and useful. Take care!