Introduction

Today, we're diving into the financial reports feature in Dynamics 365 Finance and Operations (D365 F&O). Our focus will be on creating an income statement that showcases a quarterly trend over a three-year period. This setup will help you visualize your organization’s profitability across the last three years, broken down by quarters.

Recap of Previous Session

Before we proceed, let’s quickly recap what we covered in our last session. We explored the report definition for a 12-month periodic trend, which was based on monthly data from January to December. Remember, we kept the row definition the same as our first video, which included various heads and ratios for the income statement. This time, we aim to see quarterly trends while keeping the row definition intact.

Understanding the Quarterly Trend Setup

In this tutorial, we will create a new column definition specifically for the quarterly income statement. The goal is to present the financial data in 12-month buckets, but this time, the amounts will be displayed quarterly. Let's get started by establishing our new column definition.

Creating the Column Definition

To begin with, we need to define our column type. This will be based on the row description, which retrieves values from our row definition. For our column type, we will use "FD." Once we select FD, the remaining values will auto-populate, but we need to make a few adjustments.

Setting Up Quarterly Columns

We will label our columns as Q1, Q2, Q3, and Q4. Each header will represent the respective quarters. For the first year, we will set the base to reflect the first four quarters. To make things easier, let’s copy the existing values and create four new columns. This will give us a total of 12 columns, starting from column B to column M, with the first column displaying the description from our row definition.

Fiscal Year Configuration

In the base section, we will set the fiscal year. For the first year, it will remain as "base." Next, we will insert the fiscal period name and fiscal year above the columns. This header will help in identifying the fiscal data more clearly.

Adjusting for Previous Years

Now, let’s move on to the second year. We need to adjust the base year to represent one year prior. This means we will set the base to "base -1" for the first four quarters of the second year. We will repeat this for the third year, setting it to "base -2." This adjustment ensures that our report reflects the correct periods for each fiscal year.

Defining Period Ranges

In our previous monthly trend setup, we inputted single values for each month. However, for the quarterly trend, we need to specify ranges. We will define the quarters as follows:

• Q1: Months 1-3
• Q2: Months 4-6
• Q3: Months 7-9
• Q4: Months 10-12

By using these ranges, we ensure that the correct months are picked up for each base year. It’s crucial to select the right ranges to maintain the accuracy of our report.

Finalizing the Column Definition

After setting up the ranges, it’s time to apply formatting. I prefer the Segoe UI font for the headers, making them bold for better visibility. Once everything is set, save the column definition with an appropriate name, such as "PKR I 3 Years Quarterly Trend."

Creating the Report Definition

Now that our column definition is ready, we need to create a new report definition, similar to what we did in the previous session. Let’s proceed with the following steps:

Steps to Create a New Report Definition

1. Navigate to the report definition section.
2. Select the company and set the detail level to "Finance sh account" and "transactional level." This allows for drilling down to the transactional level.
3. Choose the previously created row definition for the income statement summary.
4. Select the new three-year quarterly trend column definition.
5. Name the report "Income Statement 3 Years Quarterly Trend."
6. In the header and footer, include the company description and reporting date, ensuring the date is in a short format.
7. Disable the currency symbol in the settings since we may need to display different currencies.
8. Untick the option to display blank for zero amounts.
9. Save the report definition as "PKR I 3 Years Quarterly Trend."

Generating the Report

With the report definition saved, we can now generate the report to see how it looks. Upon generation, we can review the data starting from the base year, which in our case is 2016, moving back to 2015 and 2014. You might notice that there’s no data for 2014, but the quarterly trends for 2016 are clearly displayed.

Homework Assignment

As a little challenge, I encourage you to add a fifth column to your report for the year-to-date figures for 2016, 2015, and 2014. Share in the comments how you achieved this by selecting the appropriate options in your column definition.

Looking Ahead

In our next session, we will explore consolidations across two companies, rather than just one. We’ll learn how to manage financial reports for multiple entities, focusing on USRT and USMF. Thank you for joining today’s session, and I hope you found this information useful. Enjoy your day!

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!

Welcome to an insightful exploration of the financial reporting feature within Microsoft Dynamics 365 Finance. This powerful tool empowers finance professionals to generate, manage, and analyze financial statements with unprecedented ease and flexibility. Throughout this guide, we will delve into the setup, generation, and execution of income statements, particularly focusing on the profit and loss statement.

Understanding Financial Reporting in D365 Finance

The financial reporting feature, previously known as Management Reporter or FRX Financial Reports, is a game-changer for financial professionals. It allows users to create a variety of financial statements effortlessly, transcending traditional limitations. This feature not only enhances the reporting experience but also provides immediate access to essential data, facilitating in-depth financial analysis.

The Importance of Financial Reporting

In today's fast-paced business environment, efficient financial reporting is crucial for decision-making and strategic planning. The financial reporting tool in D365 Finance integrates seamlessly with live data, enabling accountants and finance experts to generate reports that reflect real-time business performance.

Setting Up Financial Reports

Before diving into financial reporting, certain prerequisites must be fulfilled. These include:

• Defining the fiscal calendar
• Setting up the ledger
• Creating a chart of accounts for the legal entity
• Posting transactions to at least one account

These steps ensure that your financial reports will yield meaningful results. The setup process involves navigating through the Dynamics 365 interface, specifically within the General Ledger and Budgeting modules.

Prerequisites for Financial Reporting

Make sure your IT department or Microsoft partner has addressed the following:

• Installation of the financial reporting add-in via Lifecycle Services (LCS)
• Configuration of Power Platform integration
• Defining main accounts and dimensions in the financial reporting setup

Navigating the Financial Reporting Tool

Once the prerequisites are in place, users can access the financial reporting feature through various navigational paths within Dynamics 365. The main areas to explore include:

• General Ledger
• Budgeting
• Inquiries and Reports

Each of these areas leads to different financial reporting options and setups, allowing users to manage their reporting needs efficiently.

Security Roles and Permissions

Understanding security roles is vital for managing who can access financial reporting features. The hierarchy typically includes:

• Security Administrator: Maintains financial report security.
• Accounting Manager: Responsible for generating financial reports.
• Accounting Supervisor: Reviews financial performance.

These roles ensure that sensitive financial data remains secure while allowing relevant team members to perform their tasks seamlessly.

Default Financial Reports Available

D365 Finance comes equipped with over 22 default financial reports, which serve as templates for creating customized reports. Some notable examples include:

• 12-Month Rolling Income Statement
• Actual vs. Budget Report
• Balance Sheet Report
• Cash Flow Statement

These reports provide a solid foundation for building tailored financial statements that meet specific organizational needs.

Creating and Modifying Financial Reports

To create or modify a financial report, you will navigate to the financial reports menu, where you can select existing reports or create new ones. The report designer tool is essential for this process, as it allows users to define report structures through:

• Row Definitions: Define the various accounts or categories in the report.
• Column Definitions: Specify the periods or comparisons to be included.
• Reporting Tree Definitions: Structure the report hierarchically, particularly useful for multi-entity organizations.

Understanding Row and Column Definitions

Row definitions outline the accounts or account groups, while column definitions determine the reporting periods. For example, a common income statement might include:

• Rows: Sales, Cost of Sales, Operating Expenses
• Columns: Current Month, Year to Date, Last Year

This structured approach allows you to generate comprehensive reports that reflect business performance accurately.

Executing Financial Reports

Once your reports are created, executing them is straightforward. You can run reports directly from the financial reports menu, which will automatically generate the report for the specified date. For instance, if you run a report for December 31, 2019, the system will display results for that date, allowing you to drill down for more insights.

Interactive Features and Customization

The financial reporting tool includes interactive features that enhance user experience. You can:

• Change report dates and currencies dynamically
• Export reports to Excel or PDF for further analysis
• Schedule reports to run automatically at specified intervals

These capabilities streamline the reporting process and facilitate effective communication within finance teams.

Best Practices for Financial Reporting

To maximize the effectiveness of financial reporting in D365 Finance, consider the following best practices:

• Regularly review and update your row and column definitions to ensure they reflect current business needs.
• Utilize the default reports as templates to save time and maintain consistency.
• Engage with your IT department to ensure proper installation and configuration of the financial reporting add-in.

By adhering to these practices, organizations can achieve more efficient and accurate financial reporting.

Conclusion: Embracing Financial Reporting in D365 Finance

The financial reporting feature in Microsoft Dynamics 365 Finance is a powerful tool that simplifies the generation and management of financial statements. By understanding its functionalities, navigating the setup process, and leveraging its capabilities, finance professionals can enhance their reporting processes, leading to better decision-making and strategic planning.

As you embark on your financial reporting journey in D365 Finance, remember that practice and exploration will lead to mastery. For further inquiries or assistance, feel free to reach out or engage with the community for shared insights and experiences.

Today, we’re diving deep into the PKR ZATCA Integration Solution, a powerful tool designed for businesses operating in Saudi Arabia. This solution has been crafted to ensure that sales invoices comply with the requirements set forth by the Zakat and Tax Authority (ZATCA). Whether you're dealing with B2B or B2C transactions, this integration allows for seamless synchronization of invoices with ZATCA’s FATOORA portal.

Understanding the Need for ZATCA Integration

The introduction of mandatory e-invoicing in Saudi Arabia has transformed how businesses operate. Companies must onboard and synchronize sales invoices to comply with ZATCA regulations. The deadlines vary: B2C transactions require integration within 24 hours, while B2B transactions need to be acknowledged before issuance to the customer. This integration solution is not just about compliance; it’s also about enhancing operational efficiency and data security.

Key Features of the PKR ZATCA Integration Solution

The PKR ZATCA Integration Solution is packed with features that streamline the invoicing process. Here’s what you can expect:

• Onboarding Services: This feature enables businesses to onboard their B2C or B2B operations onto the FATOORA portal.
• Renewal Services: Renewal of digital certificates issued by ZATCA is crucial for maintaining compliance.
• Compliance Services: The solution ensures that your invoicing practices conform to ZATCA requirements, including how to handle debit notes and credit notes.
• Integration with FATOORA: Easily integrate B2C and B2B invoices with the ZATCA FATOORA portal.
• Automated Pull and Push Services: Set intervals to pull invoices from Dynamics 365 and push them to the FATOORA portal.
• QR Code Generation: Generate QR codes that meet Phase-2 requirements.
• Internal Validation: Validate invoices internally to rectify issues before submission.

Onboarding and Compliance Services

The onboarding process is vital for ensuring that your solution adheres to ZATCA standards. Initially, you will receive a preliminary certificate, which is critical for compliance. The renewal of this certificate involves ensuring that your invoicing practices remain aligned with ZATCA's requirements.

In addition, the compliance services check whether your invoices are formatted correctly, including debit and credit notes. This ensures that when you submit your invoices, they meet all necessary standards.

B2C and B2B Invoice Integration

The integration solution caters to both B2C and B2B transactions, which is essential as businesses have varying requirements.

B2C Invoice Integration

For B2C, the integration solution allows for the automated pulling of simplified invoices from the retail and commerce module. Once pulled, these invoices can be converted into the required XML format and pushed to the FATOORA portal.

B2B Invoice Integration

On the other hand, B2B transactions require a more formal approach. The invoices are pulled from the accounts receivable or sales module, ensuring they are prepared for submission to ZATCA.

Automated Pull and Push Services

One of the standout features of the PKR ZATCA Integration Solution is its automated pull and push services. Businesses can schedule these services to run at specified intervals, ensuring invoices are processed efficiently.

• Pull Service: This service pulls invoices from the relevant modules at set intervals, such as every 10 or 30 minutes, depending on your business needs.
• Push Service: After the invoice data has been prepared, this service pushes the ready invoices to the FATOORA portal and retrieves acknowledgments from ZATCA.

QR Code Generation

As part of the Phase-2 requirements, the solution also includes QR code generation. This is a crucial feature that ensures your invoices are compliant with ZATCA regulations.

Internal Validation Process

Internal validation is another critical aspect of the PKR ZATCA Integration Solution. Before any invoice is submitted to the FATOORA portal, it undergoes a validation process to identify and rectify any potential errors. This proactive approach minimizes the risk of invoice rejection by ZATCA.

Exploring the PKR Z Parameters

Let’s delve into the various tabs available in the PKR Z parameters. Each tab serves a specific function that enhances the overall functionality of the integration solution:

General Tab

This tab allows you to enable or disable the solution and set the onboarding date. You can also define whether you're in simulation or production mode.

Company Info Tab

Here, you’ll input essential details such as tax information, company registration numbers, and national addresses. These details are crucial for compliance.

B2B and B2C Certificate Tabs

These tabs store information related to the digital certificates required for compliance. You can track issuance and expiration dates, ensuring you remain compliant.

Customer Types Tab

This tab allows you to map ZATCA customer types to your existing customer groups in Dynamics 365, ensuring smooth integration.

Payment Methods Tabs

In these tabs, you can map various payment methods available in ZATCA with those in your Dynamics 365 setup, ensuring seamless transactions.

Tax Code Parameters

This section allows you to define different tax codes, including zero-rated and exempt categories, which are essential for accurate invoice processing.

Stores Including Tab

For B2C transactions, this tab enables you to enable or disable specific stores, providing flexibility in managing your retail operations.

Request Configuration Tab

This tab manages licensing details and ensures the solution operates effectively within the defined parameters.

Unit of Measure Mapping Tab

Here, you can map units of measure according to ZATCA's requirements, ensuring compliance with international standards.

Integration Logs

The integration logs for both B2C and B2B transactions keep a comprehensive record of all invoice activities. This includes:

• Invoice status updates
• XML details
• QR code generation
• Acknowledgments from ZATCA

Conclusion

The PKR ZATCA Integration Solution is a comprehensive tool that not only ensures compliance with ZATCA regulations but also enhances operational efficiency. By integrating seamlessly with Microsoft Dynamics 365, businesses can focus on their core activities while maintaining compliance with mandatory e-invoicing requirements.

If you’re interested in implementing this solution or have any questions, feel free to reach out via email at This email address is being protected from spambots. You need JavaScript enabled to view it. or WhatsApp at +966-55-1067686.

Thank you for joining us on this exploration of the PKR ZATCA Integration Solution!

Managing financial transactions can often feel overwhelming, especially when users have unrestricted access to post entries in various accounts. This blog post will delve into how to effectively control account types in general transactions within Microsoft Dynamics 365 Finance, ensuring that users can only post to authorized accounts. We will explore the configuration settings available and demonstrate how to implement them through a practical example.

Understanding the Importance of Account Control

When finance users or accounting clerks have the ability to record journal entries without restrictions, it can lead to significant issues. For instance, users might mistakenly or intentionally post transactions to incorrect account types, leading to discrepancies in financial reporting. This is particularly critical when dealing with general transactions, such as accounts payable and receivable.

Each journal entry has a unique voucher number or sequence that helps categorize the transaction. For example, an accounts payable invoice might have a voucher prefix of "AP" while an accounts receivable invoice could be prefixed with "AR." This differentiation is vital for tracking and auditing purposes, making it essential to restrict users to specific account types based on the journal they are working with.

Configuring General Control Settings

To control which account types can be posted in specific journals, Dynamics 365 Finance offers a journal control feature within the Journal setup. This feature allows administrators to define settings that restrict users to certain account types based on the journal they are using. Here are the key settings available:

• Company Settings: Specify whether the settings apply to all companies or to a specific legal entity.
• Account Type Restrictions: Define which account types are allowed for posting in a particular journal.
• Segment Values: Specify the valid financial dimensions and ranges that correspond to the account structures.

Understanding Account Structures

Account structures are crucial for differentiating between various types of accounts in the chart of accounts. Typically, there are two main structures:

• Balance Sheet Accounts: These accounts represent a company's financial position at a specific point in time.
• Profit and Loss Accounts: These accounts show the company's revenues and expenses over a period, ultimately affecting the net income.

By setting up these structures, Dynamics 365 can dictate which financial dimensions are displayed when entering transactions, ensuring that users have the correct options available for their postings.

Setting Up Journal Control

Now that we understand the importance of account control and the settings available, let’s dive into how to set it up in Dynamics 365 Finance.

Step-by-Step Configuration

To configure these settings, we'll navigate to the Journal Ledger module where journal names are defined. Here’s how to do it:

1. Go to Journal Ledger and select Journal Setup.
2. Click on Journal Names to view the available journal types.
3. Select the journal type you wish to configure, such as Accounts Payable Invoice.
4. In the journal setup form, you can define the account types allowed for this journal.

Example Configuration

Let’s consider an example where we want to restrict postings in the Accounts Payable Invoice Journal to only Ledger and Vendor account types. Here’s how to do it:

1. In the Journal Control settings, select the company (e.g., USMF) to apply the settings.
2. Under Account Type, specify that only Ledger and Vendor accounts are allowed.
3. Define any necessary segment values and ranges that correspond to your account structures.

Validating the Configuration

After setting up the restrictions, it’s essential to validate that they work as intended. For instance, if a user tries to post a transaction in the Accounts Payable Invoice Journal using an account type other than Ledger or Vendor, the system should prevent this action and display an error message indicating the invalid account type.

Demonstrating the Configuration in Action

Let’s walk through a practical scenario to see how these settings function in real-time.

Creating a New Invoice

Suppose we are creating a new invoice in the Accounts Payable Invoice Journal:

1. Navigate to Accounts Payable and select Invoice Journal.
2. Create a new journal entry and enter the invoice details, such as supplier number and invoice date.
3. In the account type field, attempt to select a Bank account.

Expected Outcome

As per our configuration, when the user tries to select a Bank account, the system should display an error message indicating that this account type is not valid for the Accounts Payable Invoice Journal. This ensures that only the allowed account types (Ledger and Vendor) can be used.

Simulating Posting and Validation

Next, let’s validate the posting:

1. Simulate posting the journal entry.
2. If the entry is valid, it will proceed without issues; otherwise, an error message will appear, guiding the user to correct the account type.

Conclusion

Implementing account type restrictions in Dynamics 365 Finance is crucial for maintaining accurate financial records and preventing unauthorized postings. By leveraging the journal control feature, organizations can enforce strict rules about which account types can be used in specific journals, enhancing the integrity of financial data.

By following the steps outlined in this blog, you can effectively set up and validate account restrictions, ensuring that your finance team operates within the defined parameters. If you have any questions or need further assistance, feel free to reach out!

Happy accounting!