Dynamics AX Tip: Percentage complete calculation for revenue recognition, based on WBS Work Percentage Complete for fixed price projects
Today we go over a cool Dynamics AX tip: Going over calculations for revenue recognition. Sounds boring but the results are worthwhile!
Table of Content
Traditionally, the 2 primary methods of revenue recognition for a fixed price project were the “Completed Percentage” and the “Completed Contract” methods. I have explained how these work in Dynamics AX for revenue recognition of fixed price projects in my earlier posts.
With the AX 2012 R3 release (CU 10), the straight line method for revenue recognition was introduced, which I also elaborated in this earlier post.
When you work with the Completed percentage method of revenue recognition, there are multiple ways to determine the percentage completion of a project. Some of these options are,
Manage percentage completion on a manual basis
Use project budgets or forecasts to the system automatically keep track of % complete.
The new method to calculate % completion on a project is based on the WBS percent complete. In this quick post, we will how this works.
The first step for this is to setup the Cost template and select the Completion based on as “Work percentage complete”. See screenshot below.
Once you have that, associate it with the project group. See screenshot below.
The next step is to setup the fixed price project and establish the project plan, which is basically the work breakdown structure. Once you have your WBS defined and the cost estimates established, Dynamics AXwill automatically keep track of the “Percentage completion” for the project based on the WBS estimates vs the actual transactions. I have setup a very basic WBS for this walkthrough.
After I have progressed in the project and transactions (Timesheets, Expense reports, Purchase orders, journals etc.), Dynamics AX automatically starts tracking the % complete for the project at each task level of the project. See screenshot below.
Let us say, at this point you are ready to run the revenue recognition for this project for the Month of August 2016.
Navigate to the Project revenue recognition screen and click Create. You will notice here that “Work progress percentage” is a new option under the “Cost to complete method” dropdown. But we will just leave it as default (From cost template).
Notice that after we have run the revenue recognition, system automatically shows the Percentage completion based on the WBS work percent complete.
The process after this is pretty straight forward and as you would run the revenue recognition typically for the fixed price project.
NOTE: The intention of this blog post was not to explain the end to end process of revenue recognition for fixed price projects. I have explained these in detail in my earlier posts. This post was specifically a quick tip to highlight the new method of automatic work percent complete calculation.
Sandeep Chaudhury is a Dynamics AXenthusiast with over 10 years of experience in functional consulting, Solutions architecture and systems integration, with expertise in the areas of Professional services automation(Project Management and accounting), Financials Management, Services Management, Sales and Marketing, Human resource management, Travel and Expenses Management and Procurement & Sourcing modules of Microsoft dynamics AX ERP. He has experience working with the new Dynamics AX (AX 7), AX 2012 R3, AX 2012 R2 and more.
Want to learn more about AXIO for Professional Services and Dynamics 365? Register for our webcast on September 13th at 2 PM EDT.
Field service providers can scale their operations in one of two ways. They can grow their workforce larger, so they can handle more new projects and service more customers. Or they can make operations more efficient, allowing them to perform more work with the same number of personnel. Since the current labor shortage will likely…
To truly understand what your customers think, it’s time to “ditch the crystal ball” trying to find the answers on your own. Instead, give your customers a “voice” so they can tell you themselves. That’s the only way to know for sure how they feel about your products and services and to determine the needs…