Dynamics Community Forum Thread Details

Rate Table Changes on Project Billing Settings

Assigned a labor rate table to a Project under Billing Settings, the existing time entries were not updated to reflect the Rate table. Is there a way to apply the change of the rate table to all the non-billed entries?

Categories:

Microsoft Dynamics GP

Hello,

Labor Rates are calculated at the time the Timesheet is entered, so making a change on the labor rate table, would be a going forward change for new entries, and would not apply to existing entries in the system regardless of their billing status. You can use the "Select Timesheets for Adjustments" tool under Project > Transactions in GP to select the timesheets for your specific project and update the posted Timesheets with the new rate.

community.dynamics.com/.../what-do-the-reverse-and-correct-buttons-do-in-the-select-timesheets-for-adjustment-window-for-project-accounting-in-microsoft-dynamics-gp

You would use Method 2: Correcting from the blog above, and on step 4 you would use the 'Update' option which means you want to update the billing rate to be your current rate for example. So, you could select all of the options with the update radio button for your Project. Then save it to a batch and you will see a new batch with a negative timesheet entry backing out the original, and a new timesheet with a positive updated amount with the new rate.

You could try this in test with 1 timesheet to get the hang of it first and review the results.

Otherwise, the other option would be to you could manually adjust the billings this time around and the changes to the labor rate would pick up going forward on new transactions.

I hope this helps!

Isaac Olson

Microsoft Support

Quick Links