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?