Scenario
Customer runs Time & Billables Reports and it shows Zero Value in Rate Column for Non-Billable Time Entries.
• Navigate to Transactions > Employees > Track Time
• Enter Time Entry for employee with:
• Price Level and Rate filled up
• Billable = False
• Save
• Navigate to Reports > Time and Billables
• Customize any Time By report
• Click Rate under the Edit Columns tab > Time Tracked folder
• Hit Preview
Actual Results:
• Rate column in Time & Billables Reports has zero value for Non-Billable Time Entries
• Rate column is showing zero amount for Non-Billable Time Entries in the report
Solution
It is by design that the Time and Billable Reports will display zero for the Rate field if the time is Not Billable.
To display a value on Rate column, you can create a Create a Time Saved Search with Rate column exposed:1. Navigate to Lists > Search > Saved Searches > New > Time
2. Mark Show Totals = True under the Results tab
3. Add Rate field under the Columns sub tab
4. Add Customer field in Available Filters tab and mark the following as True:
a. Show in Footer Region
b. Show as Multi-Select
5. Rename the search
6. Hit Preview or Save and Run the search
7. Choose the customer name (s) in the Customer field.