Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Create financial reports in Microsoft Dynamics 365 Business Central

Microsoft via Microsoft Learn

Overview

  • Module 1: Do you want to know how to create financial budgets in Business Central? If so, then this module is for you. It explains how to set up general ledger budgets in Business Central, demonstrates how to create budgets manually, and shows how to copy and import budgets from Microsoft Excel.
  • By the end of this module, you will be able to:

    • Create a new general ledger budget.
    • Enter budget entries manually.
    • Create budgets by using the Copy Budget function.
    • Export budgets to Excel.
    • Import budgets from Excel.
  • Module 2: If you want to know more about financial reporting in Business Central, then follow along with this module to find out about how to create account schedules to create your own customized reports without needing to develop them.
  • By the end of this module, you will be able to:

    • Set up account schedules.
    • Set up column layouts.
    • Use account schedules and column layouts to compare actuals to budgets.
    • Export account schedules to Microsoft Excel.
  • Module 3: Do you want to analyze your business using dimensions? If so, then complete this module and discover how you can use dimensions in financial reports. After demonstrating how to use global dimension in financial reports, this module also explains how to set up analysis views and run analysis by dimensions.
  • By the end of this module, you will be able to:

    • Use global dimensions in chart of accounts analysis reports.
    • Filter account schedules by using global dimensions.
    • Configure account schedules with global dimensions.
    • Set up analysis views.
    • Run an analysis by dimensions.
    • Combine analysis views with account schedules.
  • Module 4: Do you want to have a better insight into your cash flow? If so, then this module is for you. In this module, you can find out how to use the cash flow forecast in Dynamics 365 Business Central to generate predictions of a company’s cash flow. After explaining the cash flow forecast setup, this module then explains how to create cash flow forecasts in addition to demonstrating how to use machine learning in Business Central cash flow forecasting.
  • By the end of this module, you will be able to:

    • Understand how to use the cash flow forecast feature in Business Central.
    • Enable the option for using machine learning (Cortana Intelligence) in cash flow forecasting.
    • Set up a chart of cash flow accounts.
    • Create a cash flow forecast.
    • Analyze a company’s future cash flow by using account schedules.
    • Configure the cash flow forecast chart in the role center.
  • Module 5: Do you want to explore how to file reports by using eXtensible business reporting language (XBRL)? This module focuses on XBRL in Dynamics 365 Business Central. It explains the terminology that is associated with XBRL and demonstrates how to import and update taxonomies. Additionally, you will find out how to export an instance document.
  • By the end of this module, you will be able to:

    • Understand the terminology that is associated with XBRL.
    • Import and update taxonomies.
    • Attach, update, and apply linkbases to taxonomies.
    • Enter XBRL line definitions.
    • Export an instance document.

Syllabus

  • Module 1: Create budgets in Dynamics 365 Business Central
    • Introduction - Create budgets manually
    • Copy budgets
    • Export and import budgets
    • Exercise - Create and copy budgets
    • Check your knowledge
    • Summary
  • Module 2: Configure financial reports by using account schedules in Dynamics 365 Business Central
    • Introduction and set up of account schedules
    • Create column layouts
    • Export your account schedule to Excel
    • Exercise - Create an account schedule
    • Check your knowledge
    • Summary
  • Module 3: Use dimensions in your financial reports in Dynamics 365 Business Central
    • Introduction to the G/L balance by dimension report
    • Filter account schedules by using global dimensions
    • Create an analysis view
    • Combine analysis views with account schedules
    • Check your knowledge
    • Summary
  • Module 4: Forecast your cash flow in Dynamics 365 Business Central
    • Introduction to cash flow forecasts
    • Use assisted setup to set up cash flow forecasting
    • Set up cash flow manual expenses and revenues
    • Create a cash flow forecast
    • Analyze the forecasted cash flow
    • Check your knowledge
    • Summary
  • Module 5: Set up XBRL reports in Dynamics 365 Business Central
    • Introduction to XBRL terminology
    • Work with taxonomies
    • Work with linkbases
    • Enter XBRL line definitions
    • Export an instance document
    • Check your knowledge
    • Summary

Reviews

Start your review of Create financial reports in Microsoft Dynamics 365 Business Central

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.