How to query financial data in Dynamics 365 Finance

How to query financial data in Dynamics 365 Finance

If you use general ledger, budgeting, or cashflow forecast in Dynamics 365 Finance (D365F), then you may also need to utilize the “Financial reports” functionality. Balance sheet, income statement, cash flow – all of them can be prepared by using this financial reporting tool. In this blog post, I explain the options you have in setting up and querying financial data by using the financial reporting feature in D365F.

Besides this article, I also recorded videos about the financial reporting function. If you are new to reporting setup in D365F, please have a look at them. These videos give you a quick overview about the feature:

Financial reporting functionality allows you to generate reports based on the general ledger, cashflow forecast, and budgeting data. Keep reading to find out how to get financial data from those sources.

Continue reading “How to query financial data in Dynamics 365 Finance” →

Advance payment to vendor in Dynamics 365 for Finance and Operations

Advance payment to vendor in Dynamics 365 for Finance and Operations

Sometimes companies need to make prepayments to their suppliers. It’s not difficult to manage advance payments by utilizing modern software. In this post I explain functionality regarding advance payments (prepayments) in Microsoft Dynamics 365 for Finance and Operations (D365FO).

This post is also applicable to Dynamics AX 2012 (AX 2012).

Continue reading “Advance payment to vendor in Dynamics 365 for Finance and Operations” →

How to manage accounts payable in Dynamics 365 for Finance and Operations

How to manage accounts payable in Dynamics 365 for Finance and Operations

Every company pays its suppliers. If the pipe of invoices is long, it might be tricky to manage payments efficiently. Modern software can make this process much more efficient and accurate. This post is about accounts payable. I’ll show you how accounts payable can be managed in Dynamics 365 for Finance and Operations (D365FO).

Most functions described in this post are also applicable to Dynamics AX 2012 (AX2012).

Continue reading “How to manage accounts payable in Dynamics 365 for Finance and Operations” →

Sales prices in Dynamics 365 for Finance and Operations

Sales prices in Dynamics 365 for Finance and Operations

Sales in a competitive market is the driving force of a company. One of the critical factors influencing sales volume is sales price. Dynamics 365 for Finance and Operation (D365FO) has a very strong functionality to manage sales pricing in a very flexible way. In this blog post, I cover a lot of available options in D365FO related to sales prices.

This post is also applicable for Dynamics AX 2012 (AX2012).

Continue reading “Sales prices in Dynamics 365 for Finance and Operations” →

The story of a remote Dynamics AX consultant

The story of a remote Dynamics AX consultant

In the beginning of 2017 I got an opportunity to work for an overseas company. I was to visit the client, but the majority of work would be done remotely. As it turned out, the job was 100% telecommute, and I never saw the people I worked for in person. The only available communication channels were emails, chat, and Skype calls.

Continue reading “The story of a remote Dynamics AX consultant” →

Standard direct labor cost in Dynamics 365 for Finance and Operations

Standard direct labor cost in Dynamics 365 for Finance and Operations

This blog post is about the standard costing functionality of Dynamics 365 for Finance and Operations (D365FO) which applies to direct labor costs. This functionality can be beneficial for labor-intensive companies as it allows for strict control of the cost for direct labor employees. By following this guide, you’ll understand the key point about standard direct labor cost setup in D365FO.

This post is also applicable for Dynamics AX 2012.

Continue reading “Standard direct labor cost in Dynamics 365 for Finance and Operations” →

How to set up standard costs for direct materials in Dynamics 365 for Finance and Operations

How to set up standard costs for direct materials in Dynamics 365 for Finance and Operations

Microsoft Dynamics 365 for Finance and Operations (D365FO) offers a great functionality which helps to control manufacturing costs. This functionality is standard costing. In this post, I’ll guide you through the key points needed to set up standard costing for direct materials.

The guide for AX 2012 is available here.

Continue reading “How to set up standard costs for direct materials in Dynamics 365 for Finance and Operations” →

How sales work in Dynamics 365 for Finance and Operations

How sales work in Dynamics 365 for Finance and Operations

Are you interested in knowing more about Dynamics 365 for Finance and Operations? Have a look at the process of sales which can be handled by the system. In this blog post I walk you through the key steps of a sale managed in D365FO and show you the benefits that automation can bring to the company.

This post is also applicable for Dynamics AX 2012 (aka AX2012).

Continue reading “How sales work in Dynamics 365 for Finance and Operations” →

What is CMA certification for MS Dynamics AX consultant?

What is CMA certification for MS Dynamics AX consultant?

I’m a consultant and my job is to help companies to get the best from Microsoft Dynamics software. I primarily work with finance departments. Recently I became a Certified Management Accountant (aka CMA), which means that the Institute of Management Accountants confirmed that I have expertise in finance, analysis, control, and decision support. Although it was difficult, time consuming, and expensive to achieve, I want to tell you about the advantages I got by achieving CMA credentials. Continue reading “What is CMA certification for MS Dynamics AX consultant?” →

What you should know about ledger in Dynamics 365 for Finance and Operations

What you should know about ledger in Dynamics 365 for Finance and Operations

This post is about the key points of Dynamics 365 for Finance and Operations (aka D365FO) ledger functionality. It can be very beneficial to have this knowledge to better understand what is going on under the hood of D365FO. This knowledge helps to solve potential issue you can have with the ledger, such as traceability of the entry to figure out why the entry was created, or resolving inconsistency between ledger and module records.

This post is also applicable for Dynamics AX 2012 (aka AX2012).

Continue reading “What you should know about ledger in Dynamics 365 for Finance and Operations” →