OpenAir Enhancements

November 22 2008

Overview

Account-wide
User Interface
OpenAir has made significant enhancements to the User Interface. To learn more, or to leverage these new enhancements, please contact OpenAir Support.

Customize and download links moved
Look for a customize list layout and download link in the upper left corner of the top menu bar. Place the cursor on the down arrow and select "Customize list view" or "Download list data."

Dynamically expand and collapse sections in forms and lists
Tailor the display of forms and hierarchy lists to meet your needs. Use an arrow icon to expand and collapse sections on forms and in hierarchy lists.

Details ...

Account
Calculated fields
Create a custom detail field and use it for summary and detail reports as well as email templates. Rename built-in detail fields and use a project custom field as an operand in calculated fields.

Create ratio custom field
Create a ratio custom field and use it in custom calculations.

Active Directory integration
Authenticate OpenAir User ID and password using an Active Directory.

Details ...

Expenses
Print all expense report and receipt attachments
Download and print all individual expense report and receipt attachments. Two new links can be added to the expense report form.

Set form default values on receipts
Set form default values when creating receipts.

Set default payment type and status for receipts
Set a default payment type and associated default payment status for receipts.

Details ...

Projects
Change project stage in bulk
Use the bulk action feature to quickly change the project stage of multiple projects at once.

New date range for charge projections
Use either a relative or absolute date range to generate charge projections.

Filter expense item billing rule by task
Create an expense item billing rule and limit its use to specific tasks.

Details ...

Reports
Report on primary, secondary, and tertiary loaded costs
Set up Users Detail and Summary reports to show all three loaded costs in both single-currency and multi-currency accounts. Current and historical costs can be displayed.

Details ...

Timesheets
Mark time entries as paid
Reconcile time entries against payment invoices.

Display current leave accrual balance for schedule requests
When a schedule request is submitted, the current leave accrual balance displays on the "Approval request" form.

Details ...

Workspaces
Account storage limit alert
Set up an alert and receive an email notification when storage approaches the specified percentage of allocation.

Details ...



Details

Account-wide
User Interface
With this release, OpenAir has made significant enhancements to the User Interface. First, all administrative functionality has been consolidated within the application into Global Settings and Application Settings. Second, OpenAir has enhanced the navigational components of the application to reduce clicks and simplify overall workflow.

Administration
Enhancements benefit administrative users by streamlining navigation in the application and improving speed. A new Administration link is available in the main drop-down menu. Administration contains two tabs, Global Settings and Application Settings.

  • Global Settings contains all administrative functionality that impacts the application as a whole. For example, hierarchies, display options, filter sets, and roles.
  • Application Settings contains the specific administrative functionality for each application. For example, Timesheet Settings contain alerts and timesheet rules, whereas Projects Settings contain projects stages and charge projection settings among other options.
Navigation
Improvements include the consolidation of sub-links into drop-down menus and revised terminology options. These improvements enable users to more quickly navigate within the application and access the information they are looking for in a more streamlined manner. To enable the new user interface, please send an email request to support@openair.com.

Customize and Download links moved
To improve usability, access to the customize list layout window and download list data options have been moved from the bottom of list views and reports to the top menu bar on the left. Place the cursor on the arrow to display drop-down list options. To customize list layout or download data:
  • Select "Customize list view" and a pop-up List layout window displays. Click or control click items and select "Add selected items" or "Remove selected items." Click OK.
  • Select "Download list data" and download options display for Microsoft Excel, Microsoft Word, and Adobe Acrobat. Click the "Click here" link to display the file or download options. Click "Back" to return to the list view.
Dynamically expand and collapse sections in forms and lists
An arrow icon has been added to section headers on forms. It allows contents of the section to be expanded and collapsed. When the arrow icon points down, all items in the section display. When the arrow icon points to the right, the contents of that section are hidden. This feature can be enabled for sections in forms as well as on hierarchy lists. Users can alter the display to focus on areas they are working on, or open a number of sections to see how different factors work together.

How to expand and collapse sections in forms and lists:
  1. Users with required role privileges navigate to Account> Company > Settings and under "Display Options" select the check boxes to "Enable collapsible sections on forms" and "Enable dynamically collapsible sections in hierarchy lists."
  2. On forms, click on the arrow icon next to the section header to toggle between expand and collapse functionality. For example, on the "Edit project" form, companies may list a number of notifications. Click on the arrow next to "Notifications" to expand or collapse the list.
  3. On hierarchy lists, click on the arrow next to the section title. It changes from the "show all" position to the "hide all" position and expands and collapses the list. For example, on the "Outline view" for a project, click on the arrow next to a phase and the list of tasks expands or collapses.
Up
Account
Calculated fields
A number of enhancements have been made to Calculated fields. First, companies can rename both built-in detail and summary fields to something more meaningful to their operation. Next, they can create custom detail fields that display along with the built-in detail fields for an entity. These custom detail fields can be used in summary and detail reports as well as email templates. Third, companies can now use a project custom field as an operand in calculated fields.

Various calculations can be used in custom detail fields based on data type. The following are specific calculations that are available.
  • DATE_DIFF: Select two dates to be subtracted resulting in days. This only relates to date fields.
  • SUM: Select any number of values to be added. All must be the same data type.
  • AVERAGE: Select any number of values to be averaged. All must be the same data type.
  • DIFFERENCE: Select any number of values to be subtracted. All must be the same data type.
  • CONCATENATION: Combine static text with detail fields and use them anywhere built-in detail fields can be used. The process of combining the static text and detail fields follows the "email template" metaphor already available in the application.
How to rename built-in summary and detail fields:
  1. Users with required role privileges navigate to Account> Company > Calculated fields > "Renamed Built-in detail fields" or "Renamed Built-in summary fields." Select Create > and choose one of the built-in fields.
  2. Select the "Built-in title" using the drop-down list.
  3. Type a new "Customized title." HTML break tags control how the title displays on reports.
  4. Click Save.
How to create a custom detail field to use in reporting:
  1. Users with required role privileges navigate to Account> Company > Calculated fields > Custom detail fields > Create > and choose a custom detail field for an entity that has detail fields. For example, select a "Project custom detail field" and the field is associated with "Project."
  2. Select the "Function." Functions include: "DATE_DIFF," "SUM," "AVERAGE," "DIFFERENCE," or "CONCATENATION." For example, "DATE_DIFF" subtracts two dates.
  3. Type the custom detail field "Title." For example, "Project offset days."
  4. Select "Date 1" and "Date 2." For example, "Scheduled project start date" and "First time entry date."
  5. Click "Save." The custom detail field is available where other detailing is available. For example, on "Projects - Task summary report options," the new custom detail field "Project offset days" can be selected in "Project > Detail fields."


Create ratio custom field
Use a ratio custom field to create specific metrics tailored to company business needs. The ratio custom field can be used in custom calculations for various types of built-in summary and detail values. For example, "Projects - All assigned hours" and "Timesheets - All hours" can help define projected hours and can ultimately be used to determine productivity. Run a task summary report and select the custom calculations as "Available values" to determine billing amounts, projected utilization, and projected booked and assigned hours.

How to create a ratio custom field to use in reporting:
  1. Users with required role privileges navigate to Accounts> Company > Custom fields and create a Ratio Field.
  2. Type the Field name. For example: "Task_Percentage."
  3. Check the Active check box, type a description, associate it with "Task" using the drop-down Association list, type the display name and a hint, select its display Position if there are multiple custom fields, and click Save.
  4. Navigate to Accounts > Company > Custom calculations and use the custom filed to create a custom calculation. For example: Create a "Projects Task custom calculation" that has "Task detail ~ Task Percentage" times "Projects - All assigned hours" as the operands and "Earned hours" as the title. Select check box: "Active custom calculation."
  5. Navigate to Projects and select Create > Project. Enter new project information and Save.
  6. Create > Tasks and enter task and assignment information. Type an amount in the "Task Percentage" field that display on the "New task" form and Save.
  7. Enter timesheet information for assigned resources.
  8. Navigate to Reports > Summary > Account-wide > Tasks. The custom calculations display as "Available values" under "Options." Filter as appropriate and Run the report.


Active Directory integration
Companies that are using an Active Directory (AD) server can now validate OpenAir User IDs and passwords against that AD database. With the proper firewall configuration, the AD server can connect to OpenAir. There is also an option to use SSL to encrypt the connection. To enable Active Directory integration, please send an email request to support@openair.com.

How to set up an AD integration within OpenAir:
  1. Users with required role privileges navigate to Account > Company > Custom fields > Create > Checkbox Field. Note: The custom field must be a Checkbox Field.
  2. Type the Field name: "active_directory_auth" Note: This must be the Field name.
  3. Check the "Active" check box, type a description, associate it with "User" using the drop-down Association list, and type the display name and a hint. Click Save.
  4. Users with required role privileges navigate to Account > Account > Users and select a User ID.
  5. Scroll down and select the check box created for Active Directory authentication.
  6. Users with required role privileges navigate to Account > Exchange > Active Directory.
  7. Type the IP address or DNS name.
  8. Select the check box to "Encrypt the connection using SSL (LDAPS)" and click Save.
  9. Click "Test" in hints. A pop-up window displays the "Active Directory test for the IP address or DNS name."
  10. Type the OpenAir User ID and Password and click Test Log in.
Up
Expenses
Print all expense report and receipt attachments
This feature allows users to download all attachments to an envelope and all receipts attached to an expense report. View each individual attachment or download a zipped file containing all of them. Select multiple files for viewing or printing. Previously, users had to go into each receipt, download the attachment, such as a scanned receipt, and then print the receipt. Attachments can be added to an envelope on the edit form or to a receipt. When an envelope and/or receipts have attachments, links display on the top of the expense report form. Users click on that link to display a window listing expense report attachments or receipt attachments. A "Download all attachments" link creates a zipped file. To enable downloading a group of attachments from expense reports, please send an email request to support@openair.com. In addition, to display the links for downloading on the expense report form, edit the Expense Report Layout.

How to download and print expense report receipts:
  1. Users with required role privileges navigate to Expenses > Options> Expense Report Layout. Select the check boxes for "Show link to exp report attachments" and "Show link to exp report receipt attachments." Click Save.
  2. Navigate to Expenses > Exp reports > Create > Exp report. After saving, the "New receipt" form displays. Enter receipt information, add an attachment to a new receipt, and save.
  3. To add an attachment to the envelope, click the "Edit" link. The "Properties" form displays. Scroll to the bottom of the form and add attachments.
  4. To access all attached receipts, click the "Expense Report" link. For envelope receipts, click the "View Exp report Attachments" link. For receipt attachments, click the "View Receipt Attachments" link. A pop-up window displays.
  5. On the pop-up window, click the "Download all attachments" link. A dialog box allows selecting the location and file name. The zipped file is downloaded and saved on your local system. The default name is the name of the expense report appended with the word "attachments" or "receipts."
  6. To view or print multiple files at once, unzip the file, open the folder, select the files, and select either open or print.


Set form default values on receipts
Save time and effort and ensure consistency on receipts by having forms already filled out with commonly-used values. Simply define frequently-used information and use the "Set Form Values" link in hints to take the guess work out of creating new receipts. Default values can be set for a defined role such as "user" or "administrator" or they can apply to "all" roles.

How to set form default values on receipts:
  1. Navigate to Expenses > Exp reports and "Create > Exp report" or select one that has already been created.
  2. Create > Receipt. The "New receipt" form displays.
  3. Scroll to hints and click the link to "Set form default values." The "Set default form values" window displays.
  4. Select the role these default values apply to using the "Switch to role:" drop-down list.
  5. Enter the default information and click Save. The form you are working on refreshes and displays the default information on the new project form.
Note: Form permissions are respected when configuring default values. For example, if a default value for a particular field is set for a user role, but that field is designated as Read-only via form permissions, that field remains Read-only when a user with that role creates a new receipt.

Set default payment type and status for receipts
Companies can set a default payment type and assign a payment status that displays automatically when users create new receipts. For example, a "Company Card" payment type can be the default, and since it is paid, the default status is "non-reimbursable." In addition, companies can associate default status with all payment types. A personal credit card and cash can default to "reimbursable." Navigate to Account > Account > Expenses > Payment types. Create or edit a payment type. To designate it as the default payment type, select the check box for "Default payment type." To associate the payment type with a default status, select a status using the drop-down list. When new receipts are created, the default payment type and status display. If all payment types are associated with a status, default status automatically displays when a user selects a payment type.
Up
Projects
Change project stage in bulk
Select multiple projects and quickly change the project stage at once using the "Run" bulk action feature. This timesaving capability, currently offered in other modules, has been added to Projects. Users can now select a number of projects that are complete, for instance, and change the project stage on each to complete without having to go into each project. Proposed projects related to a statement of work can all be moved to an in progress stage at once when the statement of work is approved.

How to change Project stage in bulk:
  1. Navigate to Projects > Projects and display the list view.
  2. Select the check boxes of the projects to make a project stage change to.
  3. Click the "Run" icon. A pop-up "Actions" window displays. The number of projects selected is indicated as well as a variety of possible actions.
  4. Select the option to "Change the project stage of the selected projects to:" and choose a stage using the drop-down list.
  5. Click OK. The stage of all projects is changed.


New date range for charge projections
Increased flexibility exists for generating project charge projections. A toggle function has been created to allow users to enter specific start and end dates or a relative date range such as tomorrow and the next 30 days.

Navigate to Projects > Options > Charge projections and scroll to "Date range." The default display includes specific start and end dates. To change the display, click "relative." Entry fields for "Start" and "Duration" display. Select either "Today" or "Tomorrow" and enter the exact number of days in "Duration."

Filter expense item billing rule by task
Create an expense item billing rule that is specific to one or more tasks. In addition to limiting the billing rule use to users and expense types, a filter has been created to allow for selecting precise tasks it applies to.

Navigate to Projects > Billing and select or create an "Expense item billing rule." Scroll down to "Billing rule filters" and click "Task." A pop-up window displays task selections for the project. All tasks are specified by default. To remove tasks, click on them and select "Remove selected items."
Up
Reports
Report on primary, secondary, and tertiary loaded costs
Monitoring the values entered in primary, secondary, and tertiary loaded costs has become easy. Choose either the Detail report for Users or the Summary report for Users and configure the report to include the desired values. Include both current and historical costs. In single currency accounts, the values of these costs are totaled. In multi-currency accounts with mixed currency, the values are displayed respectively in the currency in which they were entered, according to their selection sequence. To enable three levels of loaded costs, please send an email request to support@openair.com.

How to set up a Detail report for Users:
  1. Navigate to Reports > Detail > Account-wide > Users.
  2. Select the Date range.
  3. Under "Options" for "Report layout," click "Create." Users detail report layout displays.
  4. Scroll down to "Loaded cost" options and highlight selections for primary, secondary, and tertiary loaded cost for (Current), a specific currency, and (Historical).
  5. Click "Add selected items" and OK.
  6. Click Run the report.
How to set up a Summary report for Users:
  1. Navigate to Reports > Summary >Account-wide > Users.
  2. Select the Date range.
  3. Under "Filters and detail fields" for "Resource" and "Detail fields," click "Create" or "Edit." User layout displays.
  4. Scroll down to "Loaded cost" options and highlight selections for primary, secondary, and tertiary loaded cost for (Current), a specific currency, and (Historical).
  5. Click "Add selected items" and OK.
  6. Click Run the report.
Up
Timesheets
Mark time entries as paid
Subcontractors frequently log time for work done in OpenAir and subsequently send an invoice to the company for payment. Create custom fields for a time entries list and use the run action to mark the timesheet hours of subcontractors as paid. Associate the time entries with the invoice number to ensure accurate recordkeeping and reporting. Sort the list of time entries by subcontractor name and filter it using a number of date ranges such as last week, this month, or by quarters or years. To enable custom fields for marking time entries, please send an email request to support@openair.com.

How set up custom fields for marking time entries:
  1. Users with required role privileges navigate to Account > Company > Custom Fields > Create > Dropdown Field. Note: The custom field must be a Dropdown Field.
  2. Type the Field name: "oa_time_entry_reconciled" Note: This must be the Field name.
  3. Check the "Active" check box, type a description, associate it with "Time entry" using the drop-down Association list, and type the display name and a hint.
  4. Type Value list entries. For example, Yes, No, and Rejected. Remember each value goes on its own line.
  5. Select the check box to "Hide on data entry forms" and Save. It will not display on timesheets.
  6. Next, navigate to Account > Company > Custom Fields > Create > Text Field. The custom field must be a Text Field.
  7. Type the Field name: "oa_time_entry_reconciled_notes" Note: This must be the Field name.
  8. Check the "Active" check box, type a description, associate it with "Time entry" using the drop-down Association list, type the display name and a hint, type Field size, select the check box to "Hide on data entry forms" and Save. It will not display on timesheets.
How to mark time entries as paid:
  1. If the user who will mark time entries is not an administrator, set role permissions. Navigate to Account > Roles and select the user's role. Select the check box for "View the time entry tab" and Save.
  2. To mark time entries, users with required role privileges navigate to Timesheets and select the "Time entries" tab. A list of approved Timesheets the user has access to displays.
  3. Use the filters for Date and User to limit the size of the list.
  4. Select the check boxes by the time entries to mark and click the "Run" icon. An Actions pop-up window displays with the custom fields.
  5. Select the value from the drop-down list and type the invoice number. Click OK. The invoice number is associated with the time entries.


Display current leave accrual balance
When users submit a Schedule request for time off, the amount of accrued time a user has available displays on the "Approval request" form. This helps managers quickly review and decide upon the request. Users create a Schedule request and submit it for approval. Managers select the Schedule request and click "Submit/Approve." "Current leave accrual balance" and the number of hours the user has accrued displays on the top of the "Approval request" form.

To enable the display of current leave accrual balance, users with required role privileges navigate to Account > Company > Settings and under "Timesheets Options" select the check box: "On schedule requests, display current leave accrual balance to managers for approval." Once enabled, a current leave accrual balance displays on the "Approval request" form.
Up
Workspaces
Account storage limit alert
Companies that upload attachments can monitor usage and establish an email notification to alert an appropriate user when storage exceeds a specified threshold % amount. When approaching the storage limit, companies can either delete documents or contact support@openair.com to request additional storage.

Users with required role privileges navigate to Workspaces > Alerts > Create > Account storage alert. Type an "Alert name" and establish when the alert will run. Set the % capacity and enter the to and from email addresses, email subject, and text. Select the "Active alert" check box and 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.