-
Custom Time Range
I'm wondering if through a scheduled script, I can have a time range automatically update. I can't seem to find any custom time range fields that are customizable in the scripting center. If there are any can you please point them out to me. Thanks
-
Leave accrual summary
Hello everyone I have a leave accrual summary report under the section: Advanced >> Timesheets >> Leave accrual summary. In the setting section there is a field: Include approved Absence notifications and Include projected transactions >>>> when I tick this box (include approved absence notification) would this give me a…
-
Self-implementing NetSuite-OpenAir integration : Has it be done before?
I'm looking for documentation on the NetSuite-OpenAir integration via self-implementation, does anyone have had success in doing this & the steps to do it? Thank you.
-
Booking Request/Resources Issue
Our company, which is small (@25 users) would like to implement the Booking Request feature. I have done so in our Sandbox environment and the feature itself works great. My question is this: We would like to allow ALL of our users to see everyone's bookings in the booking chart, but only allow certain users (based on…
-
How to author a specific report
All- looking for a way to run a report that tells me the status, across all projects, of a particular task. Specifically, I need to be able to run a report that says "all instances of this one particular task are "Completed On this date/are at this % complete", etc. for a particular date range. Any help? Thanks in advance
-
Modify Approved Bookings
Is there a way to allow a PM to modify an approved booking? The scenario is the PM creates a booking. The booking goes through a booking approval process where a Resource Manager approves the booking. As the project progresses the PM will at time need to change the dates for the approved booking. Once the change has been…
-
Fill in the scripting gaps please....?!?!
Hi all, Trying to make use of scripting successfully for the first time and can't help but think there's still a fair amount to do to the code below... Simply trying to populate a custom field (custom_217) upon saving the form with the sum of two other fields (custom_49 & custom_39). Any help would be brilliant!! Cheers,…
-
Scripting to populate start of Project Name with Job No & a space
Can anyone help write a script to populate the start of the Project Name field with the Job No. Currently, when creating projects, we take the Job No and manually type it into the Project Name field. It would be good to automate this upon saving so that it reduces the potential for errors when writing it in manually.…
-
SOAP API User Costs
Hi, I'm trying to get user details including cost rates out of OA, but am not having any luck - am I correct to use oaUser.cost to pull this out / is there an attribute that needs to be set? I've tried setting cost_lc_level to a couple of values with no luck... I've attached some sample code here to show what I'm doing to…
-
Has anyone done the "SuiteScript: Extend NetSuite with JavaScript" training course?
I'm looking to make use of a tiny part of what is covered in the course and was wondering if anyone's been on it and could help?
-
date format for SOAP API
I'm working with the Open Air SOAP API and i'm having trouble having oaProject start_dates display in the correct format. I'm passing in a date string in the API recommended format of "YYYY-MM-DD HH:MM:SS" with the intention of displaying the date as "MM/DD/YY" on the project's properties section. My tests, with or without…
-
NSW15 // May 4-7 2015 // San Jose
[ATTACH=CONFIG]n2287[/ATTACH] Register Now for the #1 Cloud ERP Event . Visit SuiteWorld for details.
-
NSW15 // May 4-7 2015 // San Jose
[ATTACH=CONFIG]n2285[/ATTACH] Register Now for the #1 Cloud ERP Event . Visit SuiteWorld for details.
-
NSW15 // May 4-7 2015 // San Jose
[ATTACH=CONFIG]n2279[/ATTACH] Register Now for the #1 Cloud ERP Event . Visit SuiteWorld for details.
-
NSW15 // May 4-7 2015 // San Jose
[ATTACH=CONFIG]n2283[/ATTACH] Register Now for the #1 Cloud ERP Event . Visit SuiteWorld for details.
-
OpenAir Enhancements
OpenAir Enhancement requests seem to go into a black hole never to come out. Any one ever actually get an enhancement request fulfilled?
-
Helloooooo? Is there anybody here?
Am I the only one using OpenAir? I feel all alone.
-
Where did the "Help" info go?
Trying to work out some issues with the OA service -- cannot find any "help" or "hints" on any of the screens, in the dashboard or in the admin area. Suggestions?
-
Scripting and date filters
I'm trying to use the date filter in a script. When I do the read the script just stops, doesn't even throw an error. Has any one used date filter in a read in a script? Here is my code: function setTimeOffRequestSwitch () { try { // check the bookings for this user. var newr = NSOA.form.getNewRecord(); var userid =…
-
Hide and Clear Permission Rules
Has anybody tried using the Hide and Clear option on the permission rules on Custom Fields? It seems to hide the field but not clear it, if the field has any info on it.
-
Audit field in downloaded raw data (Integration: Import Export)
Hello, I use the (Integration: Import Export) feature in the Admin section of OpenAir. If I download the raw data of whole tables, such as project_task_assign, I can also add the audit trail there. Unfortunately, it is not always clear to me what the different parts mean. For example: U,2014-01-28…
-
Data Visualization tools with OpenAir
Has anyone had success using data visualization tools with their OpenAir data? We are researching using Tableau to create more powerful visualizations and would like to talk to anyone who has had success exporting and mapping their data. Our plan is to build a data warehouse that can then sync with the data visualization…
-
JPEGs in Invoices.....
Hi all, Does anyone else find the JPEG functionality in the invoice template settings incredibly user unfriendly? We're trying to put a corporate logo as a footer but no matter how I upload the file (regardless of size), OpenAir seems to do what it wants to do and re-size it so its totally illegible or pixelated when…
-
Latency with OA today?
Is anyone else experiencing latency with OpenAir today? Just checking to see if it was more widespread or maybe an internal network thing... thanks!
-
Access to Timesheets -- not all but a subset
We have a requirement for certain managers to be able to see all time sheets for just their Project Hierarchy, or for users belonging to a specific Subsidiary or a specific Business Unit (Department). The View All Timesheets setting on the Role definition page won't do it for us (we use that for Accounting, HR, etc.). We…
-
New Here: Did Search: salesforce SSO and deep linking
I tried searching and I'm very sorry if I didn't find the obvious place where this is already posted. I'm trying to directly link to a project, after successful salesforce SSO authentication. Using the methods documented in the Salesforce integration setup guide @…
-
Scripting to Populate a Custom Field with the Product Value of 2 Other Custom Fields
Hi all!! Trying to use the new scripting functionality of OpenAir but need a steer in the right direction.... If I've got two custom fields, both of which are number fields (manually populated) and I want to populate, upon saving, a 3rd custom field with the product value (Custom Field 1 * Custom Field 2), can someone…
-
Hiding Project Fields based on User, not Role
Is there currently any way of hiding project fields at a User level rather than User Role. For example, a custom field on a Project Properties Form which I only want 1 user to see (without having to create a 'role' just for them. Thoughts??......
-
Tax locations for UK VAT
Hi All, We are trying to add tax calculations to expenses. I have added under Tax locations against federal tax 20% which is the current VAT applied in the UK. However if a £100 expense is submitted the tax calculated is £16.667 which isn't the way UK tax is calculated, it should be £20. Below is the explanation OA support…
-
More Scripting Help
I'm trying to write a script which will create an alert popup but I get an error when the script runs which states that alert is not recognized.