-
Mutually exclusive switches
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">Some switches in OpenAir are mutually exclusive. You might have tried to enable the task assignment at the project level in My Account -> Company -> Settings, but even though you clicked the checkbox, then saved it, it will say the settings have been…
-
OpenAir Admin Tip | XML API Best practices
OpenAir provides OpenAir XML API as a layer for the exchange of OpenAir data between the main site and peripheral programs. These programs include partnered Web sites, OpenAir in-house applications that do not need direct database access, and third-party applications indirectly supported through OpenAir. OpenAir XML APIs…
-
NetSuite Admin Tip | Create Report in OpenAir Report Management Interface
Report module provides users who have the appropriate privileges the ability to create and run a wide variety of reports based on company's configuration. OpenAir provides a robust and flexible reporting environment. Users can choose the fields, which wish to see and the order in which they are displayed, along with the…
-
Connect P6 Cloud to Deltek Acumen Fuse
Anyone else know how to find the required information for these fields in Deltek Acumen Fuse for connecting to our P6 cloud database?
-
NS-OA Integration : Redirect error occurred when displaying OA on NS dashboard/PSA tab
Hello, I'm working on NetSuite-OpenAir Integration investigation now. After needed configuration, I could successfully display OpenAir module on NetSuite dashboard/PSA tab. However, some of my team member gets the following error message. This occurs after logging in to NS(OA module display on dashboard successfully…
-
Exclude invoiced expenses from getting considered in revenue containers
Hi, We want to exclude all the invoices with expense charges from getting considered in the revenue containers. Is there an internal switch to do this? Please advice. Thanks Mitali
-
Alert a user while running % complete revenue rule based on Approved/Planned hours, when approved ar
Hi, We have set a % complete revenue recognition rule , which calculated revenue based on Approved vs Planned hours. Now in one scenario when my actual hours go beyond planned hours, can system alert or restrict a user to run rev. rec. rule? This is so that the system doesn't create accrued revenue more than that is…
-
Custom Calculations - Excluding Generics
I have been experimenting with Custom Calculations lately, largely to get EAC and ETC calculations in my environment. In doing so, I build a Custom Calculation by using all Booked Hours from this Semi-Month to the Future as a date restriction. Since I have to multiply the Booked Hours by something, I use a Custom Detail…
-
Report sharing - different data
<p><span style="font-size: 10pt; font-family: Arial">When you create a report and share it with x users, chances are the data on the report won't match the data on your original report if the users you are sharing the report with have a different active filter set.</span></p> <p class="MsoNormal"> </p><p…
-
Filter set module override for timesheets
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">Is there way to restrict one's access to view only timesheets in a particular group?</span><span style="font-family: Arial"><br /> </span><span style="font-size: 10pt; font-family: Arial"><br /> If you have different groups, offices or departments, you…
-
Restricting Timesheet view using Project Stage access
<p class="MsoPlainText"><span style="font-family: Arial">In addition to only show the booked/assigned open tasks to the users, another simple way of restring what appears in a timesheet is to use the Filter sets for project stages. This requires active management from the project owners/admins to make sure that the…
-
Timesheet report for new users
<p class="MsoNormal"><span style="font-size: 10pt; font-family: 'Courier New'">Some clients that are already running the Timesheet status report experience some problems when creating users before they are actually working since they booked them in advance to a project.</span></p> <p class="MsoNormal"><span…
-
Reporting on retainers balances / project draws
<font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial"></span></font> <p><span style="font-size: 10pt; font-family: Arial">A common question for users using Retainers is how to build an accurate report that shows the projects and invoices to which retainers have been applied (each retainer draw) and…
-
Pausing/Suspending projects - Predecessors
<p class="MsoNormal"> </p><p class="MsoNormal"><span style="font-size: 10pt; font-family: 'Courier New'">Is there anyway to pause or suspend a project?<span> </span>This question comes up often.</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: 'Courier New'">For example, a client decides to delay…
-
Purchases module - billing arrangements
<p style="margin-bottom: 12pt" class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">On a recent email to our Support team, a client presented the following problem:</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">We use a travel company for our travel arrangements and…
-
Turning off calculation problems
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">How to disable the error messaging that occupies the top of the page for any project with a resource over-allocation on it?</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">If you are seeing these errors and would like…
-
Updating % complete on a task
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial; color: navy">A very common question is if I update a % complete on a project task, will it be picked up when running billing? Also are there any other implications that I'm not aware of?</span></p> <p class="MsoNormal"><span style="font-size: 10pt;…
-
Task Grid Customization
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial; color: navy">In order to customize the task grid layout, you need the Internal switch "Allow user customization of the Task Grid layout" enabled. This puts a “customize” link into the footer of the Task Grid page and enables users to add or remove…
-
Roll Up Sums for Creating Trendline
Hi, I have been trying to get reports to provide the column totals (for example if you do monthly reports) in order to create a graph with a trend line. But I cannot figure it out and was wondering if somebody experienced the same issue and can help out. Thanks! Dominique
-
Reporting on potential profit/loss of a project
<p class="MsoNormal"><span style="font-size: 10pt; font-family: 'Courier New'">You have the project, you have established costs for each of your users, entered the time required, etc.<span> </span></span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: 'Courier New'"> </span></p> <p…
-
Adding a Customer PO to billing rules
<p class="MsoPlainText">After you create a customer PO, though it is marked as active, it still doesn’t show up when you go to create a billing rule based on this PO, under the customer PO choices.</p> <p class="MsoPlainText"> </p> <p class="MsoPlainText">The first step to solve this is to go to the Edit Project form and…
-
Changing submitted expense report/timesheet
<span style="font-size: 10pt; font-family: Arial; color: navy">Depending on your company’s internal settings, a user might be able to edit a submitted expense report. If you are looking to prevent that, please contact <a href="mailto:support@openair.com"><span style="color: navy">support@openair.com</span></a> to enable a…
-
Future charges
<p> </p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">How can I invoice clients for future charges if I can only run invoices after time is posted? </span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";"> </span></p> <p class="MsoNormal"><span…
-
Impact of changing a customer name on a project
<p class="MsoNormal"><font face="Arial" size="2" color="navy"><span style="font-size: 10pt; color: navy; font-family: Arial">If you change the project name, the new name will be reflected in all associated records; both new and historical. </span></font></p> <p class="MsoNormal"><font face="Arial" size="2"…
-
User Profile - custom field
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">One of our users tried to create a text field in OpenAir that each user could edit, where the users could themselves write a short blurb specifying a brief profile.</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">The…
-
Unapproving an Invoice
<p class="MsoNormal"><span style="font-size: 10pt; color: #333399; font-family: 'Arial','sans-serif'">Unapproving an invoice is the first step if you are looking to correct hours,hourly rates or other fields on an invoice.You might want to print out a copy of the invoice first so you have a paper record, including the…
-
Timesheet duration
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial; color: navy">Some companies have different Time and Expense (T&E) internal rules for each type of employee to best fit its business practices. </span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial; color: navy"></span></p>…
-
CSV files to SQL server
<p>What is the best way to obtain the downloaded csv files (from the exchange tab) in a format that can be used to import data into a SQL database?</p><p>Though OpenAir does not support a direct load into SQL Server, it can be done. Here are some suggestions.</p><p>- Download the MySQL formatted file, load it into a local…
-
How to bill time to a generic resource
<p> </p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial;">Is it possible to bill time to a generic resource? Since generic resources cannot complete a timesheet how can this be done?</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial;"> </span></p> <p…
-
Ready for Recognition checkbox
<p> </p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">Why does this field show up as read-only?</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">The Ready for Recognition checkbox is a read-only NO on the task edit form in two cases:</span><span…