-
Line Item Quantity (and Commission Problem)
Could anyone provide an example of a script that would require that a line item quantity must be >= 1 and if not, pop an error message? Reason: If a sales rep (on transaction line item commission) creates an invoice and fails to put a Quantity on a commissionable line item (leaves it blank or 0) and enters a Custom price,…
-
Sourcing from list of established Currency Exchange Rates
My company has a need to show our Invoice total (which is in USD) in GBP (for taxation purposes for our GB offices). I have custom fields set up for the exchange rate, and the calculated value. Everything works great, except I have to manually enter the exchange rate. I've been trying to make it so that the exchange rate…
-
FireFieldChanged??
I have some code that adds some fields together. I want to update the total everytime they tab out. Function AddThemUp(){ var ADV_Registration_Bud = (nlapiGetFieldValue('custevent_adv_registration_bud')=="") ? 0 : parseFloat(nlapiGetFieldValue('custevent_adv_registration_bud')); var ADV_Facility_Rental_Bud =…
-
Question on Tracking Numbers in Item Fulfillment Records
Hi all, I have two questions: 1) I am creating a ServerScript to send out tracking emails when an Item Fulfillment occurs. I am able to pull out shipping address info, but I don't know how to get tracking numbers. Can someone show me the code on how to get tracking numbers? 2) This is my first time doing scripts in…
-
Mixing WS with online case forms
I'm trying to build a custom web site using web services, and a 'New Case' form in this web site. I've built an online case form with ClientScript code attached to it. Here are the steps user follows to get to the 'New Case' form: [LIST=1] [*]Log in the custom web site using NetSuite credentials - log in is successful,…
-
Getting Data from Password Type Custom Fields
I'm extracting a record from NetSuite that contains a custom field of type Password. When looking at the data NetSuite has returned for that field I only see "(Encrypted)". Have I missed something? Or should I move the data into a different type?
-
Deploying a script
Hi, When I am creating a Server Script for the first time ( or editting one ), there are 3 fields in the Script Box: Before Load Function Before Submit Function After Submit Function What do I put in the text box following those labels? Thx in advance -Steve
-
Disable Mandatory Custom Field Validation
how does "Disable Mandatory Custom Field Validation" under Web Services preferences work? i tried making a custom field mandatory at the field level, and not mandatory at the form level, and NS throws me an error telling me i need to specify a value for that field when i try to add a new record of that type using web…
-
Get logged user name using web services
Hi all, as with my previous thread, my apologies in advance since I'm a newbie in NetSuite platform. I was able to build a successful custom login page using .NET and NetSuite Web Services. Like most restricted areas on web sites out there, I'd like to show the logged user name and role name, and eventually a drop down box…
-
Not sure what I'm doing wrong
I'm sure I'm doing something wrong, or missing a step, but for the life of me, I can't figure out what it is. I'm following the Customization PDF that is available through "Help"... though I know it is only for 10.6, I don't believe the 11.0 version is ready yet. Pages 85-86 talk about "Working with Custom Records." I…
-
Problem with item fulfillment cust field
I have a transaction column custom field of type list/record that points to a custom record. It's appears on sales orders and item fulfillments. On the sales order line item, the drop down for this custom field shows the available instances of the custom record as well the "- New -" option to create a custom record on the…
-
Question on getText method of nobjSearchResult
Hi, I am trying to use the getText method with nobjSearchResult. There are two parameters to that method. The first is the "name" of the field which I have no problem with, but the second is a "join" field. What do I put in as the second parameter join? Thanks in advance. Steve
-
client suitescript + web services
what's the purpose of custom code when using web services? events do seem to fire (when you return false in a Save Record event, an "unexpected error" is thrown via web services--when you return true, this doesn't happen), but i don't see what the point is. when you use nlapiSetFieldValue to set the value of a field, it…
-
inactive field values
hi, when you use getSelectValue on say, employee_department, you get the list of valid departments. But there are also some inactive? deleted? departments that are not shown -- but some employees have those as their departments. (of course, those employees may be inactive too.) Anyway, is there a way to get the inactive…
-
Issues When Searching...
I am working with the 'search' operation using the NetSuite web service and I am encountering some unexplained errors when attempting to access records. I have written my application in PERL/CGI using the SOAP::Lite module and can successfully connect and communicate with the application using other functions (like login…
-
Session STILL Times Out Right Away
Issue Number: 107698 Type: Problem Severity: S1 - Blocking Status:Released I still have the same problem, the Released fix did not appear to resolve the issue. This Web Services application worked fine prior to the version 11 upgrade, no changes have been made to this, the only thing that has changed is the upgrade to…
-
Can't set Custom Customer Form to preferred
We created a custom Customer Entry form and set it to preferred, however it only defaults correctly to this form when creating a New Customer Record. When creating a New Lead or New Prospect, the default is still the Standard Customer Form. Am I doing something wrong? Is there a different form for Leads and Prospects that…
-
Accessing Calculated Values in Client-Side Scripts
I noticed that calculated values such as "totalvalue" are listed as available fields for inventory items. However, when I try to get the value of these fields (Client side), I always get "undefined". I can get at most other fields. Suggestions anyone? Mark
-
Custom Records Search errow with Netsuite v.11
Hi, We have implemented a customRecord search using webservices that worked fine with Netsuite v.10.6. We have recently been upgraded to Netsuite V.11 and the custom records search no longer works. However customer, employees search works fine. .NET Code snippet below: CustomRecordSearch customRecordSearch = new…
-
Custom code for line items
Hi all, It appears that after V11 the operation to loop through each single line item no longer works. Please refer to the following code below: Function saverecor() { for(i=1; i<= nlapiGetLineItemCount('item'); i++) { //nlapiSelectLineItem('item', i); var therate = parseFloat(nlapiGetCurrentLineItemValue('item', 'rate'));…
-
Sales Order
Hi, Is it possible to set a SalesOrder to FULFILLED in NS WS? I know I can set it to pending fulfilment, but I would like to make it fulfilled. /Peter
-
Can't save changes to Form
Since the release Monday night, I can no longer save customizations to my Customer Form. When I click save I get the error: Notice This record cannot be deleted, because it is referred to by other records. I am not trying to delete the record; I am trying to save it. I have JS code running on the form; it has been running…
-
Adding billable time
We use Netsuite to log support calls, and I've done a little scripting, and it all seems to work well. Our engineers add time to a ticket, and can opt for billable or not. How do I check the contents of the "billable?" tickbox, and the time added. One of our guys entered 10 hours, instead of minutes, and I was hoping to…
-
Using Email Templates with nlapiSendMail(...)?
Hi all ... Has anyone had luck sending the text of email templates with the nlapiSendMail(...) function? Is this even supported? Would be handy not to have to develop a second set of email templates to be used in SuiteScripts. Thanks, Dave
-
Custom Records Query
Is it possible to query a custom type and retrieve all of the records for it? I see in the documentation that you can add and update custom types but I can see no examples of queries for them. I'm not looking for anything fancy just a means to extract all the records from a table. Any pointers would be appreciated
-
Custom Code to Copy Line Items to Custom Body Field
Hello, I am working with a new script to copy line item names to a custom body filed so that we can see the item name in a custom transaction search using the "Status" Item Fullfillment: Picked, Item Fullfillment: Packed, Item Fullfillment: Shipped. We need to be able to see the item name being ordered in each of the…
-
Liimit Custom Record to one
Is there a configuration for implementing a custom record that contains a maximum of one record (in other words you can't add 'new' record)? I want to setup a custom record for a number of company preferences that I can then source from on other records as defaults. Thanks. -Steve
-
Customizing Login Page
Hi, I am not happy with the Netsuite branded login pages (Netsuite logo, url, and subsequent error pages - e.g. retry, session timeout, etc). I want customers to login from our website using everything branded to us. Once logged in I don't care as much but before logging in it needs to be our look and feel. I was told I…
-
Question on setup
Hi all, I am trying to create and deploy scripts for the first time. In creating or editting serverscripts the documentation says that I need to create a script file ( which I did ) and I need to create a library file. I am not sure exactly what a library file does. Can u help me with that? Also in the form for creating a…
-
currency rounding up
does anyone know how to round up automatically the item sale price in my web store across £ $and Euro so a client when switching to there home currency sees a whole £ $ or euro price ??