NetSuite OpenAir Tips
Removing the Generated Date-Timestamp From Downloaded Reports
Blog | Reporting and Dashboards
|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
Blog | Booking and Billing
|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
Blog | Time and Expenses
|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
Blog | Booking and Billing
|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
Blog | Administration
|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
Blog | PS Best Practices
|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
Blog | Reporting and Dashboards
|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
Blog | Utilization
|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
Blog | Administration
|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
Blog | Time and Expenses
|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 ...