Hi Dynamics Community,
Has anyone ever come across a requirement to facilitate billing clients based on a "daily rate" (fixed rate), independent of the number of hours entered in timesheets (i.e. actual time spent). This is now for time & material projects.
My client is looking to automate this process whereby employees enter time and AX generates the daily rate billing amount irrespective of hours captured. It gets a little more complicated as any hours worked over the standard working hours per day (i.e. 8 hours) needs to be handled as normal time & material hours (i.e. charged per hour).
Using a simple example, an employee has the following:
A daily rate = $1500 p/day
An hourly rate = $100 p/hour.
The employee completes their timesheet and enters 10 hours on a specific day (they do not distinguish between "normal" or overtime hours).
AX should calculate the billings for that day to be:
$1700 (1500 + (2 X 100))
So, in essence it's almost like a hybrid T&M and Fixed Price project. I'm currently working on a solution to use the T&M fee functionality to generate the day rates, but it's turning out to be quite complex with the splitting of hours and allocating the correct rate per category.
I'm not aware of anything available in standard AX 2012 R3, so I'm reaching out to the community for any suggestions, ISV's or if someone has designed something like this before?
Thanks!
Arno
