Skip to main content
Answer

Using of Rate Table

  • June 12, 2025
  • 3 replies
  • 78 views

Forum|alt.badge.img

Hi, 

Good morning. I am still not certain of how and why we need to use the rate table.   We are using the Acumatica Payroll and the Construction module.   My question is Do I need to create a Rate Table if we want all the actual labor will be charged to the project based on the employee time entry?   

 

Thank you and appreciate your help. 

 

Best answer by NickyOliver98

Hello,

This is dependent on what option you have selected in Payroll Preferences for Time Posting. If you select post PM and GL Transactions from Payroll Only, then you do not need to fill out the rate table and it will use the employee rate from Employee Payroll Settings. The rate table is used if you select one of the other two options of posting to PM from Time Activities. It will look at the rate table to get a rate to post to the project in the interim before payroll is processed. Once payroll is processed it will reverse the entry and use actuals. 

 

3 replies

NickyOliver98
Acumatica Employee
  • Acumatica Employee
  • Answer
  • June 12, 2025

Hello,

This is dependent on what option you have selected in Payroll Preferences for Time Posting. If you select post PM and GL Transactions from Payroll Only, then you do not need to fill out the rate table and it will use the employee rate from Employee Payroll Settings. The rate table is used if you select one of the other two options of posting to PM from Time Activities. It will look at the rate table to get a rate to post to the project in the interim before payroll is processed. Once payroll is processed it will reverse the entry and use actuals. 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • June 12, 2025

@NickyOliver98  Thank you so much for your reply.  Yes that is what we set in our Payroll, the post PM and GL Transactions from Payroll Only.  

Another question is do we need to set up Billing rules if our process is we manually enter the amount in the pro forma invoice. 

 

Thank you and I appreciate your help.

 


Forum|alt.badge.img+1
  • Semi-Pro I
  • June 12, 2025

You will want to use the “Labor Rate” table in order to be able to record costs to the job from the Time Entry.  (There is also a “Rate Table”, but it is typically used with true T&M billing rules.)