Project Forecast doesn't show the difference between entered expenses in forecast vs the actual requirements ax 2012 r2

(0) Share

Report

Posted on by DynamicsAXExplorer

431

Hi All,

I entered Expenses in Project Forecast form. Then i did the same thing in the Expense journal on the Project. Then i invoiced the project.

When i go to check the difference in actual vs forecasted amounts on the report (Proj Mang Accounting > Reports > Transactions> Forecast Transactions > Project Forecast Transactions ) , i dont see it.

Am i looking at correct report? If not, which report should i see to find the details of estimated vs actuals for a project?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Can you open the control tab and select the cost control button.

Selecte your forecast model and then select calculate.

Once this is done you can export the data to excel if you want to analyze in more detail.

Best regards,

Ludwig

Was this reply helpful? Yes No
DynamicsAXExplorer 431 on at

Like (0)

Report

I dont have the Original, Remaining Forecast Models setup.

1. What should be the setup for those two ? i mean difference.

2. Any steps do you have that i should follow to get this report/excel details accurately ?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

For 1: Just enter your forecast model in the original and the remaining section if you use only one. You might get a warning message that both models are the same but this does not stop the calculation and analysis.

For 2: I would recommend not using project related SSRS reports. They are static and do not allow doing drill downs. Try to use the online forms such as the cost control form. In addition, there is an out of the box project cube available for AX. Try to get this one up and running especially if you need to analyze costs across multiple projects.

Best regards,

Ludwig

Was this reply helpful? Yes No
DynamicsAXExplorer 431 on at

Like (0)

Report

I have entered item forecast on Project as 5 items each x amount totals 110.

In item requirements i had a consumption of 7 items with total 154.

Once the project is invoiced. I went to cost control and did the calculate and it shows like below

Material item 154 (ActualCost) 110(remaining Budget) 264 (Totalcost)

It is not correct right?

I estimated 110, but my consumption is 154. why is it saying remaining budget is 110 and why is it showing 264 as total cost?

@Dr. Ludwig Reinhard

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi DynamicsAXExplorer,

The most likely reason is the way how you setup your project management and account parameters.

Have you checked how the budget reduction and the default 'cost control method' is configured in the parameters?

I assume that this is not ok.

Another thing to think about:

Why do you need forecasts? Can't you use the new project budget form for recording budget amounts?

Its better and easier to handle in my opinion and you can avoid some of the problems related to the forecast reduction.

Best regards,

Ludwig

Was this reply helpful? Yes No
DynamicsAXExplorer 431 on at

Like (0)

Report

Yes I have default cost control method defined in parameters. Not sure where to check the Budget Reduction.

I saw that only forecast will be able to provide details about expenses, items, fees actual vs estimates. I saw that budget cannot provide actual vs estimates of expense, item, fee transactions estimates vs budgets. isnt it true?

What is forecast reduction that you mentioned?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi DynamicsAXExplorer,

Can you help us here and share screenshots of the following:

1. The setup of your forecast models

2. The project parameter cost control tab

3. The project parameter forecast reduction tab.

Many thanks,

Ludwig

Was this reply helpful? Yes No
DynamicsAXExplorer 431 on at

Like (0)

Report

Is that true that i asked in my previous comment?

I just created basic setups to test forecasting. and below are the images. please help me in setting up correctly if i did wrong so i can get forecasting properly. Thanks.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

From your screenprints, I can see that you use 'budget control'.

At the same time I cannot see a forecast model that is linked to the budget type 'remaining budget' and 'original budget' that you actually need for budget control.

Here are some screenprints how this looks in my environment.

Where did you actually enter the budget/forecast amounts?

Did you enter them in the forecast forms or in the project budget form?

Best regards,

Ludwig

Was this reply helpful? Yes No
DynamicsAXExplorer 431 on at

Like (0)

Report

Hi,

Like i said i didn't use any. I didnt use budget control. I am just trying to enable setting to see how they works and how they provide the required information.

And the screenprint you added is not opening. i am not able to see that.

1. Can you send it again with different format maybe?

When i tested before, i entered the forecast information on the Forecast forms( item, expense etc).. I havent used any budget forms yet.

2. Do you know if i use budget instead of forecast , will it be able to provide how much i forecasted for expense, item etc and how much is difference of final and estimated?

3. If i am going to use forecast, from above settings i have sent - is there anythings that i need to add or change in setups so forecasting will work correctly?

Ludwig Reinhard

Was this reply helpful? Yes No