Creating Automatic Forecast Reduction in AX

by | Updated August 15, 2016 | Dynamics AX, Financials, Project Management, Set Up

When managing projects it is important to manage your forecast for the project. Without a forecast, it can become very difficult to analyze how successful you are, as you won’t have anything against which to measure your actuals. Also, when working with fixed price projects that have long durations, forecasts are very helpful for calculating a percentage of completion for revenue recognition. As much benefit as forecasts can be, they can also be very tedious to manage.

Forecasting Tools in AX

AX offers a few different tools for creating the forecast, including copying from a project quote or copying from estimates entered against the WBS. However, for this post, I just want to focus on a piece of functionality that automatically reduces your forecast as transactions are posted against the project. When reviewing the status of your project and trying to analyze how you are doing compared to what you forecasted, you usually go through a few steps. First you review the transactions that have been posted and get a report on the actuals. Then you decide how much effort and/or costs you have left to complete the project. Finally, you subtract your actuals from your forecast to determine how much of your forecast is left and compare that to your estimated amount to completion. Using the automatic forecast reduction functionality in AX, this process can be streamlined.

Setting Up Automatic Forecast Reduction in AX

  1. To setup a forecast to automatically reduce, you first need to setup a forecast model. (Project management and accounting > Setup > Forecasts > Forecast models).

When you create your new forecast model, select the checkboxes in the Automatic forecast reduction section for the types of transactions you want to have automatically reduce your forecasts. In the example below I have selected to have both Hour and Item transactions automatically reduce my forecast.

Forecast Model

 

2.   The next step in the setup is to define the rules for which forecast line entry gets reduced when a transactions gets posted. To do this, go to the Forecast reduction section of the Project management and accounting parameters (Project management and accounting > Setup > Project management and accounting parameters).

Project Management in Dynamics AX

These parameters define the priority of the fields that need to match between the posted transaction and forecast line in order for the forecast to be automatically reduced.

  • First, select fields from the Remaining section and click the “>” button to move them to the Selected section. Use the Up and Down arrows to change the priority. The fields at the top of the list will have the highest priority.
  • The next piece is to select the Minimum requirement for that transaction type which specifies how many of the fields have to match at a minimum in order for the forecast to be reduced. In the example above I have Category set as my minimum requirement for the Hour forecast which means, based on my selected fields, that both the Parent project and the Category have to match in order for the forecast to be reduced.

Expense & Item Forecasts

For Expense and Item forecasts, there is a final piece of setup which is to specify a Lump sum allocation key. The purpose of this allocation key is to define a lump sum of item or expense costs that is forecasted rather than forecasting specific items or expenses.

  • To setup an allocation key for expenses go to Project management and accounting > Setup > Forecasts > Project allocation keys.
  • To setup an allocation key for items go to Inventory management > Setup > Forecast > Item allocation keys. Once you create the allocation key, set it as the Lump sum allocation key for the Item forecast or Expense forecast.

Example of Reduction Forecast Model

Now that the setup is complete, all you need to do is create a forecast on your project using your new reduction forecast model. Below is an example hour forecast I setup which has a separate line for each category.

Reduction Forecast Model

Now when I post a couple of hours transactions, I can see how the reduction forecast is automatically reduced. (Note that the hour transaction with a category of ProjectMngr didn’t reduce the forecast).

Forecast Model Reduction

Using this automatically reducing forecast I can easily see how much of my forecast I have remaining and compare that to how much effort I expect to be left without doing a lot of manual calculations.

Related Posts

  • If you are using TFS for version control and you check labels in and out, you know the labels can be confusing.  What happens is, when you create a new…

  • I recently came across an issue dealing with project validation in Dynamics AX. Displayed here are a couple setup features in the project management and accounting module and  some tips that might help…

  • Dynamics AX supports the business case of a customer returning goods through the use of a return order. The blog post will start with a customer invoice, then show how…

2 Comments

  1. Rajeev VK

    Hi,
    Thank You so much ..

    As I have followed the same setup and not getting the expected resuly

  2. Brandon Carmichael

    Hello Rajeev:

    I’d be happy to help. What results are you getting versus what are you expecting? Are you getting any warnings or errors?

    By providing me more specific information, I’m hoping I can help you get the results you are expecting.

    Thank you,
    Brandon

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