Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Project budget revision processing annoys

(0) ShareShare
ReportReport
Posted on by 1,642

Does anybody has any insights on how do budget revision get updated into the main project data?

I mean that as you setup a project budget revision using Project Budgeting (a la carte module), you can approve and process the revision and update the project main data. The behavior of this update process is supossed to be managed by the several "Revision Type" and "Update Type" fields.

One user is complaining that now the project main budget is like a randomly generated data with no clear link to the revision just entered.

I am checking the data now and found out that the result isn't quite random. 

The image above shows that B (the main budget as in PJPTDSUM.total_budget_amount) and the different R (the revision value as in pjrevcat.amount). The current budget shows the value of revision 3 minus the value of revision 4 plus the value of revision 28. This formula applied to all account/task combination.

The three revision value are pretty much alike for each account/task combination at least magnitude-wise, so the result stills may make sense. All revision has the "New Amounts" revision type. Time wise, first we approved revision 3, then revision 4 and then revision 28. In fact, the user original complain is to why he is not seing the revision 28 values. There are no approved revisions between 4 and 28.

So what could have happened?

*This post is locked for comments

  • Erich Strelow F Profile Picture
    Erich Strelow F 1,642 on at
    RE: Project budget revision processing annoys

    If anyone was following this, we finally isolated the problem to a scenario of a messed up budget period. For some reason, every budget has a period as in 2015-04. You should always go forward in time. If you ever post a budget for a previous period, the Net Change/New Values logic doesn't work as expected.

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans