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”

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”

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”

How to collect financial data by sites in Dynamics 365 for Finance and Operations

How to collect financial data by sites in Dynamics 365 for Finance and Operations

Let’s say you work for a company that has a few sites. The company uses MS Dynamics 365 for Finance and Operations (aka D365FO). The chief financial officer of the company has a requirement to collect costs of goods sold (aka COGS) and revenues by sites of the company. It is needed to report margin individually for each site. You are in charge of resolving this request. In this blog post I will show you how the requirement can be met.

This post is also applicable to MS Dynamics AX 2012 (aka AX 2012, or DAX 2012).

Continue reading “How to collect financial data by sites in Dynamics 365 for Finance and Operations”

Financial dimension values flow in D365FO. Materials and batch order example

Financial dimension values flow in  D365FO. Materials and batch order example

MS Dynamics 365 for Finance and Operations (aka D365FO) offers a very strong financial functionality. A company can collect financial data in different dimensions. For example collecting data for overhead expenses and adding a cost center for every ledger entry.

D365FO allows setting default values for different master records like products, vendors, customers, and so on. As an example, a cost center can be set on all finished goods items and materials consumed. These values go to the ledger by default.

In this post, I will show you how the default values go to the ledger. I use D365FO batch order functionality to demonstrate how it works. Continue reading “Financial dimension values flow in D365FO. Materials and batch order example”