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