Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Project Closing updates Forecast to match Actuals

Posted on by

In Project Accounting, it seems like when you run the Project Closing process for a project, it ends up updating all the Forecast values (Qty, Cost, etc.) to match the Actuals for all cost categories on the budget - why does it do this?  And is there any way to prevent this?

I noticed when you go into a Project and into the "Forecast" button, if you change the cost category status to Completed it prompts you to ask if you want to update the Forecast values to match Actuals - so you have the option to prevent it at this point.  But once you close the project, there is no prompt and it mass updates.

It's causing a huge issue because you lose all Budget vs. Actual reporting once a project is closed (unless you use the Baseline amounts, but that's not accurate if there were changes during the project).

*This post is locked for comments

  • Rahim J Profile Picture
    Rahim J on at
    RE: Project Closing updates Forecast to match Actuals

    Thanks for the reply.  There's no customization on the Project Closing (or anything related) so it seems to be standard functionality.  Just not sure what the logic would be to do this and how to avoid it.

  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,865 on at
    RE: Project Closing updates Forecast to match Actuals

    Revenue will be determined for the project type "Cost Plus" and "Fixed Price", with Accounting method Cost-to-Cost/Effort Expanded/EE- Labor Only, by comparing the  Actual Qty / Cost with the Forecast value depending upon the combination. To close a project, one of the Checklist item is All revenues must be recognized as well.

    But, I don't think( or at least I've never seen) what you are explaining is a standard functionality.   I'm guessing there might be a customization and you might want to look into that.

    If not, then I'm not sure, may be someone from the community might be able to help you out.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans