Financial Management in Dynamics 365 Finance – An Overview

By Cindy Weiland-Wehrley | September 13, 2021

cindy 2

Make life easier for your finance team with features and functionality within Dynamics 365 Finance created to streamline and simplify processes. This blog provides an overview of the finance function and key areas to keep in mind.

General Ledger Components in D365 Finance

The general ledger is comprised of the chart of accounts (also called main accounts), dimensions, and structures. Dimensions attach to main accounts, creating structures.

Chart of Accounts in D365 Finance

The chart of accounts is a collection of main accounts that is used as an entity. Compared to legacy segmented accounts, Dynamics 365 main accounts simplify processes by reducing the number of necessary accounts. Accounts can be added by item category and shared by multiple legal entities.

Chart of accounts is found under the general ledger in D365 Finance and Operations

Dimensions in D365 Finance

Dimensions add another level of detail to the main account. They work similarly to segments in legacy accounts but exist behind the scenes as an additional account layer. When creating dimensions, consider what additional detailed information you need to know about main accounts when you drill down. For example, dimensions could include a business unit, product line, department, or sales representative.

GL Structure D365 Finance

The GL structure puts pieces together in a useful way.

4 Pieces: business unit, main accounts, product line, and department

Dimensions are not always relevant, and you may not want to attach all dimensions to all main accounts. Structures allow you to assign applicable dimensions to main accounts. After defining your main accounts and dimensions, assign the chart of accounts and GL structure(s) to the general ledger for the legal entity and activate it.

Automating Dimension Posting: Master Files Financial Dimensions Assignments in D365 Finance

There is a section on financial dimensions within each master file. Once you have defined your entity structure, all possible dimensions in your structure will show on each master card. For example, if customers drive your business unit, you can assign a business unit to your customer card. Every time a transaction happens with that customer, the business unit is automatically attached as a dimension to the account.

The same can be done with released products. Perhaps you would like to assign an item group every time a particular item is used. To accomplish this, go through your item master and assign important item groups. This can also be applied to vendors.

Trial Balance Reporting in D365 Finance

Main accounts and dimensions provide flexible reporting on the trial balance. Define financial dimension sets to meet your needs and use them to view the trial balance at various levels.

Financial Reporter in D365 Finance

The financial reporter runs financial statements, typically at the end of the month. This tool is also used to drill down and see transactions with dimensions. Reporting trees can be set up to run reports by dimension.

How to Start Planning Your General Ledger

When planning your general ledger, start with the end in mind. Review reporting current requirements and imagine what your dream financial analysis reports would look like. Consider customer and product markets as they relate to your business.

Build dimensions to meet identified needs. Create a chart of accounts with only main accounts and design GL structures to assign dimensions. Create your general ledger by merging your COA with your GL structure.

If you’re new to Dynamics 365, or if you’re considering implementing the solution at your business, reach out to the experts at Stoneridge Software. We can help you get the most out of the solution.

 

 

 

 

 

Related Posts

Recommended Reading:

6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Organize and Prioritize Your Resources with Dynamics 365 Field Service

As a manager, Dynamics 365 Field Service lets you optimize the use of your employees, their skillsets, and other resources […]

Read the Article

Stoneridge Software Cracks the Top 20 on Bob Scott’s Top 100 VARs 2022

Stoneridge Software is ranked at #20 on Bob Scott’s Top 100 VARs for 2022. Each year, industry publisher, Bob Scott, […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X