Summarize Costs and Revenue of multiple Projects by Financial Dimensions

Indeed it’s the common use  of financial dimensions in Dynamics AX/D3650 – to summarize values across multiple orders/projects/… name it. From my experience some people might not really know how it works and how they might take advantage of it when it comes to building a powerfull project hierarchy.

One scenario where I tend to use it, is when it comes to projects within which we sell items for which we have to grant waranty. The idea then is to close the sales (main-) project and to have a separate warranty project in a separate hierarchy where we want provide warranty services like repairs, service work or, items etc. for the closed project.

 

What we would like to do

Project Financial Dimensions - Approach Overview

Project Financial Dimensions – Approach Overview

 

 

Let’s get started!

 

Set up the sales project

  • Project ID: 119
  • FinDim Project ID: 119
Sales Project Setup

Sales Project Setup

 

 

Post costs to the sales project

Now we would like to see some costs and revenue on the sales project

  • 10 hours PM
  • Cost 200 USD
  • Sales 350 USD
  • On
    • Project ID: 119
    • FinDim Project ID: 119
SalesProject - Post Journal Lines

SalesProject – Post Journal Lines

 

 

 

 

 

 

Check the first voucher

Lets have a look at what we have done

  • -2.000 Payroll
  • + 2.000 Project Costs and FinDim Project 119 (Sales Project)
  • + 3.500 Acc Receivable
  • – 3.500 Revenue – Labor and FinDim Project 119 (Sales Project)
Sales Project Voucher

Sales Project Voucher

 

 

 

 

 

 

 

Set up the warranty project

Now as we have results on the first project as we expected it to be, lets go ahead with the second project – our warranty project

  • Project ID: 112
  • FinDim Project ID: 119
Warranty Project Setup

Warranty Project Setup

 

 

Post warranty costs via Hour Journal

Now as we have set up the warranty project, which could also be available in a separate project hierarchy tree, we are now going to post some costs

  • 2 hours PM
  • Cost 200 USD
  • Sales 0 USD
  • On
    • Project ID: 120
    • FinDim Project ID: 119

 

Warranty Project - Post Journal Lines

Warranty Project – Post Journal Lines

 

 

 

 

 

Check the second voucher

Now lets have a look at the second voucher

  • – 400 on payroll
  • + 400 on project costs and FinDim Project 119 (Sales Project)
Warranty Project Voucher

Warranty Project Voucher

 

 

 

 

 

 

 

As we can see – this posting now referenced to the intial sales project and we have the magic link between both: sales and warranty project.

 

Reporting Results

To see the results we will first check the standard report of Microsoft Dynamics AX Project Management and Accounting.

We will use the report “Project Profit and Loss” and we will filter on the Financial Dimension “Project” with a value of 00000119

 

Filter Project profit and loss report

Filter Project profit and loss report

 

 

The results are very clear. The report shows us two projects – the Sales and the Warranty Project. The total margin shows up as expected!

Project profit and loss results

Project profit and loss results

 

 

 

 

Management Reporter

As a last step we would like to see if the management reporter handles the values as expected.

Filtering the management report by the corresponding financial dimension and we receive the desired results.

 

Management Reporter Project Results

Management Reporter Project Results

 

 

 

 

 

 

 

 

 

 

 

 

Summary

We can cleary see that everything works as expected. We are able to have multiple projects and to summarize them by Financial Dimensions in whatever way we want. This gives us the freedom to setup project hierarchies as desired by the process and to report values as desired by the financials.

 

Posted in PMA - Reporting, PMA - Reporting, Project Management and Accounting Tagged with: , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*