Skip to main content
Answer

Employee Hours and Billed Amount

  • April 11, 2025
  • 2 replies
  • 67 views

In project accounting, is there a report that shows employee hours and the corresponding billed amount by project? On our billing rule, we are generating a billing detail for each time detail. Ie. no aggregating.

On the AR invoice, we see individual details corresponding to each time activity; however, it does not contain the employee ID/information. Does anyone have a way of showing the hours and amounts information on one report?

Best answer by Adelina Basyrova

Hi ​@repepi6362 ,

This request (employee hours versus billed amounts) might be addressed via joining the following tables:

  • time activity (PMTimeActivity)
  • project transactions (PMTran)
  • AR invoice lines (ARTran).

If you need more assistance on how to do so, kindly report a how-to support case.

Thank you!

cc ​@nhatnghetinh 

2 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • April 11, 2025

Hi ​@jchan86 

I see an "Employee Hours" report is available on Acumatica. However, you need to edit this report to have the additional information you want.

 

 

 

 

 

Best Regards,

NNT


Adelina Basyrova
Acumatica Moderator
Forum|alt.badge.img+1
  • Acumatica Moderator
  • Answer
  • April 18, 2025

Hi ​@repepi6362 ,

This request (employee hours versus billed amounts) might be addressed via joining the following tables:

  • time activity (PMTimeActivity)
  • project transactions (PMTran)
  • AR invoice lines (ARTran).

If you need more assistance on how to do so, kindly report a how-to support case.

Thank you!

cc ​@nhatnghetinh