Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Project / Estimate / Some hours not included in the total are missing

Posted on by 115

Hello everybody,

I hope you are well.

I just came back from holidays two days ago, and some users make me discorver that we have suddenly  a problem of cost calculation in the project estimate.

What is surprising me is that approximatively 10 subsidiaries are using AX 2012 R3 (same database, same environment). We have the problem for only 2 subsidiaries.

We made an update of our production environment (SSRS reports only) on July 16th.

Process for us is such :DEV ==> UAT ==> PROD.

We have also a training environment (updated with refresh from prod on August 16th ).

we had also refreshed UAT from prod on July 15th, just before our delivery.

today the model store is the same on both environment.

When we create an estimate for some projects on prod for some subsidiaries (2), hours are missing (Hour Journal or Timesheet). I mean cost calculation does not include those hours (they avant an amount :-) )

When we create an estimate for some project (same as above) on UAT for some subsidiaries (2), hours are NOT missing (Hour Journal or Timesheet). I mean cost calculation  includes those hours (they avant an amount :-) )

When we create an estimate for some project (same as above) on TRAININGfor some subsidiaries (2), hours aremissing (Hour Journal or Timesheet). I mean cost calculation does not include those hours (they avant an amount :-) )

So in my mind, something was updated on prod (for those subsidiaries), but I can't find what.

Do you see something evident for you ? 

Hope I was clear and thanks in advance if you can help.

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at
    RE: Project / Estimate / Some hours not included in the total are missing

    Hi Ludwig,

    after 4 days of research and debugging, we found what happened.

    I let the answer below in case of it happens for other users.

    In fact, we think that an error occured in one company during the execution of function Create Estimates. unfortunatelly this function was not launched in batch mode, so I can't proove it.

    But in fact what we found is that Estimate Date was not filled despite of the line cost status, line item status and line hour status was Etimated (tables projempltranscost , PROJITEMTRANSCOST, PROJITEMTRANSCOST ).

    As far as I could have identified the concerned data, I have updated WIPPERIOD column, and now it is ok.

    Thanks for helping.

    Christophe

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at
    RE: Project / Estimate / Some hours not included in the total are missing

    Hello Ludwig,

    thanks for your question, but I don't know where to find this information. Is that possible that you give me some more informations please ?

    Best regards,

    Christophe

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Project / Estimate / Some hours not included in the total are missing

    Hello Christophe,

    Has somebody possibly modified or changed the cost lines included in the costing sheet?

    Best regards,

    Ludwig

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at
    RE: Project / Estimate / Some hours not included in the total are missing

    Hi Ludwig,

    hopefully we only have one cost template.

    2021_2D00_08_2D00_17-14_5F00_52_5F00_48.png

    And I've checked that the setup in the same in both environment.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Project / Estimate / Some hours not included in the total are missing

    Hi,

    Can you check the cost template that is linked to your project?

    Please open the revenue recognition tab and check the cost template used.

    Once you have that information check that the cost template includes all categories.

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans