OpenAir Enhancements

January 17 2009

Overview

Reports
Constants as operands in custom calculations
Use constant custom detail fields as operands in custom calculations for transactions.

Subtotal by phase in summary reports
Subtotal project metrics by project phase in summary reports.

Date range fields
Use flexible date ranges in custom detail fields within summary and detail reports.

Custom period start or end dates on summary reports
Establish a relative start or end date for custom time ranges on summary reports.

Invoice approval status filter in reports
Use invoice approval status as a filter on summary and detail reports. In addition, sub-total by approval status in summary reports.

Additional subtotals in summary reports
View project billing transactions and revenue recognition transactions subtotals in summary reports.

Details ...

Account
Add hierarchies to filter sets
Use a project hierarchy to provide access to a specific group of projects.

Details ...

Timesheets
Line item rejection in timesheets
Reject individual time entries within a timesheet.

Send notes from timer to timesheet
Enter notes in the timer pop-up window and send them to the timesheet.

Details ...

Expenses
Adjust the order of fields on expense grid
Use the customize link in the expense grid to adjust the order of fields.

Details ...

Invoices
Set form permissions on Invoice options
Set form permissions on the Invoice options form to modify access to specific fields.

Details ...

Projects
Associate a user with a manually created revenue recognition transaction
Select a specific user on a recognition transaction form.

Details ...



Details

Reports
Constants as operands in custom calculations
Another key function has been added to the custom calculation feature to help manage business operations and build meaningful reports. Now, create constant custom detail fields and use them in summary reports. In addition, use them as operands in custom calculations. Enter a value and select a resulting field type such as hours, days, quantity, or ratio. In this release, this functionality applies to transactions but not entities. For example, transactions include charges, project billing transactions, and time entries. Entities include projects, customers, and tasks. This feature also includes an additional selection to apply the constant to each transaction when calculating selected values in summary reports.

How to set up a constant and use it as an operand in a custom calculation:

  1. Navigate to Global Settings > Custom calculations > Custom detail fields and create a custom detail field. For example, select New > Project billing transaction custom detail field. Note: It must be a transaction custom detail field.
  2. Select "Constant" from the Function drop-down list and type a title for the custom detail field.
  3. Type the "Constant" and select the "Resulting field type." For example, type a number that will be used to perform an operation in a custom calculation.
  4. If desired, select the check box to "Apply constant to each [transaction] transaction when calculating selected values in summary reports." Click Save.
  5. To use in a custom calculation, click "Custom Calculations" and create a custom calculation. For example, select New > Projects Project custom calculation.
  6. Select the "Left operand," the "Right operand," and Operation. Either or both operands may be a constant custom detail field.
  7. Type the "Title" and a "Description," select the check box to indicate it is an "Active custom calculation," and click Save.
  8. Navigate to Reports > Summary and select a report. For example, select a Projects > Project report. The constant custom detail fields and the custom calculation that uses them as operands are "Available values" listed under Options.
Subtotal by phase in summary reports
Users now have the ability to subtotal summary reports by phase. This new functionality provides added insight into project performance totaled across multiple tasks. This feature will apply to report values that can currently be subtotaled by task. If subtotaling by phase and a task is not a part of a phase, the phase designation will be displayed as "No phase assigned".

How to create subtotals for phases in summary reports:
  1. Navigate to Reports > Summary and select a summary report. For example, select Projects.
  2. Select desired "Options." Select "Phase" as one of the subtotal options.
  3. Select any necessary fields in the "Filters and detail fields" section.
  4. Click Run the report.
Date range fields
New date range fields are available for use as dates in custom detail fields. They include: yesterday, today, tomorrow, start and end date of each date range, such as last week start or last week end and this week start or this week end.

To enable date range detailing, users with required role privileges navigate to Administration > Global Settings > Reports Format and select the check box to "Enable date range detailing."

How to use date range fields:
  1. To use the new date option in a custom detail field, navigate to Administration > Global Settings > Custom calculations > Custom detail fields and create a custom detail field. For example, select New > Project custom detail field. New custom detail field form displays.
  2. Select "Date_Diff" from the Function drop-down list and type a title for the custom detail field.
  3. Select a value for "Date 1" and "Date 2" and click Save. The selections in the drop-down list for "Date" include the new date range fields (i.e., Today).
  4. To use date ranges in summary reports, navigate to Reports > Summary and select a report. The selections in the drop-down list for "Date" include the new date range fields.
Custom period start and end dates on summary reports
Frequently companies have a need for reports that use custom time periods such as 4:4:5-week months and 13-week quarters. Previously, those dates have been entered and changed manually. Now there is the option to use relative start or end dates for these custom time ranges. This allows the summary report to begin or end exactly on the custom time period specified, thus eliminating the need to manually modify the start or end date for the custom period.

How to create a custom time range:
  1. Users with required role privileges navigate to Administration > Global Settings> Custom time ranges. Select New > Custom time range.
  2. Enter name for "Custom time range name" and enter the appropriate time ranges. Click Save.
How to use relative start and end dates for custom time ranges:
  1. Users with required role privileges navigate to Reports > Summary > and select a report.
  2. Under "Period", select your custom time range and enter the number of periods under "# of periods".
  3. Under Date, select either "This [custom time range]", "Next [custom time range], or "Last [custom time range]".
  4. Select the option that applies: "This is the Start date" or "This is the End date."
  5. Enter the other information and click Run the report.
Invoice approval status filter in reports
Many companies find it useful to run reports that list approved invoices so that it is easy to see the amounts invoiced to customers at specified intervals such as month-end and quarter-end. Now, users can run both summary reports and detail reports that are filtered by or have a sub-totaled field for different invoice approval statuses. The invoice approval status filter and sub-totaling capability apply to account-wide summary reports and invoice detail reports.

How to use the invoice approval status filter in reports:
  1. In Summary reports, users with required role privileges navigate to Reports > Summary and select a report.
  2. Scroll down to "Filters and detail fields."
  3. Locate "Invoice approval status" under "Filters" and click "Create." An Approval status pop-up window displays Available Items.
  4. Select the appropriate approval status, click "Add selected items" and click OK.
  5. To create subtotals in summary reports, navigate to Reports > Summary and select one of the available reports.
  6. Select a "Sub-total" for "Invoice approval status".
  7. Click Run the report.
Additional subtotals in summary reports
Summary reports have been enhanced to show subtotals for project billing transactions and revenue recognition transactions. Previously, these could only be reviewed in detail reports. The report values that can be subtotaled by project billing transaction include project billing and project billing expenses, fees, days, hours, and transaction count. Report values that can be subtotaled by recognition transaction include recognized revenue, recognized revenue from expense item charges, and recognition transaction count. Note: the value subtotaled from recognized revenue from expense item charges only covers expense transactions created as a result of an "As Billed" rule.

How to create subtotals in project summary reports:
  1. Navigate to Reports > Projects and select one of the reports available under projects.
  2. Select a "Sub-total" for "Project billing transaction" and/or "Recognition transaction."
  3. Scroll down to "Filters and detail fields" click and create detail fields for "Project billing transaction" and/or "Recognition transaction."
  4. Click Run the report.
Up
Account
Add hierarchies to filter sets
Create a project hierarchy that allows middle managers, regional managers, and top management to access project and user information relevant to their job responsibilities and territories. With the increasing need for managing projects on a global scale, OpenAir is responding with a simple yet effective way of filtering information so that those who need to see it can easily view it. Create or edit a filter set with the desired access.

Once enabled, complete the following steps to use this feature. First, create a project hierarchy and select check box to "Use to determine filter set access for projects." Next, on the Edit project form, specify the node to which the project belongs. Then, on the user demographic form, specify the user access area by selecting the appropriate node or level the user should have access to. Finally, select from the new options that display on the filter set access control forms for Project access and User access. They are:
  • Project access area: [Access to Projects in my hierarchy project node]
  • User access area: [Access to project owners in my hierarchy node], [Access to Users assigned to my hierarchy node], [Access to Users booked to my hierarchy node]
To enable project list view filtering by hierarchy, please send an email request to support@openair.com.

How to define a project hierarchy in filter sets:
  1. To select which project hierarchy to use, users with required role privileges navigate to Administration > Global Settings and select "Hierarchies." Select New > Hierarchy. Or, edit an existing project hierarchy.
  2. Select the check box ""Use to determine filter set access for projects." Click Save.
  3. To select which node or level a user has access to in the specified project hierarchy, navigate to Administration > Global Settings > Users > [select a user]. In the user demographic form, under the "Project level access", select the appropriate node or level the user should have access to. Click Save.
  4. To configure a specific filter set, navigate to Administration > Global Settings > Filter sets > [select a filter set].
  5. Click the Access Control link. Select "Project access" and select "Access to Projects in my hierarchy project node". Click Save.
  6. Under the Access Control link, select "User access." Select the desired options that now include: "Access to project owners in my hierarchy node," "Access to users assigned to my hierarchy node", and "Access to users booked to my hierarchy node." Click Save.
Up
Timesheets
Line item rejection in timesheets
Use line item rejection in timesheets to streamline operations. Instead of delaying the invoice process because of an error in one time entry, reject the entry in question and continue to process the timesheet and invoice the already approved entries. This allows users and managers to save time for approvers while viewing individual entries. To enable line item rejection in timesheets, please send an email request to support@openair.com.

How to reject a line item in a timesheet:
  1. Navigate to Timesheets > Timesheets > Submitted and select a timesheet. Timesheet report displays and a "reject" link displays next to the date on each line item.
  2. Click the "reject" link. The "Reject time entry" pop-up window displays. Type notes about the reason the line item is rejected. The rejection notice and reason is sent to the user in an email message.
  3. Click Save. A message displays that time entry was rejected and moved to a new "Rejected" timesheet. The submitted timesheet minus the rejected line item can be approved by the approver.
  4. To view and correct the rejected time entries, click the "Rejected" link and select the rejected timesheet.
  5. Click the "Enter time" link. The user can make changes and submit the corrected timesheet for approval.
Note: If timesheet rules are configured, administrators can choose to have the rule ignored upon the resubmission of rejected time entries. To enable this option, navigate to Administration > Application Settings > Timesheets Settings > Timesheet rules. Check the option "Ignore rules on submission of timesheets with individually rejected time entries" and save. Users will not see warnings or errors for timesheet rules if submitting a timesheet that contains rejected time entries.

Send notes from timer to timesheet
The timer pop-up window allows users to start a clock against a task, close the window, and work in other areas of OpenAir while accumulating time against the task. Notes can be added to each task using the edit link, and when the time is transferred to the timesheet, the notes are also transferred. The bubble icon on the timesheet changes to reflect that notes are present.

The timer function must be enabled to use the feature to transfer notes. To enable the timer, please send an email request to support@openair.com.

To enable the option to send timer notes to the timesheet, please send an email request to support@openair.com.

How to send notes from the timer to the timesheet:
  1. To enable the timer feature for a user, users with required role privileges navigate to Administration > Global Settings > Users and select a User. On the "Edit user demographic information" form, select the "Enable timer feature" option.
  2. Users navigate to Timesheets > Timesheets and create or open a timesheet for today.
  3. To start a timer, click the clock that displays next to today's date. A "Start a timer" pop-up window displays with timesheet information. Click "Start" to begin accumulating time.
  4. To start a timer, click the clock that displays next to today's date. A "Start a timer" pop-up window displays with timesheet information. Click "Start" to begin accumulating time.
  5. To add notes, click "Edit." An "Edit Timer" form displays with an area for Notes. Enter note information and click Save.
  6. To transfer notes to the timesheet, click the clock on the timesheet. A pop-up window displays a list view of timers. Click the link to "Send all to timesheet..." The timesheet refreshes and displays transferred information including an indication notes are present.
  7. Click Save to save the transferred timer information and notes.
Note: To enable the timer functionality for multiple users at once, use the Bulk user change wizard available from Dashboard > Overview > Wizards to copy the "Enable timer feature" from one user to other users and/or departments.
Up
Expenses
Adjust the order of fields on expense grid
The Expense grid offers a quick and easy way of entering multiple receipts of various types in a single form. Now, the expense grid fields can be put in the order that's most efficient to use. A customize link on the bottom of the form launches a pop-up window with selections. While fields can be moved and the order changed to meet user needs, they cannot be removed.

How to adjust the order of fields on the expense grid:
  1. Navigate to Expenses > Envelopes and select an envelope.
  2. Click on the "Expense Grid" link. The Grid displays
  3. Click the "customize" link on the bottom of the form. A "Grid layout" pop-up window displays.
  4. Click on an item under "Selected Items" and use the up and down arrows to move it.
  5. Click OK. The order of the Expense grid fields displays the changes made.
Up
Invoices
Set form permissions on Invoice options
The ability to set form permissions has been added to the Invoice options form. As with other forms in OpenAir, users with required role privileges can modify form permissions to be required, read-only, or they can elect to have a field hidden all together. This allows each company the ability to restrict access to invoice options fields based on roles. For example, administrators can restrict users from changing the "Starting invoice #" field by making it read-only.

How to set form permissions on the Invoice options form:
  1. Users with required role privileges navigate to Administration > Application Settings > Invoices Settings and select Invoice options.
  2. Scroll down to Hints and click "Modify the form permissions."
  3. Make selections by role for the fields on the form: REQ = required, RO = Read-only, R-HIDE = required but hidden field, R-RO = Required but read only field, and HIDE = hidden field.
Up
Projects
Associate a user with a manually created revenue recognition transaction
Users now have the ability to specify the user who is responsible for generating the revenue when creating a manual revenue recognition transaction. A drop-down list of users has been added to the "New recognition transaction" form.

Users with required role privileges navigate to Projects and select a project. Click the "Financials" link and select "Recognition." At the end of the Financials: Recognition line, select "New > Recognition transaction." The New recognition transaction form displays. Complete form information and select a user from the drop-down list. Click Save.
Up
Would you like to see previous OpenAir updates?
View previous OpenAir updates ...

Suggestions, problems, or questions?
Contact us at support@openair.com or 888.367.1288 (outside the U.S. and Canada, call 617-351-0226). We take pride in the outstanding care we give our customers. Please let us know how can we improve your experience with OpenAir.