Hi André,
Thanks lot for the advice, I will give a try on Monday and update accordingly as I have no access to co AX at the moment.
Meanwhile, can help to take a look at this issue,
the original issue that brings me to create current thread
For your reference:
community.dynamics.com/.../192960
I have created project A with budget say USD100,000 for budget type project hour and approved the budget. I am using timesheet to record and post employee B weekly registered working hours for this project A.
The rate for the employee per hour is USD20, I am using Effective Labour Rate, our company standard working hours is 42.5 per week. Now, let's say the employee registered working hours for the week is 55 hours, when I post the timesheet, on AX the timesheet itself show that the ELR per hour is = (42.50*20) / 55 =USD15.45 per hour and it posted all the lines on the timesheet.
But when I go to the Project, on the action tab "Plan" - project budget - project budget balances,
The approved budget for budget type Hour shown is USD100,000, the consumed budget shown is USD656.65 (42.50*USD15.45=656.625 rounded to 656.65).
My question: is there anyway to capture the utilized hour instead of standard hours per week as consumed budget? I want the consumed budget to capture 55*15.45=USD849.75 instead of 656.65. Can anybody help? Thanks
Fyi
on my timesheet line, it posted all lines total working hour on timesheet with ELR rate, e.g for Monday is 12 hours, for tuesday is 12 hours, wed is 10hours, thu is 11 hours, friday is 10 hours. Lets use above rate $15.45, on posted timesheet, if I open up the posted timesheet, I go to "hours transaction related information" button, I can see that each line is posted in double entry on its subjournal with following calculation
Mon 12*15.45
Tue 12*15.45
Wed 10*15.45
Thu 11*15.45
Fri 10*15.45
which is 849.75 If I add up the total sum posted to both ledgers accounts
but I don't get it why its only 656.65 is reflected on consumed budget
