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,

    1. Manage percentage completion on a manual basis
    2. Use project budgets or forecasts to the system automatically keep track of % complete.
    3. 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.

    Cost Template Setup

    Once you have that, associate it with the project group. See screenshot below.

    Project Group

    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 AX will 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.

    WBS Dynamics AX Tip: Percentage complete calculation for revenue recognition, based on WBS Work Percentage Complete for fixed price projects

    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.

    Percent Complete Dynamics AX Tip: Percentage complete calculation for revenue recognition, based on WBS Work Percentage Complete for fixed price projects

    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.

    Revenue Recognition PercentageDynamics AX Tip: Percentage complete calculation for revenue recognition, based on WBS Work Percentage Complete for fixed price projects

    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.

    Regards,

    Sandeep

    Sandeep ChaudhurySandeep Chaudhury is a Dynamics AX enthusiast 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.

    AXIO for professional services webcast