Budgeting for Construction Projects in Dynamics AX 2012 R3

by | Updated May 18, 2017 | Construction, Dynamics AX, Project Management, Set Up

When budgeting a construction project, the things we are most concerned with, besides revenue, are the cost of our labor, material and equipment. These are three major items that can lead to the success or failure of our project. To effectively budget and track your progress, a budget for a construction project in Dynamics AX should give a project manager an overview by transaction type (labor, material and equipment) and a detailed view by Project Category and Category Group.

Accomplishing Construction Budget Goals with Dynamics AX

Labor

The expansion of the Work Breakdown Structure functionality allows Project Managers to schedule projects directly in Dynamics AX 2012 or to integrate from Microsoft Project if they so choose.  Using the WBS within Dynamics AX lets the Project Manager prepare a detailed estimate of the amount of work necessary to complete the project by role or individual resource.  From there, the WBS can be imported directly to the Project Budget, using Project Category and Activity to provide a detailed budget of hours.  While the same budget lines can be produced from an Hours forecast, the WBS and Scheduling options provide additional information the Project Manager will find useful.  Knowing how many electricians, plumbers, etc. a project will need and when they will be needed can cut down on wasted time and effort.

Material

Just as with labor hours, an Item Forecast can be established for your construction project, allowing the Project Manager to estimate the quantity and type of material needed for the project.  The Item forecast can also be imported to the Project Budget by Project Category and Activity.  The down side to Item Forecasts is you have to have the items set up in AX.  Procurement Categories aren’t going to cut it so you have to be specific.  On the plus side, you can use Project Categories a little more extensively if you would like.  Either way, you still have the original Item Forecast to go back to and look at your original amounts.

Equipment

This is an area that Dynamics AX doesn’t really have a home for when it comes to Project Accounting.  The challenge is to make it simple enough to use and to isolate the transactions related to equipment in your project.  I have a couple of suggestions that may fit the bill, however you will have to decide for yourself which one meets your needs.

Equipment as a Worker – You could conceivable set up your equipment pieces (i.e. trucks, dozers, cranes, etc.) with worker records alongside your human worker records.  You could then use the resource assignment and WBS to schedule equipment as you would a worker, thus allowing you to import both Labor and Equipment to the Project Budget.  The down side is that all of the lines would be Hours type transactions so they would tend to get lumped together in some views of the Budget and Budget vs. Actual review.  The up side is you have a detailed breakdown of the usage on all of your individual pieces of equipment.

Equipment as Inventory – Equipment seems to lend itself to the Inventory process rather handily.  You could create a Product record for each piece of equipment (or you could create a single product record for all trucks, all dozers, etc.) and use Inventory to transfer between Projects using an Inventory Site/Warehouse for each project.  This gives you a way to track where your assets are and when they are assigned to a specific project and you can set the cost and sell price for each one.  You can also use Procurement categories to keep track of your equipment by group, class, etc.  You can include the equipment in your Item Forecast for import into the Budget and use the Project Categories to separate which transactions are true material and which are equipment.  Be advised however, you will need to carefully set up the posting options for your equipment products as they will be a bit different from material transactions

Equipment as a Project Expense transaction – Probably the simplest process.  Simply set up your Project Categories to reflect your equipment and transaction away.  Of course, you won’t have as much detail as you would with some other options so keep that in mind.

 

I’m sure there are any number of other options that might come to mind so don’t limit yourself to these three.

The decisions you make about Project WBS, Project Categories, Project Category Groups and your Cost Template will influence how you interpret your budget results.

Dynamics AX 2012 provides you with an inquiry to review your Project budget balances and gives you a number of options on how to group your budget and actual transactions.

Transaction Type: This view groups everything into Hours, Expense or Item transactions.  Handy if you use separate Transaction Types for Labor, Equipment and Materials.  You do lose a little detail if you combine Equipment into Items or hours.

Transaction Type in Dynamics AX

Category Group: This is the Project Category Group.  This could come in handy if you are using Workers or Products to track your equipment.  Set up separate Category Groups for Equipment, Workers, Items, etc. and you will get a breakdown by group and each project category under that group.

Category:  This is referring to the Project Category.  A bit more granular than the group level inquiry.

Category Groups in AX 2012

Cost Template:  You can use multiple cost templates to view your project, and include or exclude various Project Categories on each cost template.  The cost template determines which actual transactions are included when calculating the percent complete of the project and thus, the revenue recognized.  You can use multiple iterations of the cost template to review your budget results.  For more information on cost templates, please refer to this Microsoft TechNet article.
Keep in mind that there will be other things that need to be budgeted for during a construction project that fall outside of labor, material and equipment.  These are just some of the basics that will most likely be seen in most projects of this type.

Related Posts

  • The Safari browser is now supported natively on Dynamics AX 2012 R2 as well as being supported on Dynamics AX RTM with a hotfix.  Taken from the updated System Requirements…

  • I put together some certification information on the requirements for Microsoft Dynamics AX 2012 and a proposed training roadmap to get to each of the core certifications.  Rather than have this…

  • With the announcement of the release of Microsoft Dynamics AX 2012 R2, Microsoft released an updated system requirements document for AX 2012: http://www.microsoft.com/en-us/download/details.aspx?id=11094.  Windows 2012 Server is now supported, but…

0 Comments

Submit a Comment

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

Upcoming Events

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

02sep12:00 pm12:30 pmBest Practices for Work Order Planning and Routing for Field Service Companies

09sep10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

09sep12:00 pm12:30 pmOverview of Microsoft Promotion for NAV and GP Clients

10sep11:00 am12:00 pmConfab with Stoneridge - Livestream - Field Service Comparisons

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

16sep12:00 pm12:30 pmHow to Upgrade to Dynamics 365 Finance and Operations: Examining Custom Code and ISV Implications

16sep2:00 pm2:30 pmScheduling and Dispatching for the Modern Field Service Company

23sep12:00 pm1:00 pmDynamics 365 Business Central Wave 2 Release Preview - An Overview of the Most Exciting New Features Coming in October

24sep11:00 am12:00 pmConfab with Stoneridge - Livestream - The Modern Workplace: Teams, Sharepoint, Outlook, Office, and AI Integration

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

30sep12:00 pm12:30 pmEmpowering Your Field Service Technicians with a Mobile Solution

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Orders

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X