Skip to content

SuiteProjects Pro (formerly OpenAir) Quick Tips

Access the SuiteProjects Pro Data Dictionary Instantly with the Shortcuts Feature

If you’ve worked in SuiteProjects Pro for any length of time, you’ve likely relied on the Data Dictionary. It’s packed with essential reference information that helps you configure, customize, and…
Read More

How to Adjust Historical Costs for More Accurate Project Profitability in SuiteProjects Pro

SuiteProjects Pro offers a solution to update users’ historical costs based on actual utilization via an Advanced Report, delivering more accurate profitability reporting. With this feature, you can run a…
Read More

Require Billable “Yes” or “No” Selection on Expense Receipts in SuiteProjects Pro

The out-of-the box configuration for SuiteProjects Pro includes a “Billable receipt” checkbox on the expense receipt form that allows users to flag an expense as billable (if checked) or nonbillable…
Read More

Latest Enhancements to the Project Resource Center in SuiteProjects Pro

Several usability improvements to the Resource Center in Suite Projects Pro have recently come out to help users filter, view, and edit resource data more efficiently. These updates are available…
Read More

Enabling Bulk Actions on Planner in SuiteProjects Pro

The SuiteProjects Pro Resource Booking Planner is a powerful tool that lets you create and modify resource bookings in a user-friendly and dynamic interface. One of the most useful features…
Read More

Adjust Timesheet Report PDF to Show all Data in NetSuite Projects Pro

When downloading a Timesheet Report, not all columns and data are displayed. The Timesheet Report Layout in NetSuite Projects Pro is customizable to fit a company’s needs. Users can select…
Read More

Control which Timesheet Periods are available to Users in SuiteProjects Pro

After a period is closed and you want to prevent users from creating timesheets for past dates, you can use the “Enabled timesheet open/closed periods” feature. This feature allows you…
Read More

How to Delete Charge Stages in SuiteProjects Pro

Deleting a Charge Stage is necessary when it is no longer required in your workflow. However, a Charge Stage cannot be deleted if it has existing associations with other records…
Read More

SuiteProjects Pro’s Customizable Next-Generation Homepage

SuiteProjects Pro introduces an enhanced homepage, available alongside the classic version, designed to elevate the user experience. This next-generation homepage offers a customizable interface that improves productivity and efficiency. Users…
Read More

How to Allow Contractors or Part Time Employees to Submit Timesheets With Only the Actual Work Performed

Most companies require their users to submit the exact or more hours based on users’ regular working hours. Since Timesheet rules are global and enforce all users to submit 100%…
Read More

Using Invoice Layout Terminology to Customize Invoices in SuiteProjects Pro

Invoice layouts are a great way to customize your invoices in SuiteProjects Pro. Layouts allow you to pick and choose from available column headers and subsequent values that some clients…
Read More

Can’t See the Non-Billable Checkbox on Your SuiteProjects Pro Task Form?

If the Non-billable task checkbox isn’t showing up in SuiteProjects Pro, here’s a quick check: Head to the Financials tab on your project. If you don’t see Billing listed there,…
Read More

Using Multi-Week Work Schedules in SuiteProjects Pro

Organizations often employ team members who work different hours each day or follow alternating weekly schedules. To accommodate these more complex patterns, SuiteProjectsPro offers multi-week work schedules, allowing you to…
Read More

How to Prevent Users from Submitting Time to Closed Tasks in SuiteProjects Pro

The Closed for timesheet checkbox in task assignments can be applied per resource to stop a specific user from adding new time to a task. However, this only takes effect…
Read More

Utilizing SuiteProjects Pro Baselines to Track Project Progress and Changes

The Baseline feature allows users to capture the current status of a project at any moment and save it as a Baseline. Users can then compare the current project status…
Read More

Introducing the All-New To-Do Widget in SuiteProjects Pro Mobile 5.3

The latest release of SuiteProjects Pro Mobile 5.3 introduces the new To-Do Widget, giving you instant visibility into your action items—right from your mobile app dashboard or your device’s home…
Read More

Improve System Performance by Skipping Recalculation of Projects

In some cases, system performance can be impacted by operations taking place behind-the-scenes in SuiteProjects Pro. One major feature, that is hidden to the average user, is the conversion of…
Read More

How to Report Target Utilization that is Date Driven in SuiteProjects Pro

Target Utilization is a feature in SuiteProjects Pro that you can enable to allow you to set a target utilization on a per User basis. By going to the User…
Read More

Run and Create Pending Recognition for All Projects in SuiteProjects Pro

Creating revenue recognition transactions at the project level offers a high degree of control; however, depending on the size of your organization, this option can become difficult to manage. Fortunately,…
Read More

NetSuite Connector – Using ‘Initial Only’ with an Advanced Mapping

In the NetSuite Connector, the ‘Initial only’ check box is located on the mapping definition table for integration workflows importing records from NetSuite into SuiteProjects Pro (Mapping tab). To enable…
Read More

Customizing Invoice Headers with Custom Fields in SuiteProjects Pro

SuiteProjects Pro invoice layouts come with a slew of customization options, but did you know that one of those options allows you to include your own organization- or department-specific custom…
Read More

Speed Up Time Entry with Time Card Templates in SuiteProjects Pro Mobile

SuiteProjects Pro Mobile makes it easy to record recurring time patterns using time card templates. These templates are prefilled time cards you can reuse when completing a timesheet. Using these…
Read More

Streamline Invoices with SuiteProjects Pro Custom Expense Groups

Group expense charges on invoices with the Custom Expense Item Groups feature setting in SuiteProjects Pro Invoice Layouts. This feature allows you to group expense charges with different expense items…
Read More

How to Use Permission Rules to Limit Values in Form Fields Using SuiteProjects Pro

SuiteProjects Pro provides many options and features to help you customize and manage your users’ experience with the tool. At times, it may be necessary to configure a form so…
Read More

Bulk User Change Wizard in SuiteProjects Pro

One of the key responsibilities of SuiteProjects Pro (SPP) administration is the creation and maintenance of user records. Whether making a one-off change, or pushing system-wide updates to users, this…
Read More

How to Bulk Update Auto-Billing Settings Across Multiple Projects in SuiteProjects Pro

Many organizations are transitioning from automatic billing transaction creation to manual approval processes, allowing finance teams to review charges before they’re generated. The manual approach provides better control over month-end…
Read More

SuiteProjects Pro: Project Discussions Feature – Enhancing Team Collaboration

As part of the April 2025 release, SuiteProjects Pro introduced the “Project Discussions” feature, an enhancement that provides a centralized, persistent communication hub for each project. This feature enhances team…
Read More

Find Unbilled Resources Fast with SuiteProject Pro’s Resource Visibility Setting

Planning resources but can’t see who’s actually available? You might be missing team members with zero bookings entirely! The “Include active resources without bookings” setting in Bookings – Planner solves…
Read More

Visual Impact: Enable HTML Colors and Icons in Custom Fields in SuiteProjects Pro

Want to make your custom fields more visually impactful? While SuiteProjects Pro custom fields don’t support HTML by default, there’s a simple way to enable rich formatting including color-coded icons…
Read More

Sync Your Exchange Rates: Timing Your NetSuite Connector Integration

Using the Exchange Rate Integration between NetSuite and SuiteProjects Pro? Here’s a timing consideration that can prevent costly discrepancies between your systems. The Issue: If your integration runs before NetSuite…
Read More

Run and Create Pending Billings for All Projects in SuiteProjects Pro

Some companies prefer manual control over when billings are created — often for accuracy, timing, or revenue recognition reasons. When managing a large number of projects, this becomes time-consuming—especially if…
Read More

Applying a Discount to SuiteProjects Pro Invoices

In SuiteProjects Pro, there is no way to automatically generate a discount with a specific percentage and apply it to an invoice. However, users with the right permissions can create…
Read More

Create Custom Approvals Using Form Permissions in SuiteProjects Pro

Not every record type in SuiteProjects Pro supports native approval workflows – but that doesn’t mean you’re stuck with an open process. With a bit of strategic configuration using form…
Read More

How To Set Default Booking Type When Creating Bookings In The SuiteProjects Pro Project Center

When creating Bookings in Project Center and the Booking type is required, the User will have to manually select it each time they create new bookings. Most of the time,…
Read More

Increase Efficiency with the Navigation Shortcuts Feature in SuiteProjects Pro

Are you tired of the number of clicks it takes you to get to where you want to be in SuiteProjects Pro? There is a solution for that in the…
Read More

Global Search in SuiteProjects Pro – You’ll Be Glad You Found It!

Today we want to shine a spotlight on a relatively new SuiteProjects Pro feature – Global Search.  Like the Search bar at the top of the page in NetSuite that…
Read More

How to Access the Time Entries List View in SuiteProjects Pro

Your environment may have already been pre-configured this way, but did you know that the ability to get a list view of all time entries in SuiteProjects Pro (SPP) is…
Read More

Searching for Resources in the SuiteProjects Pro Project Center

You can use the resource search functionality to search for resources matching your profile, job code and availability criteria, and review other projects these resources are booked to directly from…
Read More

How to Use the Pricing Feature in SuiteProjects Pro

The Project Pricing feature in SuiteProjects Pro lets you create pricing estimates for specific projects based on different staffing, rates, and time required scenarios, and automatically view the key financial analysis for…
Read More

Running NetSuite Full Synchronization with Date Control

For SuiteProjects Pro users and admins who manage NetSuite integration workflows, running a full synchronization on demand can be a powerful way to ensure data consistency across systems. Previously full…
Read More

Track Invoice Layout Changes: Accessing Audit Trails in SuiteProjects Pro

Maintaining visibility into system changes is crucial for compliance, troubleshooting, and operational transparency. SuiteProjects Pro’s audit trail functionality provides comprehensive tracking of modifications made to your data, including who made…
Read More

Maximize Project Visibility with SuiteProjects Pro’s Project Status Summary

The Project Status Summary (PSS) feature allows you to create customizable project status page, offering a clear overview of important project details such as project progress, financials or budget, quick…
Read More

Get Notified When a Proxy Submits or Approves SuiteProjects Pro Timesheets

If a user is submitting or approving timesheets on behalf of others (as a proxy), you can set up email alerts to stay in the loop. To get an email…
Read More

Mapping NetSuite Custom Segment to SuiteProjects Pro Dropdown Using Advanced Mapping

SuiteProjects Pro supports standard list or multi-select custom segment fields from NetSuite when using the SuiteProjects Pro NetSuite integration. However, if you try to directly map a dropdown-type custom field…
Read More

Enhance Rejection Notifications: Include Rejection Notes in SuiteProjects Pro Emails

When an approver rejects a transaction in NetSuite SuiteProjects Pro—such as a timesheet, expense report, or invoice—clear communication about why can dramatically improve the resubmission process. By including the rejection…
Read More

Incurred vs Forecast Revenue Rule Recognition and Resource Scheduling

If your organization uses the Incurred vs Forecast Revenue Rule for recognition it is important to stay on top of Resource Scheduling or Bookings. The Rule uses this formula to…
Read More

Leverage Repeat Billing/Recognition for Recurring Project Fixed Fee

Some of your clients might be billed for a fixed fee amount every month for work on their projects. If you are tired of creating new fixed fee billing rule/recognition…
Read More

Exclude Weekends from Daily Timesheet Rules 

Timesheet rules are dependent on current work schedule defined (on company or user level) and apply both for weekdays and weekends.  The system will not apply the usual daily timesheet…
Read More

Optimize KPIs with the New SuiteProjects Pro Home Screen

SuiteProjects Pro has been enhanced with a new Home Screen for even more targeted and actionable views than before. For this Expert Quick Tip, we will create a report and…
Read More

Prevent the Creation of Duplicate Records When Running NetSuite Connector

When a record is exported, part of the process is marking it as exported and populating the NetSuite Internal id in SuiteProjects Pro. There are instances where the export process…
Read More

Properly Use Caps on Time Billing Rules

Understanding how to properly configure Time Billing Rules with Caps is crucial to ensure accurate customer invoicing. Since SuiteProjects Pro doesn’t provide an automated way to cap invoiced amounts, using…
Read More

Automate User Active Status Between NetSuite and SuiteProjects Pro

Managing user accounts across multiple systems can be time-consuming and prone to error. When an employee leaves your company, you typically need to update their status in both NetSuite and…
Read More

Allowing Timesheet Line-Item Rejection in SuiteProjects Pro for Optimal Usage

You may already know about the optional feature to allow timesheet line-item rejection in NetSuite SuiteProjects Pro, but did you know that there are actually two internal switches that need…
Read More

Keep Projects on Track with Project Status News Feed Feature in SuiteProjects Pro

Keep your project stakeholders updated by adding, updating, and displaying project status messages. Once this feature is enabled: A news feed icon will appear in project record headers and QuickViews.…
Read More

Managing Your Project Plan Using the Project Center in SuiteProjects Pro

One of the strengths of SuiteProjects Pro is the flexibility for managing project plans.  Traditionally project plans were managed via project task assignments with dates and predecessor relationships.  But if…
Read More

Using Custom Fields in SuiteProjects Pro

One of the most common ways that users get more from their SuiteProjects Pro tool is by using custom fields to track information, calculation values, or enhance form usage. Custom…
Read More

Prevent Mixup Between SuiteProjects Pro Production and Sandbox Instances

For those SuiteProjects Pro users and Admins who bounce back and forth between sandbox and production environments frequently or have both instances open on their PCs regularly, a quick tip…
Read More
Out of Office sign on a beach

Displaying Leave Accrual Balances for Manager Approval in SuiteProjects Pro

When managing time-off requests in SuiteProjects Pro, depending on your internal process it may be important for managers to see an employee’s current leave accrual balance during the approval process.…
Read More

Managing Retainers When Crediting an Invoice in NetSuite SuiteProjects Pro

Understanding how retainers are managed when crediting invoices is crucial for maintaining accurate financial records and ensuring your retainer balances are correctly applied in NetSuite SuiteProjects Pro. When an invoice…
Read More

Why You Should Consider Using the Business Intelligence Connector

What is it? The Business Intelligence Connector is an add-on to SuiteProjects Pro that allows list views and reports built in the application to be fed to other applications or…
Read More

Access Your Action Items from Anywhere with SuiteProjects Pro To-Do List

Previously users had to visit several locations and dashboards to find all of the tasks assigned to them.  With the October 2024 release of OpenAir, now known as SuiteProjects Pro,…
Read More

How to Change the Additional Text to Stand out on Invoice Layouts

Did you know you can change the additional text color, size, bold underline and italics? If you want some of your text to stand out and have a bit more…
Read More

Quick Fix: Report Level Filters Are Not Respected If There is a Custom Calculation on the Report

By default, if you have a custom calculation on your report and that custom calculation has a filter on the same record type as your report level filters, SuiteProjects Pro…
Read More

Managing OpenAir Saved List Views as an Administrator

If you’ve come across our Streamlining Configuration for Saved List Views in OpenAir Expert Tip, then you have certainly made a few List Views for yourself or your firm. Maybe…
Read More
Configuring an OpenAir Invoice

How to Define OpenAir Invoice Terminology Based on Customer Needs

OpenAir Invoice layouts allow you to configure the appearance of an invoice. You can sort or group items as an example, but you can also override the terminology of the…
Read More

New Custom Fields Reveal Calculation of Incurred vs. Forecast Revenue Recognition Transactions

Thanks to a recent update, auditing revenue recognition transactions created by the Incurred vs. Forecast revenue recognition rule just became much easier. You can now create custom fields to hold…
Read More

Close a Task for Time and Expenses Entry by a Specific User

Sometimes a project task has many resources assigned, and not all for the same duration.  One assignee’s work on the Task could be completed, but the Task needs to remain…
Read More

Crosstabbed Reports Customized to Look Like a List

If you struggle to find the filters you need on a tabular report, using a crosstabbed report and suppressing the measures may be a good alternative.  Crosstabbed reports have exponentially…
Read More

Quick Fix: Making New NetSuite Projects Instantly Visible in OpenAir

When projects are integrated from NetSuite to OpenAir, users may notice they don’t immediately appear in the Projects list (Projects > Projects > All), even after refreshing the page. While…
Read More
The words 'did you know' appearing behind torn orange paper.

Setting Task Assignment Billing Rates with NetSuite OpenAir

One of the strengths of OpenAir is the flexibility for billing time.  This tip shows another option to set billing rates on approved time entries. Time based billing rule options…
Read More

Update Your Project Billing or Recognition Settings Quickly using the Tag and Copy Feature

Save time by using the “Tag and Copy” feature to update auto-run settings for project billing or recognition rules in bulk. You tag the project that has the settings you…
Read More

Three Easy Navigation Tips for NetSuite OpenAir

Check out these navigation tips and tricks to optimize your usage of NetSuite OpenAir. Using the Back Button Did you know that most records opened via a list view in…
Read More

Why Use the Resource Booking Worksheet View?

If your organization uses Resource Bookings, changes may be needed from time to time. Consider using the Worksheet view.  Changes to multiple bookings can be updated all at once for…
Read More

How to Adjust an OpenAir Timesheet After it is Approved

Timesheets are a part of every workday.  Sometimes errors occur that necessitate a correction.  In cases where the timesheet is already approved, a timesheet adjustment is necessary. Steps to adjusting…
Read More

How to Copy Workspace Documents List View to Other Users with the Bulk User Change Wizard

If you want to copy your Workspace documents list view to other users in OpenAir, you can easily do this using the Bulk User Change Wizard. Here’s a friendly step-by-step…
Read More

Building Dynamic Roadmaps with OpenAir

Project plans can be complex and when a date changes on an early deliverable, keeping the rest of the plan in line can be time consuming.  By linking tasks together…
Read More
Colorful data visualization with glowing bar graph on dark background, representing analysis, growth, and technology with a futuristic touch.

How to Optimize Charge Projections in NetSuite OpenAir

Charge projections in OpenAir help organizations forecast revenue and billing effectively. To ensure accuracy and efficiency when working with charge projections, consider the following best practices: Define Clear Projection Rules…
Read More

How to Use Bulk Actions to Update Bookings in OpenAir

Organizations use Resource Bookings to forecast staffing needs.  Updating bookings on a regular basis based on changes in schedules is essential to keep the forecast up to date. These changes…
Read More

How to Create an Invoice Overdue Approval Report

Currently, there is no overdue approval alert/notification for Invoices where system will automatically send alert/notification to approvers if they have invoices waiting for their approval for X number of days…
Read More
concept of improvement to get to target representing presenting with the data choices to improve accuracy in data and for reporting.

Optimize Your Workflow with Conditional Dropdowns in OpenAir

Conditional Dropdowns in OpenAir offer a powerful way to streamline data entry and enhance reporting accuracy. This feature allows you to create dynamic, nested dropdowns where the options in one…
Read More
Businessman works on laptop showing dashboard for insight reports of utilization

How to Report Target Utilization that is Date Driven in OpenAir

Target Utilization is a feature in OpenAir that you can enable that will allow you to set a target utilization on a per User basis. By going to the User…
Read More
Fill the missing parts fragment of white jigsaw concept puzzle

How to Identify Projects Missing Billing Rules in OpenAir

There are many approaches to Project creation and setup in NetSuite OpenAir but no matter the approach, there is always a chance that a step could be missed. Given the…
Read More
Businessman and engineer working hands of business people join hand together.

Fun with NetSuite Connector Advanced Mapping

There are times that only a NetSuite Connector advanced mapping will do when trying to export the right data to NetSuite. There are many advanced mappings available to meet your…
Read More

NetSuite OpenAir Form Permissions: Hiding Divider Sections

Form permissions allow you to control the information that your end users can view or modify based on their role in the system. NetSuite OpenAir offers admins the ability to…
Read More
Cycle Update Symbol 3d Abstract Arrows Icon Design Template Vector Illustration. Cycle Update Symbol 3d Abstract arrows Icon Design Template Vector Illustration

Bulk User Wizard Copy Tip

The bulk employee change wizard enables account administrators and users with the Bulk Employee Change Wizard role permission to copy information from one active employee record to multiple active or…
Read More
Serious, business man and thinking on computer in office, internet

Use Filters to Enhance Your Use of the Advanced Booking Worksheet

The OpenAir Advanced Booking Worksheet feature lets a user view, edit, and create bookings for multiple users, multiple projects, across multiple dates in a single screen. There are cases where…
Read More
image of laptop overlayed with rules documents

How to Use the Restricting Option to ‘Leave the hours the same’ when Cloning Timesheets in OpenAir

Would you like to allow your users to leverage the timesheet cloning feature to make the timesheet creation process more efficient without them being able to copy the hours from…
Read More

Streamline Your Workflow with OpenAir Mobile 5.1

Streamline Your Workflow with OpenAir Mobile 5.1 OpenAir Mobile 5.1 – Draft Inbox Feature for Time Entry & Expense Receipts Get ready to elevate your productivity with the latest update…
Read More
close-up of hands typing on a keyboard against a backdrop of soothing blue tones, with an hourglass nearby

Creating Bulk Action Functionality for Timesheets in OpenAir

A user may need to update the accounting period on timesheets en masse. Or perhaps they need to delete and remove some blank timesheets. However, when they navigate to the…
Read More
Women using smartphones check email notifications inbox

How to Suppress Email Notifications in OpenAir

OpenAir sends automated notifications associated with many different events, including (but not limited to): Booking creation Issue status update Task assignment Certain project updates Not every organization is interested in…
Read More

7 Tips for Managing Bookings Effectively in NetSuite OpenAir

Managing bookings effectively in OpenAir involves leveraging the platform’s various features and tools designed for resource and project management. Here are some steps and best practices to help you streamline…
Read More
AVAILABILITY sign on the page.

How to Visualize Resource Availability in the OpenAir Project Center

Identifying when a resource is overworked or underutilized can be difficult when working across multiple teams and many projects.  OpenAir helps simplify the process by providing visual indicators when creating…
Read More

An Easy Way to Create Foreign Language Layouts in OpenAir

Does your organization do business in multiple countries? Here is an easy way to create Invoice Layouts for each Language. Step 1 Go to Administration > Application Settings > Invoices…
Read More
Text sign showing Did You Know Question.

Prevent Duplicate Records when NetSuite OpenAir Integration is Interrupted

OpenAir acknowledges a successful export by marking a record as exported and displaying its corresponding ID from NetSuite on the OpenAir record Properties form. However, if the export process is…
Read More

Unlock Your Technical Knowledge with the OpenAir Data Dictionary

One of well-known necessities of navigating a cloud database platform is a Data Dictionary.  A Data Dictionary is much like a regular dictionary, but instead of words, contains all definitions…
Read More
closeup hand using computer laptop with overlay fast speed connection concept.

Double the Speed of Your OpenAir NetSuite Connector by Enabling Direct TBA

By enabling direct token-based authentication (TBA), it utilizes a more robust communication channel between OpenAir and NetSuite. This simplifies the authentication process when running NetSuite Connector resulting in faster integration…
Read More
person at lap top with invoice and 4 receipt attachments

How to View Expense Receipt Attachments in OpenAir Invoices

Some invoices have expense charges, and you might want to make the supporting receipt attachments for those charges available along with the OpenAir invoice.  For invoices where you want to…
Read More
picture of hand with binoculars

How to Locate Your NetSuite OpenAir Database ID

Whenever you need to contact NetSuite OpenAir’s Support team to request an internal switch, a Sandbox refresh, or miscellaneous product assistance, you will always be asked to provide your company’s…
Read More

Leveraging the Signer Feature for External Customer Timesheet Approvals

Did you know that NetSuite OpenAir has a feature to allow customers to approve timesheets and expense reports prior to billing? The Signers feature works as an external approval process for time…
Read More
Managing filter sets on clients and users in OpenAir

Managing Filter Sets on Clients and Users in OpenAir

Primary filter sets set on user record limit what records a user has access to. However, it is common to have the need to group clients and users in member…
Read More
person at keyboard creating a list

How to Save List Views in OpenAir

Saving List Views is a simple and effective way to standardize user experience in OpenAir for efficient communication and training. Editing your list view OpenAir allows users to edit their…
Read More
Person linking documents and folders electronically

Leveraging Custom URL Fields to Link to Project Related Documents and Folders in OpenAir

Did you know you can create custom URL fields on various record types in NetSuite OpenAir  to link to cloud storage (ie. Google Drive, OneDrive, SharePoint etc) based files and…
Read More
man at laptop moving fast

How to Get Data to NetSuite Automatically in Real Time

NetSuite OpenAir offers a number of ways to integrate with NetSuite Financials using the NetSuite connector : Manually, batched Schedules and in Real Time. Setting up a real time connector…
Read More
photo of a weekly time sheet

How to Add Start Time and End Time Column to Time Entry List Views

Some users prefer to enter their time into their timesheet by inputting the start and end time that they worked on a specific task. This enabled feature in the timesheet…
Read More
Woman with question marks around her head

Guide to Quick Audit Trails in NetSuite OpenAir

Keeping track of changes made to your NetSuite OpenAir account is essential for maintaining data integrity and ensuring accountability. Fortunately, OpenAir offers a handy feature called “Quick Audit Trails” that…
Read More
Need to include OpenAir project info on a NetSuite Invoice?

How to Export OpenAir Project Fields Directly to a NetSuite Invoice

When exporting an invoice from OpenAir to NetSuite, the fields are typically limited to invoice fields; however, with minimal setup, OpenAir can map fields directly from a project to the…
Read More
person at keyboard with system gears overlay to indicate Auto populating data

How to Auto-Populate Timesheets With Weekly Booked Hours in OpenAir

Did you know you can have users’ weekly booked hours pre-populate timesheets in NetSuite OpenAir? We are commonly asked if a user’s booked or planned project hours for the week…
Read More
Growing scale percentage bar up to 100. Work progress.

Simplified Use of Percent Complete Recognition Rules in OpenAir

Organizations that would like to use percent complete revenue recognition rules often run into difficulty when their regular business processes do not include sufficient project or resource management information to…
Read More

Customizing OpenAir User Access Using the NetSuite Connector

When using the NetSuite Connector to create new users in OpenAir, it’s possible to customize the Primary Filter Set assigned for a user.  This eliminates the need for manual updates…
Read More

Allow Future Dated Charges on OpenAir Invoices

NetSuite OpenAir’s default settings allow you to manually enter charges and create invoices containing those charges, as long as the charge dates are not in the future. However, some companies…
Read More
The hand of a man with a light bulb And there is a gear icon in it And he is using a notebook computer.

Managing How Job Codes Get Applied to Time Entries in OpenAir

Job codes in OpenAir provide key reporting and time billing capabilities.  Job codes are applied to time entries based on rules that can be managed in OpenAir.  For time-based billing,…
Read More
Young woman holding a megaphone cheerful smiles pointing to front.

Adding HTML to NetSuite OpenAir home page or workspace messages.

NetSuite OpenAir allows html to be added to the Home screen message or Workspace messages.  You can provide links to impactful resources or enhance your message with tags. To add…
Read More
Car windshield wiper cleaning water drops from glass while driving

Improve Visibility with Project-Level Filter Sets in OpenAir

Filter Sets allow you to limit the results presented in lists and reports to only what should be relevant to the user logged into OpenAir.  For example, you can use…
Read More

Set Time Entry Rounding at the User Level

OpenAir can be configured to round time entries to the nearest minute, 5, 10, 15, 30, or 60 minutes. Another option is to round up to the next 6 minutes.…
Read More
picture of woman who is trying to remember

Streamlining Time Off Management in OpenAir

Tired of manually creating time off bookings when a time off request is approved, to accurately represent resource availability? Or remembering to add time entries for time off on timesheets?…
Read More
Close up of time and money with green bokeh background ,Business Finance and Money concept,Save money for prepare in the future.time is money concept

Save Time Populating Fields with “Save & Create Another” Form Permission Setting

Do you find yourself wasting valuable time populating redundant fields when creating data records in NetSuite OpenAir? Try the Fields which maintain value on “Save & create another” form permission…
Read More
two dogs dressed up in suites and sunglasses.

Looks Aren’t Everything… But They Do Matter

Would you like to add a little pizazz to your OpenAir viewing experience?  Today we’ll learn how to use some basic html tags to change the way some OpenAir fields…
Read More

Providing Project access to Portfolio Managers Using Project Hierarchies

Often, we work with clients that have the concept of Project Portfolio managers.  Portfolio managers need access to a group of projects within the project, resource and report modules; however,…
Read More
Dark achatina snail with Dark shell crawling on the Stone floor near Hourglass. Deadline concept and Slow current time.

Slow OpenAir Reports? Try Reducing Reporting Currencies!

Enabling multi-currency in your system provides a comprehensive view of various currencies within reports, offering a broad spectrum of metrics. However, navigating through multiple currencies in reports might seem overwhelming…
Read More

Two Ways to Change the Owner of a Report in NetSuite OpenAir

There are several use cases for needing to change the owner of a report in NetSuite OpenAir. Maybe you created a report for someone else and you’d like to simply…
Read More
round ball take an alternative path from the blocks

Time Saving Technique for Time Entry Imports into OpenAir

Normally, OpenAir users do two separate uploads for importing time entries to OpenAir. The first upload is to create timesheets and then the second upload to create the time entries…
Read More
person accessing contact details

Streamlining Client Contacts within Projects: A One-Screen Solution

Creating Client Contacts In OpenAir you can associate contact information to a client record. These contacts can be designated as billing contacts to receive invoices, or simply additional customer contacts…
Read More

How to Create Fixed Amount Revenue Recognition Rules in Bulk Using Integration Manager

Normally, if we are creating revenue recognition rules using the NetSuite OpenAir Integration Manager tool, we use the Rev. Recogn. Rule import. However, this does not work for the fixed…
Read More
User using Mobile Phone connection between Smart phone and computer to import expenses from their credit card

Structure CSV Files for the American Express Receipt Import Wizard

Some time ago, American Express changed the format of their CSV export for a “solo user” account such that it is no longer accepted by the American Express receipt import…
Read More
Closeup woman sit near the window and use a smartphone to scan a receipt for expense report

Enhancing Expense Report Accuracy: Preventing Header-Level Attachments

Does your organization struggle with physical scans/copies of receipts for incurred expenses being erroneously attached at the expense report (header) level? Do you spend unnecessary time sorting through numerous attachments…
Read More

How to Automatically Create Time Entries for Bookings

Many NetSuite OpenAir customers utilize NetSuite OpenAir bookings for project management and resource forecasting. However, time entry on timesheets to log actual time incurred may still be a necessity. With…
Read More
Hand holding a key

The Secret to Overcoming Data Filtering Challenges with Custom Calculations

OpenAir offers powerful reporting capabilities that allow you to access and share key data from your OpenAir system. However, it’s not uncommon for our customers to report that they are…
Read More
Picture of keyboard with notepad that says Healful Tips

NetSuite OpenAir Script Development and Trouble Shooting Pro Tips

These tips are meant to show you ways in which to set up your NetSuite OpenAir development environment to ensure success when using NetSuite OpenAir Scripting. Setting Up Your Scripting…
Read More
Woman reviewing invoices

Setting Project Level Billing Contacts in NetSuite OpenAir

OpenAir allows you to select a billing contact on a per project basis. This feature is helpful when you have multiple projects for one client and invoices need to be…
Read More

How to Import Taxes from NetSuite Back to OpenAir

When tax is calculated in NetSuite, it may be beneficial to bring tax amounts back into OpenAir for financial visibility or reporting. Method 1: Pullback Mapping (not recommended if using…
Read More

Set Timesheet Required Checkbox on Users Using Integration Manager

If you have decided to use the ‘Timesheet Required’ checkbox on user records to generate/filter timesheet alerts, timesheet status and various other hours/time related reporting, there is now a quicker…
Read More

Leverage the Power of OpenAir Billing Codes

Does your business need to create hundreds of invoices every month? Would you welcome a way to speed up your OpenAir invoicing process? The Billing Codes feature could help you…
Read More
picture of person checking the tasks completed

How to View ETC and EAC within the OpenAir Project Center

ETC (estimate to complete) and EAC (estimate at complete) are very important metrics when evaluating the health of a project. Historically, these metrics were difficult to see if you are…
Read More
picture of keyboard with lock

What Locks Up Custom Fields in OpenAir?

If you’ve come across a custom field that you’ve made or that came out of the box and cannot delete it, there are a few reasons why this may happen.…
Read More

Understanding NetSuite OpenAir User License Types

With the most recent release in April 2023, NetSuite OpenAir now makes it easier than ever to view your current license usage. The new Licenses page is located under Administration…
Read More

Disable New, Multiple Bookings Option in OpenAir

This feature removes the Bookings “New, multiple…” option from the Create Button menu. Internal Switch: Disable displaying of New Multiple booking in creation menu Why disable this feature? When form permissions are configured on the standard booking form…
Read More

Handling Multi-Week Work Schedules in OpenAir

For customers who want to enable multiple week work calendars in OpenAir to facilitate biweekly schedules such as 5-4/9s. Two account settings in Optional Features are required: Enable distinct work…
Read More

Control Which Users are Available for Assignment to a Project in OpenAir

The Assignment feature is a flexible tool that allows you to control which projects and tasks are available to users for time entry.
Read More

How to Suppress Standard Email Notifications in OpenAir

OpenAir offers the capability to send custom email notifications when changes are applied to bookings, tasks, projects, or issues. However, in certain cases, users may not want to receive an…
Read More

Using the Web Services Usage Log for Debugging Integrations

The Web Services Log records API calls to OpenAir and OpenAir’s response. This is useful in debugging integration with OpenAir. To access the web services usage logs, you will need…
Read More

Wrapping Money-Based Custom Calculation Titles in OpenAir

Back in July of 2022, we posted a tip called “How to Control Column Widths for Custom Calculations in OpenAir”. In that tip, we explained how to insert HTML line…
Read More

Prevent Work Schedule Hours From Being Counted Towards Utilization Before the User Was Employed

To address instances where utilization is being counted for new users before their start date, OpenAir provides a solution to ensure accurate utilization figures. The recommended approach is to update…
Read More

How to Reject Your Own OpenAir Timesheet to Make Corrections

In situations where an employee submits a timesheet prematurely and wants to make alterations, the existing process entails the entire timesheet being rejected by an approver before changes can be…
Read More

Easily Access Receipt Attachments for Invoiced Expenses in OpenAir

There is an easy way in OpenAir to gather and download all receipt attachments for expenses included on a particular invoice. This is great for customers that require receipt backup…
Read More

Remove Personal Identifiable Information with OpenAir’s New Easy to Use Process

OpenAir has a new feature to remove personal information in their April 2023 release. This process is essential to comply with new laws governing PII. To get started, the organization…
Read More
picture of an notification symbol on a handheld device

Using OpenAir Custom Notifications Feature and Suppressing Standard System Notifications

Custom notifications are triggered in the same manner as standard system notifications are but custom notifications allow the ability to apply conditional criteria to your notification triggers and also provide…
Read More

How to Remove Incomplete Tasks from the OpenAir Dashboard

The ‘Display Incomplete Tasks on Dashboard’ feature is enabled by default, and it adds two links regarding Incomplete Tasks on the Home screen.  in My Status the number of Incomplete…
Read More

‘Product Updates’ Icon in OpenAir

Ever wonder what this icon is for in OpenAir? It’s the OpenAir ‘Product Updates’ icon, located on the top right-hand side of the page banner.  Clicking the icon opens a…
Read More

Is your Professional Services firm ASC 606? OpenAir can do that.

PSA firms that recognize revenue using ASC 606 standards need the ability to allocate revenue as services are delivered, and this can feel like a heavy lift for organizations with…
Read More

Maintain Dashboard Portlet Resizing in OpenAir

Have you ever taken the time to get your dashboard portlets resized just right, only to navigate away from the page and find them automatically resized when you come back?…
Read More

Automate the Deactivation of a Project when All Tasks Are Closed

Ever come across projects that remain active in your OpenAir instance despite all tasks being closed? Don’t have time to audit this as regularly as needed but want to ensure these projects are deactivated so…
Read More
picture with words, Follow these steps.

Copying OpenAir Dashboards From One User To Others

OpenAir allows you to create multiple OpenAir Dashboards in order to display data in charts for monitoring important data.  Often Dashboards are built by power users where key data is…
Read More

Using Auto-Approval Thresholds in OpenAir

A rarely used feature of OpenAir is the auto-approval thresholds. This feature is particularly helpful for organizations that do not have other business applications to provide these controls; or for…
Read More
Person at keyboard sending emails

Capture OpenAir Invoice Short URL And Take The “Send” Function To A Whole New Level.

OpenAir provides the ability to send a link to an invoice directly to the client through the “Send” page on the invoice itself. The “Send” link is highlighted in the…
Read More
picture of one large stone and multiple small stones in balance

How Can I View a Retainer Balance in OpenAir?

Retainers serve as an advanced payment of the customer agreement.  A retainer can be applied to the Invoice associated with the customer and deducted from the invoice’s total. On an…
Read More
person at keyboard checking of completed tasks

Manually Managing Task Percent Complete

The Percent Complete of a Task can be very handy when used to trigger billing events (Fixed fee on % complete billing rule) and revenue recognition (% Complete recognition rule).…
Read More
Send invoices from a group email

Send Invoices From A Group Email In OpenAir

When sending an invoice from OpenAir, the sender that appears in the email will default to the user who sends the invoice, however this can be changed so that the…
Read More

Converting Hours to Days for Billing in OpenAir

Using OpenAir billing rules, you can configure the rules to convert hours recorded on timesheets into days in order to invoice a customer by number of days. Within a time…
Read More

Creating Dependent Dropdowns in OpenAir

OpenAir has the ability to link two custom dropdowns such that the values in the child dropdown will be dependent on the selection of the value in the parent dropdown.…
Read More

When to Use Balanced Incurred vs Forecast instead of Incurred vs. Forecast

Balanced Incurred vs Forecast rule uses Internal Pivot Date when recognizing revenues. If an organization uses Accounting Dates this is a great option. For timesheets, the rule will recognize revenue…
Read More

Allowing Users to Specify Report Filter Sets in OpenAir

If your company is like most, the OpenAir Reports module is used by many users in different parts of the organization to get and share information about your Projects, Users,…
Read More

Why Approval Routing Cannot be Deleted in OpenAir – And How to Resolve

If the ‘Delete’ button on an Approval Routing does not appear, even though it has no transactions routed through it, it can be due to the Approval Process being set…
Read More

Trick for Using Blank Date Field in Form Permission Rule Logic

OpenAir’s form permission rules are a great way to customize any forms—Project Properties, Timesheets, Expense Reports, etc. You can create your own logic to show/hide fields, make fields read-only or…
Read More

Recovering Report Configuration/Settings of Last Report Run in OpenAir Report Management & Editor Interface

This is a trick that allows you to recover report configuration/settings when using the current OpenAir Report Management & Editor interface. If you are using the older reporting UI, this…
Read More

Audit Trail in User Interface for Company Switches

“Who changed that setting?” There are many settings that can be toggled on and off in OpenAir if the user has sufficient privileges. Often these settings can drive changes to…
Read More

Rate Multipliers for Special Situations in OpenAir

In OpenAir there is an easy way to create billing rules that include situations for varying rates for weekend work, yearly increases, or for remote versus onsite work rates. Important:…
Read More

Use Bookings Rather Than Assignments to Calculate Task Schedules in OpenAir

Is your company using resource bookings faithfully, but you still need to separately manage assignments to keep your task dates and planned hours in line? There is a little-known feature…
Read More

Warning — User Cannot be Deleted Due to Having Associations With list_layout_users

Often, we run into the need to delete a record in OpenAir. Projects, Expense Reports, Timesheets, and Invoices are all very common records for deletion, but what about Users? Did…
Read More

Why is Budget not populating on my Reports?

Have you ever built a report and added Budget as a measure, but the budget didn’t populate, even though there was budget on the project? Budget will only populate if…
Read More

Usage of OpenAir project templates when projects are created via NetSuite OpenAir Integration

The required configuration needed to utilize project templates when projects are created via the NetSuite and OpenAir Integration has changed and been simplified. You no longer need to set the…
Read More

Adding Additional Project-Specific Approvers in OpenAir

OpenAir’s project-specific approvers feature allows the system to have up to three additional approvers identified for each project. This can be activated through the Administration -> Organization -> Approval Options…
Read More

Creating Projects Using Project Templates in NetSuite OpenAir – What’s Included and What’s Not

OpenAir project creation can be a cumbersome process that requires a significant amount of administrative time. For that reason, many companies creating projects directly in OpenAir (versus via an integration/API)…
Read More

Tracking OpenAir Expense Report Reimbursements

Stop me if you’ve heard this one before.  I submitted my expense report three weeks ago, and I know we process expenses every week.  So why haven’t I been reimbursed…
Read More

How To Use Detail Field Values In Custom Calculations

Custom calculations allow the creation of custom report values in OpenAir. Generally, custom calculations contain two summary field values with an operand. However, you can also use detail field values…
Read More

OpenAir Switch: Saving Timesheet Line-Item Rejection Details

Did you know you can save rejection details for rejected time entry line items in the rejected timesheet approval history? There is a useful switch for clients using the timesheet…
Read More

Summary Reporting… Without Summarizing

Do you have a summary (cross-tabbed) reporting need where you either need to Display the sum for a single, filtered, value rather than summing two values? Display details for single…
Read More

Netsuite OpenAir: Help Center vs. Suite Answers

NetSuite OpenAir has a couple of places, within the tool set up as knowledge bases and tools for users. Both have great uses, depending on your role and function within…
Read More

When to Use a Pick List Over a Drop Down In OpenAir

When creating custom fields in OpenAir there are two fields a user can choose which look similar but are used for different purposes: The dropdown and the pick list. Dropdowns…
Read More

Managing OpenAir Task Assignments: Using Both Project and Task Assignments

Some companies may have the situation where there are different business units who would like to manage project assignments differently: One wants to use project assignments that allow any user…
Read More

How to Disable the Feature-Specific Survey Forms in OpenAir

Issue: When using specified features repeatedly OpenAir will prompt the user to complete a short survey. There are certain features that, when used multiple times, will prompt the user to…
Read More

How to Change the Start Day for Weekly Timesheets

Did you know that there are multiple ways to configure the start day for weekly timesheets? There are Open Air Administrator accessible settings that allow you to set it up…
Read More

OpenAir Sandbox Refresh: Helpful Reminders

When your organization has finished configuring and testing in OpenAir Sandbox, you are happy with the results, and ready to schedule a Sandbox refresh, here are some valuable reminders to…
Read More

How to Control Column Widths for Custom Calculations in OpenAir

Issue: Custom Calculations names don’t naturally break so the names can cause column widths to make reports difficult to read. Example: Fix: You can add breaks to custom calculations names…
Read More

Copy Project Billing/Recognition Settings from One Project to Others in Bulk (Tag the Project)

The billing and recognition settings allow managers to schedule project billing and recognition rules to run automatically on a specified schedule, either on a trial or actual basis, and to email selected users as to the results.…
Read More

Audit Trails for Detail Fields on Summary/Cross-Tabular Reports in OpenAir

Often in Summary/Cross-Tabular reports there is a need to display detail fields associated with one or more of the sub-total groups identified in the report.  This is a very common…
Read More

Sending OpenAir Reports to External Contacts

There may be people outside your organization, with no OpenAir access, who need information from the OpenAir system.  For example, a manager at a company with resources working on your…
Read More

OpenAir ‘Review Last Notification’ Feature

Ever get a notification pop-up when saving a form in OpenAir only to accidentally close out the notification box before clearly reading the message? The OpenAir ‘Review last notification’ option…
Read More

OpenAir Account Storage Alert

If you’ve used OpenAir for any extended amount of time, it’s likely that you’ve approach, or even met, your storage limit. This means that your users are unable to attach…
Read More

Using the Task Percent Complete Setting in OpenAir

The Task Percent complete interval controls many settings in OpenAir.  This setting is found in Other Settings within the Project Module administration settings. For any task-oriented percent complete calculation that…
Read More

NetSuite OpenAir: Help Center vs. Suite Answers

NetSuite OpenAir has a couple of places, within the tool, set up as knowledge bases and tools for users. Both have great uses, depending on your role and function within…
Read More

OpenAir Redesigned Advanced Filters (Optional Feature)

The Redesigned Advanced Filters feature is an update to the previous existing advanced filters on redesigned list views. The redesigned advanced filters panel is compact and lists filter conditions horizontally instead of vertically. It lets you select and apply saved filters directly…
Read More

The OpenAir Self-Rejection of Timesheets Feature

It’s not uncommon for a user to enter all of their time on a timesheet and submit the timesheet – and then notice something is off.  It’s not *as* common…
Read More

Grouping Multiple Fixed Fee Charges Within an OpenAir Invoice Layout

Business case: Client has multiple fixed fee charges with the same description but with different services and needs the fixed charges to appear as 1 charge on the Invoice. Challenge:…
Read More

Adding Multiple Report Filters In OpenAir – It’s Always an “And”, Not an “Or”.

When trying to create a report in OpenAir one thing to keep in mind with filters is when adding each filter, they act as an “and” with each other, not…
Read More

Using Current Periods to Customize Accounting Dates in OpenAir

OpenAir’s accounting period functionality lets you associate separate accounting dates with most transactions.  This feature also allows you to define Current Periods.  A current period can be associated with an…
Read More

Renaming Standard Values in OpenAir Reports

Custom calculations allow you to create new reportable values when there is no standard field available.  You can name the field to match your nomenclature and shorten the name for…
Read More

OpenAir Timesheet Duration Override at the User Level

This feature in OpenAir permits users to be set to their own timesheet duration, overriding the company level default duration setting.
Read More

How to Setup Timesheet and Expense Line-Item Rejection Notifications in OpenAir

Timesheet rejection notifications are commonly used in OpenAir to notify users that an entire timesheet has been rejected. Out of the box, new instances of OpenAir are usually set up…
Read More

Bulk Delete Timesheets and Expense Reports In OpenAir

Not all data is good data! Over time timesheets and expense reports may accumulate from canceled projects, inactive users, or from rejected approvals. OpenAir now offers features that will allow…
Read More

Tracking Costs Against Tasks in NetSuite OpenAir

Many OpenAir users track their hourly employee costs against specific project tasks.  There are a few ways to do this. However, the simplest method is to use one of the…
Read More

OpenAir Shortcuts: Use the Quickview Feature

Often, when looking at data in OpenAir, you need to access different components of the project. Rather than navigating from scratch from, say, the charge record to the project record,…
Read More

How Inactive OpenAir Users Affect Scheduled Scripts

In many instances with OpenAir, companies will have customized java scripts running on their behalf. Scheduled scripts are executed within the context of a user. The scheduled script requires an admin user to…
Read More

Using the Expense Policy Feature in OpenAir

Need to control what expense items can be charged to a project? Using Project Expense Policies is your solution. Using this module, you can set a max amount that can…
Read More

Auditing and Cleaning Up Reports in OpenAir

When completing your standard administrative auditing processes in OpenAir, it’s a good idea to review report usage and clean up reports owned by inactive users. Having reports that have not…
Read More

Integrating NetSuite Custom Record Types to OpenAir Records

When using OpenAir and NetSuite, you can create custom record types in NetSuite and have them seamlessly sync to OpenAir.  NetSuite custom record type allows you to add picklist fields…
Read More

How to Update Information on Your Generic Resources in OpenAir

OpenAir provides the capability to add Generic Resources with many of the same Demographic and other fields available on regular user records.  Custom fields, entity tags, Job code, Cost, etc.…
Read More

How to Pro-Rate Charges During Invoice Creation in OpenAir

OpenAir provides a feature that allows invoices to be pro-rated at the time of creation.  This feature requires a switch be enabled by OpenAir Support.  Once the switch is activated,…
Read More

Setting Audit Trail Fields for Use in OpenAir Summary Reports

Enabling the OpenAir switch, “Audit Trail Values Available in Summary Reports”, allows for the display of a new section in the Reports -> Options screen.  This section shows all of…
Read More
what-is-the-openair-project-center-and-how-does-it-help-me

What is the OpenAir Project Center and How Does it Help Me?

In the Spring 2019 release, OpenAir introduced the Project Center. This optional feature, which must be enabled by OpenAir support, merges common project management functions into a single screen. If…
Read More
Place Custom Fields Exactly Where Needed on the Form in OpenAir

Place Custom Fields Exactly Where Needed on the Form in OpenAir

Starting with the October 2018 release of OpenAir, it is possible to individually place each custom field just like standard fields, exactly where you need them on the form. The…
Read More
Scroll To Top