Skip to content

NetSuite OpenAir Tips

Removing the Generated Date-Timestamp From Downloaded Reports

Did you know you can remove the ‘Generated’ date-timestamp from downloaded reports? OpenAir reporting is capable of quite a bit of reporting but there are plenty of occasions where people just want to download information into Excel for pivot table ...

Two Controls for Booking Type Use

Did you know there are 2 controls for booking types use? Booking types are a way to identify categories of work scheduled for resources. Typical values include Committed/Hard, Tentative/Soft, Internal, Vacation, and so forth. Booking types are one of the ...

Using the Timesheet Required Checkbox on the User Demographic Form

Did you know how helpful the Timesheet Required checkbox is on the User Demographic form? On the User Demographic form in the Timesheet options area, there is a checkbox called ‘Timesheet Required’. This checkbox is useful in 2 major areas ...

Increasing Precision in Billing Rate Decimals

Do you know the trick to increasing precision in billing rate decimals? OpenAir’s time billing rule is very flexible to handle billing in hourly or daily rates. Daily rates, however, occasionally give us all a bit of a headache when ...

Limiting the Timeframe Someone Can Proxy

Did you know you can limit the timeframe someone can proxy? Proxy is a handy feature in OpenAir to allow administrators to log in as users for troubleshooting and for reviewers of timesheets, expenses, invoices, and so forth to setup ...

Attrition: A Customer Relationship Opportunity

TSIA - August 2012 Written by: Jodi Cicci, President and CEO, TOP Step Consulting LLC When an employee leaves for another job opportunity, it may be difficult to fill the hole, especially if he or she is responsible for managing ...

Removing Duplicate Charges From the Financial Analysis Project Report

Many customers have the need to invoice customers in a fixed fee manner or payment schedule, but also to do some analysis on the money value of time worked on the project. The setup usually followed is to add time ...

Removing Inactive Resources from Your Company Utilization Reports

Did you ever wonder how you can easily remove inactive resources from impacting your company utilization reports? Utilization reports present challenges sometimes if you have staff turnover. Staff that starts in the middle of the year should not influence historical ...

Allowing Task Creation Without Allowing Copying, Duplication, or Moving the Task

Did you know that you can allow task creation but not allow copying, duplication, or moving of the task? When you define your business roles and OpenAir user role permissions, many times you have conflicts in how you want people ...

Getting OpenAir to Figure Out the Decimal Hours For Your Time Entries

Did you know you can type a start/end time on time entries and have OpenAir figure out the decimal hours for your time entry? You may be used to entering hours and fractions of an hour when typing in time ...

About Us:  Our mission is to enable and empower Professional Services Organizations to become profitable, scalable, and efficient through change management, technology deployment, and skill set training with a Customer First approach.

Scroll To Top