Reports - Project - Time Details

Overview

This report provides a detailed view of time charged to a project or project organization.  

Clicking on the CSV icon at the top of the report criteria page will run the report using the specified criteria but will download the report to a .csv file instead of displaying the report.

 

Note: If your system has multi-entity accounting enabled (see Setup Multi-Entity), then the borrower will see intercompany labor in this report, if applicable. The intercompany cost rate will be used for those transactions. Also note that users with Intercompany Project Viewer role only will not see any results on this report where they are loaning labor across legal entities.

Note: The rounding method used in this report is determined by the Round Project Time Details Report using General Ledger method (round, then sum) (unanet.reporting.rounding.project_time_details) property. When enabled, the report will use the same rounding method as the General Ledger, where calculated amounts are first rounded prior to being summed in subtotals or totals. When disabled, the report will use the legacy method of rounding, where calculated amounts are first summed in subtotals or totals prior to rounding. Using this method, amounts may not tie to General Ledger postings or detail amounts displayed in the report may not sum to subtotals or totals in the report.

Roles

This report is available to users having any of the following roles:  Administrator, P&R Administrator, and the following Project Administrators: Project Manager, Project Viewer, Project Lead, Project Approver, Customer, or Resource Requestor.

License

This report is available with the Project Time, Project Tracking or Project Portfolio licenses.

 

Topics covered on this help page include:

 


Selection Criteria

 

Note: When you click the Save Criteria icon, your table settings, such as resized or hidden columns, will be saved with the criteria as well. If you change and save the default table settings again, the saved criteria will retain its table settings. Furthermore, if you change the table settings while viewing the saved criteria results page, only the saved criteria table settings will be updated.

Note: When an administrator (system, P&R, HR) clicks the Save Shared Criteria icon, the table settings, such as resized or hidden columns, will be saved with the criteria as well. If the administrator later changes and saves the default table settings, the shared saved criteria will retain its table settings. Furthermore, if the administrator changes the table settings while viewing the shared saved criteria results page, a pop-up will display with the following options (resetting the table will offer similar options). Administrator must select one and click the Save button:

Field Descriptions (click on a link below for additional information)

 



Example Report Output

This report includes time from timesheets and financial documents.

Note regarding report table features

To show or hide the Report Legend, click on the arrow next to "Report Legend"  at the top of the report.

Note: If there are multiple adjustments for Vendor, Vendor Invoice, Reference, PO, PO line, or Financial Posted Date for a specific date, then N/A will display for respective columns if Show Adjustment Details is not checked on the selection criteria and respective show column options are checked .

Note: If Show Adjustment Details is not checked, then Bill Rate, Cost Rate, and Additional Pay Rate will show the latest value if hours are not zero and there was a change in the rate. However, if hours are zero and the amount is not zero, then the rates will show N/A. If hours and amount are both zero, then no timesheet record will be shown.

Note: If the work date for a transaction is outside of the user's profile rates tab begin and end dates, then that transaction will not be included in the report.


CSV Output

On this report you will notice the CSV () icon, which can be used to produce the report output in this alternative format.

 

Related Topics