Archive for timesheets

‘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

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

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

In this recorded webinar you will learn more about:

  • Advanced features such as time entries tab and timesheet customization
  • Support tax reporting by region/location
  • Workflow processes and time approvals
  • Adjusting timesheets
  • Best practices for tracking overtime and shift work

….and more!

For those of you who use time types to track billable/non-billable work or overtime/shift work, ever run into the problem of a consultant selecting the wrong value for task or project (especially those internal or administrative tasks)? OpenAir has two control switches that may be of interest – but you can only use one or the other

  • Allow time types to be limited by task
  • Allow time types to be limited by project

When one or the other of these options is enabled, a new field will appear on the task or project.

By selecting Create, you can select which time types apply to that task or project.

Click OK and save the form you are working on (Task form or Project Properties form).

Definitely make sure to set these values on those internal or administrative projects!

And just like that, you’ve improved the accuracy of your timesheets.

This feature may only be enabled by contacting OpenAir Support.

Categories : weekly tips

It’s tax time and for many of us in the services world, we are working on computing how much services revenue was delivered in each of the US states to complete state tax obligations.   Unfortunately it’s this time of year when you realize that information tracking in your OpenAir system may be a bit limited in this area.  Be better prepared for next year by adding work location delivery to your timesheet grid.  The Timesheet grid supports the display of many fields such as time type, services, and payroll type.  You may already be using time type and services but often I see payroll type as a reusable field for just this objective.

To setup work location on your timesheet grid:

  1. Create payroll types (Administration -> Application Settings -> Timesheet settings -> Payroll types) for each US state.  A good naming convention is State Abbreviation-US and you can even add other countries to the list.
  2. Enable Show payroll type on time entries (Administration -> Application Settings -> Timesheet settings ->Other settings)
  3. Enable Require payroll type on time entries
  4. Rename Payroll Type to Work Location (Administration -> Global Settings -> Terminology)

Don’t forget to writeup an email and communicate to end-users!!  Changes to timesheets are one of the biggest end-user impacts in OpenAir.

Now you are all set to writeup reports of time by work location and align that with revenue recognized in OpenAir (or invoicing, if you are not using revenue functionality).

Categories : weekly tips

OpenAir ETC/EAC on Timesheets

Wednesday, April 6th, 2011

NOTE: This tip is related to estimated and remaining hours which requires the feature ‘Enable “Hours Remaining” on tasks estimating feature’ to be enabled.

Project Management methodologies rely on the ability to manage budget burn and expectations of budget burn. OpenAir can aid in this by providing the ability for users to submit an estimate of hours remaining on tasks. Until recently, this data entry was a bit cumbersome as it required users to click on an additional link to enter the values. Requiring the values to be entered was a way to enforce the process, but usability was always a challenge. What has changed? You can configure your timesheets to display the hours estimated and hours remaining directly in columns on the timesheet grid.

To activate this feature, submit a ticket to OpenAir Support and request the ‘Display hours remaining on the timesheet grid’ to be enabled. Once enabled, you will need to log out and back in to view the feature activation:

Old view: Clicking on the Hours Remaining link above the timesheet grid to view and modify hours remaining.

New view: Display of hours remaining and estimate hours directly on timesheet grid. No link available:

If you are allowed to save 0’s on your timesheet, you can enter zero and save for the system estimate hours to appear. Once you start to enter time on the task, the system estimate hours will adjust accordingly. At the end of the timesheet period, have your consultants enter what additional or less hours they need to complete the task before they submit the timesheet.

You can make entry of the Hours Remaining field required by enabling ‘Require “Hours remaining” estimates for all tasks’. If the system estimate hours are correct, the consultants would just re-enter the value in the Hours Remaining field.

Categories : weekly tips

There is a quicker way to look up time entries on OpenAir timesheets – know how?

A feature in the Timesheet module allows you to look up individual time entries across multiple users, timesheets, customer, projects, and more. It’s call the Time Entry tab. When enabled, a new tab appears in the Timesheets module for Administrators. Other resources can be granted access to the time entry tab via role permissions.

So what’s the benefit? Ever want to look up what week or day a resource entered time on task X? Ever wish you could quick just find out who worked on a specific client’s projects last month? Now it’s just a click and a column filter away – no more detailed time entry reports!

As an added bonus, the page filter function is also available so you can customize data lookups quickly.
How to enable the feature:

  1. Submit a support request to OpenAir Support asking to ‘Enable time entry tab’
  2. Modify all roles that should have access by enabling the ‘view time entry tab’ option on the Role form (Administration –> Global Settings –> Roles).
  3. Customize your view as you like in the new tab and start getting dangerous with page and column filters!
  4. NOTE: Data view permissions are applied to the time entry tab so any users you can see in the Timesheets tab, you will be able to see in the Time Entries tab.

Categories : weekly tips
Tags :