Creating Automatic Forecast Reduction in AX

By Adele Graser | December 15, 2015

Creating automatic forecast reduction in ax

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. If you’re a Power BI user, check out this article on Power BI Forecasting.

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

Recommended Reading:

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X