December 23, 2003
2. Reports: New values and filters in utilization reports; display charge/timebill total and difference in project billing transactions detail report; option to show predecessors on project task detail report.
We are introducing several reporting enhancements this month. First, there are three new values in utilization reports: “Percent booked utilization with actuals", "Percent booking availability with actuals", and “Percent assigned utilization with actuals”. These values allow resource managers to look at bookings/task assignments and availability, both past and projected, in a single report. The booked utilization value calculates the percentage of a user's work schedule time or base work schedule time that has been booked to projects. The booking availability value represents the percentage of a resource’s unbooked time. The assigned utilization value is based on project task assignments rather than bookings; it calculates the percentage of a user’s time that has been assigned to tasks in the Projects module. In calculating the numerator for these new values, as documented in the tips at the bottom of the report configuration and results screens, time entry data from timesheets is used for periods occurring before the current date, whereas booking/assignment data is used for periods including or after the current date. The denominator in all cases is schedule hours, with the option to choose either work schedule hours or base work schedule hours. The reports offering these values are in Reports > Advanced > Resources > Percent booked utilization with actuals | Percent booking availability with actuals | Percent assigned utilization with actuals, and Reports > Summary > Account-wide > Users.
Second, booking availability reports now support filtering by customer, project, booking type and project pricing approval status. This permits managers to see resource availability based on only hard bookings or on projects that have a particular approval status, for example. Availability is defined as 100 minus booked utilization. The numerator of the booked utilization value is calculated as bookings that pass whatever filters may be applied. The denominator is schedule hours (either work schedule hours or base work schedule hours). To view these reports, administrators and users with the requisite privilege navigate to Reports > Advanced > Resources > Percent booking availability | Percent booking availability with actuals, or Reports > Summary > Account-wide > Users.
Third, the booking availability reports referred to above can now be configured to respect the filter set of the user running the report, if desired. Currently, unlike most reports, the booking availability reports include data for all clients, projects, users and other entities, even if the user’s filter set would normally not give him/her access to this data. To turn on the option to conform booking availability reports to other reports, administrators navigate to My Account > Company > Settings > Resources options. Check the box “Respect filter sets when generating availability reports” and Save.
A fourth enhancement is in the project billing transactions detail report, which now permits you to display the charge/timebill total and the difference between the charge/timebill and the project billing transaction, if any. This is useful, for example, if a manager has edited the charges/timebills created from the project billing transactions. It gives managers the ability to compare the raw monetary totals generated by the project billing rules with the actual amounts as modified (either marked up or down in the Invoices module) for billing. To run this report, administrators and users with the requisite privileges go to Reports > Detail > Projects > Project billing transactions. Configure the report as desired, including the fields Total, Charge/timebill total and Charge/timebill difference. Name, save and run the report.
Finally, task predecessors are now available as a field to display in the project task detail report. This provides a convenient way to find out which projects and tasks across the entire account may need to be edited to include predecessor tasks, so that workflow proceeds as desired. Administrators and those with the requisite reporting privileges can access this data by going to Reports > Detail > Projects > Tasks. Configure the report as desired, being sure to include in the layout the Predecessors field. Name, save and run the report.
3. Timesheets: Hide notes on printable timesheet report.
This month, we’ve added a new option to the timesheet report layout to let you suppress the time entry notes on the printable timesheet report. This provides convenient flexibility if you use the time entry notes fields for company-internal comments, but need to print out the timesheet report to give to a client for review. The new option lets you hide the notes on the printed version for the client, while leaving the notes field accessible in the screen view of the timesheet report, for both users and timesheet approvers. To turn on this feature, administrators and users with requisite role privilege navigate to Timesheets > Options > Timesheet report layout. Check the box “Hide the time entry notes on the printable view” and save.
4. Invoices: Show user in Change Charges/timebills form; time type and payroll type from timesheet associated with charges/timebills.
In the Invoices module this month, we have added a few new features. First, when modifying an invoice using the Change Charges/timebills link, the user associated with each charge/timebill is now displayed, making it easier to determine which charge/timebill you want to edit or remove. To enable this feature, administrators and those with requisite privilege navigate to Invoices > Options > Invoice options. Check the box to "Show the user name on the 'Change TimeBills' view" and Save. To access the feature, select an invoice and click the Change Charges/timebills link.
Second, time type and payroll type from timesheet entries are now associated with charges/timebills. When timesheet entries are made billable (whether manually, by auto-billing or by the operation of project billing rules), the charge/timebill that is created will include the payroll type and the time type, if any, from the timesheet entry. The time type can be displayed on the invoice; both time type and payroll type can be displayed in the charges/timebills list view, and are available for filtering in the advanced filter above the charges/timebills list. Both time type and payroll type are also available as fields in the Charges/timebills detail report and as detail fields in Charge/timebill summary reports.
5. Would you like to see previous OpenAir product updates?
Click here to browse previous product updates including all new features, modules and functionality.
6. Suggestions, problems or questions?
As always, please contact us at firstname.lastname@example.org or 888.367.1288 (outside the U.S. and Canada, call +1.617.351.0226). We pride ourselves on the outstanding care we give our customers. Please let us know how we can improve your experience with OpenAir.