Skip to content

Expert Quick Tips

How to Locate Your NetSuite OpenAir Database ID

By Alexandra Goodrich | April 16, 2024 | Comments Off on 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 database ID. Rather than searching through old emails, files, or hand-written notes to find it, there is a simple way to access it directly within…

Leveraging the Signer Feature for External Customer Timesheet Approvals

By Kim Albanese | April 9, 2024 | Comments Off on 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 and expense. Signers do not need any login credentials. If your customers require approval of time and expense incurred prior to billing, you can leverage the Signers…

Managing Filter Sets on Clients and Users in OpenAir

By Ronn Breaux | April 3, 2024 | Comments Off on 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 filter sets to limit access to groups of users. This is very common in acquisitions, where a company acquires a company and they want to…

How to Save List Views in OpenAir

By Tres Churchill | March 26, 2024 | Comments Off on 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 list view layouts by clicking on the Customize list view icon. Select/deselect until only desired fields are shown. You can sort the order in which…

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

By Andrea Larsen | March 20, 2024 | Comments Off on 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 folders? Instead of attaching items directly on OpenAir records and dealing with storage space limit challenges or worrying about uploading or attaching documents in numerous…

How to Get Data to NetSuite Automatically in Real Time

By Robert Giordano | March 13, 2024 | Comments Off on 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 will allow you to send data to NetSuite without delay. This functionality is limited to the following modules : Timesheets, Invoices, Purchase Requests, Expense Reports,…

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

By Alexis Jackson | March 5, 2024 | Comments Off on 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 module will allow for users to auto populate their time entries with the worked hours amount. Previously the start and end times were not visible…

Guide to Quick Audit Trails in NetSuite OpenAir

By Jim Schein | February 29, 2024 | Comments Off on 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 allows you to monitor modifications made to various settings and custom fields. Quick Audit Trail for Administration Settings The “Quick Audit Trail for Administration Settings”…

How to Export OpenAir Project Fields Directly to a NetSuite Invoice

By Jonathan Sitterley | February 20, 2024 | Comments Off on 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 invoice header in NetSuite. This mapping allows a project owner to set information on the OpenAir project that can flow directly to the final invoice,…

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

By Zach Kerr | February 14, 2024 | Comments Off on 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 can automatically populate the timesheet in NetSuite OpenAir; well, they can! To take advantage of this setting, contact NetSuite OpenAir Support and request that the…

Scroll To Top