• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Tag Archives: Earned Value Analysis

Earned Value Management (5)

25 Friday Mar 2016

Posted by Ludwig Reinhard in Project

≈ Comments Off on Earned Value Management (5)

Tags

Earned Value Analysis, Project controlling, Project module

… continued from part (4)

The following screenshots summarize – for reasons of completeness – the project transactions and postings generated for the example used.
EN_84_0195EN_84_0196

As shown already before in slightly different form, a simple actual-budget comparison is not sufficient to control long-term projects. In the example used the project was running behind schedule and above budget right from the beginning until the end of the project (see the schedule and cost variance lines). Yet, the actual-budget comparison did not provide any indication that a problem might exist until August 2016. EN_84_0200 EN_84_0201

Earned Value Management (4)

25 Friday Mar 2016

Posted by Ludwig Reinhard in Project

≈ Comments Off on Earned Value Management (4)

Tags

Earned Value Analysis, Project controlling, Project module

… continued from part (3)

G. Dynamics AX Project Analysis
Within this subsection, the standard Dynamics AX earned value management tools will be analyzed and compared to the additional analysis option arising from the project setup and posting exemplified before.

G.1. Dynamics AX Standard Earned Value Analysis Tools
The standard Dynamics AX earned value analysis tools consist of an EV chart and an actual vs. forecast chart and are illustrated in the next screen-print. As both charts rely on the standard Dynamics AX SSAS cubes, a processing of those cubes is required before project analysis can be made.
EN_84_0166
What you can identify from the EV chart is a single EV data point that is identical to the planned value as the project has been finished. Interestingly, the EV data point is reported at the beginning of the project as all transactions have been recorded in future periods. As the EV chart is only able to calculate and illustrate one single EV data point, not detailed EV analysis over the lifetime of the project can be executed. What is more, actual costs values cannot be identified from the chart. Whether this is a bug in the authors Dynamics AX test environment or whether this is a general lack of the EV chart tool could not be identified.
The lower actual vs. forecast chart compares the actual and forecasted, that is planned, project values. As mentioned in the beginning of this post, such a comparison does not make much sense as the underlying reason for the actual vs. forecasted difference cannot be identified.

Based on this analysis, it can be summarized that the standard EV analysis tools available in Dynamics AX are not of much use for a detailed project analysis.

 

G.2. Alternative Dynamics AX Standard Earned Value Analysis Tools
Now let’s have a look at the additional project analysis opportunities that the project setup and project postings shown above offer.

The first thing that you can identify when opening the fixed price project estimate window is the EV that has been calculated and posted for the different project stages and that can be identified in the accrued revenue column of the estimate form.
EN_84_0170
In addition, the cost variance can be identified in the general tab of the estimate form.
EN_84_0175
Through a personalization of the estimate form, the EV and cost variance can be identified by default in one single screen for the different project stages without implementing any system adjustment.
EN_84_0180
Unfortunately, the schedule variance cannot be identified by default in the estimate form. Yet, as the schedule variance is defined as the simple difference between the planned and earned value, a simple system modification allows also including this value in the estimate form as well as other project reports.

If you shun making a system modification for executing the EV analysis you can also use the Management Reporter (MR) for doing this analysis. The only prerequisite for doing the analysis in MR is that forecast values have been copied to the budget module.
Once this has been realized the EV analysis can be executed by setting up a simple MR report that combines actual and budget values. Example:
EN_84_0190

 

H. Summary
Overall it can be summarized that Dynamics AX fully supports the Earned Value Management technique through a corresponding project setup.

What is more, the project accounting approach illustrated in this blog post allows creating project and financial statements based on the POC (percentage of completion) as well as the CC (completed contract) method in parallel and thus allows you following different accounting principles such as local GAAP, IFRS and US-GAAP in parallel.

… to be finalized in part (5)

Earned Value Management (3)

20 Sunday Mar 2016

Posted by Ludwig Reinhard in Project

≈ Comments Off on Earned Value Management (3)

Tags

Earned Value Analysis, Project controlling, Project module

… continued from part (2)

F. Dynamics AX Project Processing

F.1. Record Fee Transactions For The T&M Project
After finishing all the necessary setups, project work started. The first thing that I did was recording three fee transactions for the T&M project that are used for invoicing the customer.
EN_84_0095

Please note that project fee transactions do not generate any ledger transaction at the time they are recorded through a project fee journal as no costs are related to project fee transactions.
EN_84_0100

 

F.2. Invoice Customer Through T&M Project
After recording the fee transactions – for reasons of simplicity and illustration – I directly invoiced the customer. The outcome of those invoice transactions can be identified in the following screenshots.
EN_84_0105 EN_84_0110
Please note that project revenue is recognized through the invoices created from the T&M project. This way of recognizing revenue is required in order to make the EV calculation work.

 

F.3. Record Hours & Expenses
My next steps were recording the hour and expense related transactions for the fixed price project for each of the different project stages. Example: EN_84_0115
EN_84_0120

 

F.4. Mark Project Stage As Completed
After the work for each project stage was finished, the stage was marked as complete, which resulted in a recalculation of the progress percentage (POC) for the whole project.

Example: Before marking the first project stage as completed, a POC of 9,56% can be identified.
EN_84_0125

After marking the first project stage as completed, a POC of 9,7% is calculated due to the change in the remaining effort column.
EN_84_0130

 

F.5. Run Project Estimate
After posting hours and expenses and marking the different project stages as complete, fixed price project estimates were run and posted.
EN_84_0135

Example for running the project estimate for the first project stage:
EN_84_0140

Note: The cost template that is used here has the completion method “work in progress percentage” selected as illustrated in the next screen-print.
EN_84_0145

Result: The outcome of the estimate calculation can be identified in the next screenshot.
EN_84_0150
What you can identify from the above screenshot is the POC of 9,7% that was identified earlier in the WBS form. In addition you can identify a “contract value” of $1218000 that is identical to the planned value of the project that has been setup as the on-account milestone for the fixed price project.

Based on the POC and the “contract value”, an accrued revenue (“earned value”) amount of $118088,64 is calculated based on the following formula:
EN_84_0155 EN_84_0160

After posting the first estimate, the following ledger transactions result:
EN_84_0165
From an accounting perspective, those transactions can be interpreted as follows:

  • First, the hour and expense transactions that are initially posted against the WIP cost value account do not have an influence on the company’s overall profitability as they are recorded on Balance Sheet (BS) accounts only,
  • Second, the transfer of the amounts posted on the WIP cost value ledger account to the project cost account when posting the estimate reduces the company’s profit as costs are shifted from balance sheet accounts to income statement accounts,
  • Third, the WIP sales value and accrued revenue posting that records the EV for the first project stage can be used for project controlling purposes to match project costs and revenues and to calculate the cost and schedule variance. As statistical accounts are used for recording this posting, no immediate effect on a company’s profitability – as reported in external financial reports – can be identified.
  • Fourth, the first customer invoice posting in Feb-16 records the project revenue that is used for external reporting. This transaction together with the WIP sales value and accrued revenue transactions allow combining and analyzing projects in line with the POC (percentage of completion) and CC (completed contract) method.

F.6. Repeat Steps F3 – F5
For each project stage, repeat the steps F3-F5 until project work is finished.

… to be continued in part (4)

← Older posts

Communities4Future

Dynamics UserGroup Deutschland

Project Accounting Book – Part 2

Project accounting book

Categories

  • Accounts Payable
  • Accounts Receivable
  • Bank Management
  • Book reviews
  • Budgeting
  • Cost accounting
  • Fixed Assets
  • General Ledger
  • Inventory
  • Management Reporter
  • Miscellaneous
  • Podcast
  • Project
  • Sustainability
  • Uncategorized

Tags

Advanced bank reconciliation Allocations Bank reconciliation Budgeting Controlling Cost accounting Cost accounting module Cost center accounting customer D365 D365FO Dynamics AX Dynamics AX 2012 Electronic reporting Email Environment Fixed asset statement General Ledger journal Global Warming indirect costs intercompany Inventory Inventory reconciliation invoice invoice recording IOT Management Accounting Management Reporter Modern Finance MS Flow MT940 PowerApps PowerAutomate PowerPlatform Project Project module Purchase Order Resource scheduling Sensor settlement SharePoint Sustainability Sustainability Accounting Tax time recording timesheet Vendor invoice recording Vendor payments WBS workflow

Important Websites

  • Dynamics AX/365FO Links

Legal

  • Disclaimer

Subcribe

  • RSS - Posts
  • RSS - Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Archives

  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015

Blog at WordPress.com.

  • Follow Following
    • Dynamics 365FO/AX Finance & Controlling
    • Join 569 other followers
    • Already have a WordPress.com account? Log in now.
    • Dynamics 365FO/AX Finance & Controlling
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...