Project Time Detail Report

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

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.

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:

Save changes to this shared report - the current shared report will be saved with the new table settings
Save a new shared report - the current shared report will be unchanged and the new table settings will be saved to a new shared report created with the name supplied in the Save As box
Save a new saved report - the current shared report will be unchanged and the new table settings will be saved to a new report created with the name supplied in the Save As box and available only to the current user

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

Example Report Output

The table can be manipulated in the following ways:

Click on the show/hide icon - - or right-click on the column header row to show or hide non-frozen columns (i.e., columns that always display when scrolling). Then click on either the show or hide icon( or ), whichever is applicable.

Hover cursor over vertical line between column header names until you see the resize icon - . Then click to drag right or left in order to resize the column.
Use mouse scroll button or scrollbar on the right of screen to scroll vertically up and down on the table.
Click on a non-frozen column heading to drag and drop on the column heading row to move or re-order the columns.
Click on the save table view icon - - to save your table settings, such as resized or hidden columns. Click on the reset table view icon - - to reset the table back to default settings.
Click on the print friendly icon - - in the top right corner of the page to display a print friendly version of the page with no headers and icons. Click on the back to Unanet link - - when finished printing.

Note: When the cell text is wider than the cell, you will see an ellipses indicated by 3 periods (...). To see the rest of the text, you can either hover the cursor over the text or expand the column.

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.