Archive for OpenAir

The use of time billing rules on project is fairly common among OpenAir users to convert time spent on a project into billable money amounts for invoicing. The use of rule caps to limit money or hours allowed to be processed by the rule is also a popular feature, but rule caps comes with configuration settings that are often not completely understood.

One of those settings is ‘Adjust time entries to fit under the cap’. The behavior of this setting is to allow the rule to process time entries that will aid in meeting the cap limits as closely as possible. An example helps illustrate this more clearly.

Example:

  • The cap is set to 40 hours
  • A user on the project enters the following timesheet: Mon-8, Tues-10, Wed-8, Thurs-10, Fri-8 for a total of 44 hours
  • If the Adjust Time Entries setting is ‘unchecked’ then the time billing rule processes the Mon-8, Tues-10, Wed-8, Thurs-10 for a total of 36 hours. The Fri-8 hours cannot be processed since there are only 4 hours of allowed billable time left. The time billing rule will not process any time entries unless they are 4 or less hours to use up the remaining cap.
  • If the Adjust Time Entries setting is ‘checked’ then the time billing rule processes the Mon-8, Tues-10, Wed-8, Thurs-10 for a total of 36 hours. The Fri-8 hours are split into 2 4-hour entries so 1 4-hour entry can be processed by the rule, and the other 4 hours are either passed onto the next time billing rule or not processed (depending on other configuration settings on the rule). This allows the full cap value to be realized without dependency on the size of the time entry being processed.

So it’s easy to see why the setting is defaulted as checked. Timesheets remain unchanged which supports utilization reporting and margin reporting separate from what is allowed to be invoiced.

Categories : weekly tips

Customizing Your OpenAir Email Content

Thursday, December 15th, 2011

There are plenty of notification and alert options in OpenAir with most having either standard wording (timesheet awaiting approval, for example) or the ability to setup specific email body content (late timesheet alert, for example). For many the standard wording or text entry capabilities are sufficient to communicate basic information but you may be finding a need to increase the content or make the emails a more effective communication methods by passing along key information for recipients. OpenAir supports content change primarily through the feature known as email templates. If you haven’t looked at these before, they provide a customization method to build out the structure for many of the standard notifications. A great example is customizing a booking notification email to have not only the project information, but any custom fields you’ve added to the booking and perhaps even requester information.

Here’s how – access the Administration -> Global Settings -> Email Templates link (or Account -> Company -> Email Templates).
Select New…Booking email template.

The Booking email template form will appear.
The Template type dropdown will identify the type of email you are creating (new booking(user notification), as an example). Give the template a name then complete the Email subject and Email body. In the Email body, you can insert OpenAir fields that OpenAIr will substitute with values. To insert these fields, you select the field from the ‘field’ dropdown below the email body and the text to insert will appear in the blank text field just below the dropdown. Copy this text value and insert it into the email body, including any %% characters so OpenAir knows it is a field that needs to be populated.

There are a lot of email templates options so feel free to explore. NOTE: in order for an email template to be used, the feature which generates the notification must be activated (new booking notification to users is a setting in the Resources module settings).

Categories : weekly tips

‘Tis the season for people to schedule vacation, if they haven’t already, and focus on their leave balances as they try to use up vacation or make sure they have enough vacation to cover this last month of the calendar year. If you are using the Leave Accrual feature within OpenAir, users have access to their leave balances from their Home page -> User status area or by accessing the Leave Accrual Transactions tab, if they have permission. When a manager or a schedule request approver receives a request for time off, the reviewer may need to look up balances by running reports or accessing the Leave Accrual transactions before approving – or just approve and hope the request was within the allotment of time off for that user.

There is a way, however, to display the current leave balance on the request itself to save time in information lookup for the reviewer. To enable this option, navigate to Administration -> Application Settings -> Timesheet settings -> Other Settings (or Account -> Company -> Settings) and check ‘On schedule requests, display current leave accrual balance to managers for approval’.

When the approver accesses the schedule request, they will not have to look up balance or rely on timesheet rules to ensure a resource is not asking for more leave time than they are allotted.
NOTE: the approver needs to click on the submit/approve link to see the balance, which is the hours remaining BEFORE the request is approved. The View schedule request with approve/skip/reject buttons will not display the balance.

The balance view is also helpful for reviewers to see how much more time a user may have available in case, as with many companies, a person’s vacation expires at the end of the year. Managers can begin to plan holiday coverage as resources are usually encouraged to take their vacation before it expires.

Categories : weekly tips

Work Schedule Reporting with Holidays

Wednesday, November 23rd, 2011

As you work with reports, you may have noticed some fields that seems to mean the same thing but have slightly different names.  One of these fields is called Work Schedule.  In Summary reports, you see values called Work Schedule and Base Work schedule.  So what is the difference?    Base Work Schedule means the hours setup on your company calendar (work schedule) defining a workday and also the days of the week that make up a work week.  For the US, this is typically 8 hours per day for a Monday thru Friday schedule.  For the UK, this is typically 7.5 hours per day for a Monday thru Friday schedule.  For Israel, this may be 8 hours per day for a Sunday through Thursday schedule.   The screen shot below is from the company defined calendar found under Administration -> Global Settings -> Work Schedules (or Account -> Company -> Calendars).

In these company calendars, however, you can define company or bank holidays which are days off for your employees.  These are identified in the exceptions area of the calendar where you give the holiday a name, a start and end date, and the number of hours in that workday  (usually 0 but sometimes the holiday is only a ½ day).  You may also set a time type to indicate Holiday – this will appear on the Resource Booking Chart if you use the Color Coded by Time Type chart view.   To get a report of working hours in a week considering the holiday schedule, you use the Work Schedule.  This removes any exception either in the calendar OR in the user’s schedule link if you’ve setup your Schedule Request functionality to enter schedule exceptions on calendars instead of creating bookings.

Many companies use Work Schedule as a basis for utilization and available working hours.  Base Work Schedule, however, is very helpful to understand realization from a payroll defined work week (since holidays are paid time for the employee).  If you create a custom calculation using Base Work Schedule minus Work Schedule, you can also get the number of holiday hours a person has received (and potentially vacation if you have schedule exception created for approved schedule requests)!

Correcting Approved Timesheets

Wednesday, November 9th, 2011

Ever find yourself needing to make a correction to an approved timesheet but part of the timesheet has already been approved? There is a way by leveraging a feature called Adjust timesheets. People with the proper permissions, controlled by the role level, may create an adjustment timesheet to correct timesheet entries direct from the approved timesheet. No proxying required! Here is how it works, users with permission navigate to the approved Timesheet and open the timesheet by clicking on the name.

This displays the timesheet report. To perform the adjustment, you must click on the Timesheet or grid option to view the time entry grid.


A message will be displaying at the bottom of the timesheet stating ‘an approved timesheet cannot be modified’. Scroll down beyond this into the tips area of the page. A new feature option will appear called ‘Adjust this timesheet’.

Click on Adjust and a screen refresh will show the original timesheet with a Save option.

Make the change to how the timesheet should look then click Save. An adjustment window will appear showing you how time entries will be computed and allow the entry of notes to explain why the timesheet adjustment was performed.

Select ‘Create the adjusting timesheet’ and a new Adjustment timesheet will appear in the user’s list of timesheets. The term [adjusted] will appear as part of the new timesheet name.

NOTE: if you have billing or revenue that may be impacted by the timesheet adjustment, you will need to rerun those rules to pick up the changes.
To activate this feature, contact NetSuite OpenAir Support.

Categories : weekly tips

Individual Project Forecasting Refresh

Wednesday, November 2nd, 2011

If you are doing forecasting in OpenAir, you are most likely using charge projections and setting them to run or recalculate each night. Your System Administrator can also run charge projections ad-hoc which will recalculate forecast for all projects. There is a way to refresh or recalculate forecasts for individual projects that is quick and convenient for your project managers to use. Its controlled by a switch called ‘Allow charge projections to be run for individual projects’. When enabled, a new function will appear in the tips area of the Properties or Edit Project form of the project.

Clicking on the word ‘Generate’ will pop-up a window displaying when the last time the global forecast was recalculated and the last time an individual project was recalculated (not your project most likely, the last project to be individually recalculated in the system in general).

Clicking on Generate will start the reforecast calculation which, since it is only calculating for a single project, usually takes seconds. Access to this feature is controlled by Role and does require that you grant permission to individuals to run billing.

To activate the feature, contact OpenAIr Support to enable the switch.

Categories : weekly tips

Unapproving Timesheets

Wednesday, October 26th, 2011

The timesheet review/approval workflow process within OpenAir allows a timesheet to track status of open, submitted, approved, etc. There are occasions where you find yourself needing to unapprove the timesheet to make corrections. The unapprove permission for timesheets as well as other objects that support review/approval in OpenAir is actually controlled on the User account itself. It’s not a role level permission. To grant permission to individuals for unapproval, go to the user’s account under Administration -> Global Settings -> User or Account -> Account -> User. When you select their userid, you will be dropped into the demographic page . Scroll down the form to the timesheet options area and you will see a checkbox to ‘allow user to un-approved timesheets’. Check and Save!


Now users can go to specific timesheets, click on submit/approve, and click to unapproved. The only exception to this is when a timesheet has already been processed for billing – then alternate correction methods are required since you don’t want to get timesheets and billing out of sync! Billed timesheet prevent the user from unapproving.

Categories : weekly tips

Ever wish you had a copy of the automated OpenAir emails sent from you?

Your OpenAir system has most likely been configured with various alerts, notifications, and automated email messages that are triggered based on certain events or lack of events in the system.  Many of those notifications may be coming from you via OpenAir!  You may find people replying to those emails to provide explanations, ask for more information, or simply to send you an ‘ok’ reply back.  Ever wonder how you can get a copy of those emails in your own inbox for reference?  Under the Personal Settings options there is an ability to BCC yourself on all emails.  This will provide a copy of the email from OpenAir to yourself whenever your account is triggering the email.  This is very helpful for items such as resource bookings or client invoices.

To activate this option, navigate to your personal settings (Account -> My Options -> Personal Settings or Home -> Personal Settings or Dashboard -> Personal Settings, depending on your UI) and scroll to the bottom of the page to find the checkbox for ‘Bcc me on all emails’.

You can turn this option off and on as much as you like!   The Bcc applies to all emails you sent and there currently is no filtering option on which emails to receive a Bcc.  This is when inbox rules for your email system will be useful!

Categories : weekly tips

Advanced Filtering Outside of Reports

Wednesday, October 5th, 2011

You may be aware of the page filter capabilities within OpenAir to quickly filter information for more efficient data views. The standard page filtering feature has basic ‘is, is not, contains’, etc. functionality. There is a more advanced version of this filter that contains more filtering operations such as ‘is any of’, ‘is not any of’, etc. It also can be set to display the full filter set for easy editing or hide the information to look more like the standard page filter feature.

Below is an example of how the advanced filter looks:

This feature is available as a personal setting. Each user can optionally set it by going to Home (or Dashboard) -> Personal Settings or Account -> My Options -> Personal Settings depending on your UI version.

Categories : weekly tips

As a project manager, you find yourself in the Projects Module a lot within OpenAir taking care of project planning, budget tracking and overall team management. Part of project management, however, often pertains to resource scheduling through either managing resource availability or requesting resources to fill out your project team. When these activities are required, many Project Managers navigate to the Resources module and lose their project view simply because they are now in a resource-centric module. Moving between the modules can be streamlined though! The Booking tab of the Resource module can also be added to the Projects module as another functionality tab. This allows Project Managers to stay within the Project module but be able to use all the same functionality of the Resource module by simply access a different tab.

When activated, the Booking tab will appear to the immediate left of the Projects tab in the Projects module. When you access the Booking tab, the same feature/functionality such as list, grid, and chart views are available. Once the tab has been selected, Project Managers are now able to create bookings per normal business process without moving to the Resources module. At the completion of resource management activities, the Project Manager can simply click back on the Projects tab (or other project module related tabs) to resume their Project Management activities.

To activate the booking tab within the resources module, contact OpenAir support and ask to show the resource booking tab under the project module

Bookings Tab in Projects Module