I'm working with a customer who is new to T&E and will soon be using SL's Payroll. In setting up their T&E, they discussed using a rate table with average rates of employees for their Project costs (reports, etc. they want to see the average rate, not the employee's rate). The FUPE method will pick up what's in the Rate Table first, and that is what is flowing over to payroll. While this is working great for the reports portion, the average rate that is being picked up is not the employee's true rate that they will be paid when it gets to payroll.
We thought about omitting the rate table on the T&E side and using the employee's true labor rate. This would be great for payroll, however when the customer runs reports they won't be seeing the average rate as they would like. Eventually, they plan to use Flexible Billings and Allocator. I am currently unclear if they will be billing the average rate or the true rate, however I know that if they wished to bill the average it's easy enough to plug in the Rate Table ID and Allocation Method to bill the average cost.
Is there a way in Project T&E where hours could be the employee's true labor cost, but status reports etc are in Standard Cost? The Help files have given wonderful information, but do not appear to address this specific scenario.
The question isn’t real clear, but by ‘status report’ I assume you are referring to the labor cost. So to use an example, assume the employee’s pay rate is 25.00 per hour (assuming an hourly employee) and the ‘standard labor rate’ is 40.00 per hour. It sounds like you want to send 25.00 per hour to payroll, but report labor cost as 40.00 per hour. The only way I see to do that is using allocator to mark the labor up to the standard rate.
Let me know if we have correctly understood the issue.
Technical Support Engineer
**This posting is provided "AS IS" with no warranties and confers no rights.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics