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…
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…
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…
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…
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…
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…
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…
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…
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…
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%…
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…
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,…
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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.…
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…
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…
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…
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.…
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…
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…
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,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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.…
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?…
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…
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…
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,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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?…
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…
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…
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…
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…
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…
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).…
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…
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…
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.…
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…
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,…
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…
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…
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…
“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…
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:…
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…
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…
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…
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…
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…
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)…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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.…
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…
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…
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…
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…
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…
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…
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…
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…
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:…
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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…
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…
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.…
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,…
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…
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…
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…
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.