i am having to build one that basically grades our planner. Needs to be Actual vs Planned with a running time frame of 60 days. So it will always be the last 60 days. Thought Booked Hours is where it would have to come from
Planned Hours will generally come from R5ACTIVITIES. However, if you schedule labor and want to compare against that, you can pull from R5ACTSCHEDULES.
We don't have a KPI, but we do have a report and yes it uses r5bookedhours.
i am having to build one that basically grades our planner. Needs to be Actual vs Planned with a running time frame of 60 days. So it will always be the last 60 days. Thought Booked Hours is where it would have to come from
Dale,
Actual Hours comes from R5BOOKEDHOURS.
Planned Hours will generally come from R5ACTIVITIES. However, if you schedule labor and want to compare against that, you can pull from R5ACTSCHEDULES.
thanks Becca. That is what I was thinking as well