-
Greater than or less than in Formula Field?
I want to create a formula field that compares two custom field amounts and shows the lesser value of the two. So if amount1 is less than amount2 the field shows amount1. Does anyone know if there is a way to use less than or greater than in a SQL expression? I can't seem to find one. Thanks
-
Sales Order Confirmation to NetSuite
Hi, We used the following code to get the Sales Order details based on TranID from NetSuite using webservices. TransactionSearch tranSearch = new TransactionSearch(); TransactionSearchBasic tranSearchBasic = new TransactionSearchBasic(); SearchStringField entityId = new SearchStringField(); entityId = new…
-
need help with script to validate opportunity status
Hello, We are about finished with our implementation and are looking for any help out there with a simple script. I would like to (ideally) : 1) Check the status of an opportunity prior to allowing the user to save the opportunity. 2) If the opportunity status is set to "closed" - check if a field is empty (in this case…
-
Calling on C# experts
Dear all, I have the following piece of simple Java code that I'd like to convert to C#. Can anyone help please? Customer cust = new Customer(); CustomFieldList myList = new CustomFieldList(); cust.setCustomFieldList(myList); Thanks in advance. Terry
-
Search for Customer poNum brings back null values
Taking a short cut here guys on forum versus looking for info in docs and other avenues. Tight time contraint. I am issuing a customer search on poNum with the poNum SearchStringField operator as "@is". How do I prevent records with nulls in the poNum from being returned? I just want to retreive the record(s) with the…
-
Login Issues with Test Account
Hi everyone, I am going to do some massive testing for an external application so I asked my rep for a testing environment. They gave me (what I guess could pass for testing) a basic account used mainly for prospective customers. I have downloaded their sample program in .Net and I can't seem to find out a way to login to…
-
3rd Party Project Managment Software
Does anyone know of a 3rd party Project Management software package to integrate with Netsuite? Thanks, Dale
-
Uploading sales order as a cash sale
Is there anyway to specify which form you want to use when importing a sales order? I would like to specify that the order was a cash sale so that after fulfillment the bill is created as a cash sale rather then an invoice.
-
Problem Using Aqua Data Studio with ODBC Driver
All character data is returned as "(null)" with Aqua Data Studio 4.7. Integer data returns OK. Simple example: SELECT * FROM Locations RESULTS: ADDRESS ADDRESSEE ADDRESS_ONE ADDRESS_TWO ATTENTION CITY COUNTRY FULL_NAME ISINACTIVE LOCATION_ID NAME PARENT_ID PHONE STATE ZIPCODE ---------- ------------ --------------…
-
invalid session fault
unable to maintain a valid session with .NET. it keeps timing out every few operations. i've set the Timeout to various intervals (it's currently set to 10 hrs). i've changed CookieContainer(2) to CookieContainer. made sure the account number was in the header of the cookie. i'm very frustrated that netsuite makes these…
-
timeouts?
i keep getting timeouts now. i remember having trouble with that before, and it was because i was missing a cookie in the SOAP header, so i added this code: Sub setCookie(ByVal strAcct As String) Dim myUri As Uri = New Uri("https://webservices.netsuite.com") service.CookieContainer = New System.Net.CookieContainer()…
-
Session Timed Out (with .NET sample)
I am working on the sample application, and I know some people have had problems getting it to run, but I haven't been able to figure this one out. The login works fine, but trying to perform any operation causes a SOAP invalidSessionFault with a session timed out code. Am I correct in thinking this is probably a cookie…
-
Update Currency Exchange Rate
Hi, I'd like to update the exchange rate for a currency nightly via WebServices. I know that the data is in the Currency list. But can anyone help me with how to access this list and update it from webservices. I'm using .net to access the webservices if that helps. Thanks in advanced. Mark Hall
-
Last modified date for customer view/table?
It looks like the last modified date is not available on the CUSTOMERS view. This is a cruical requirements for us to be able to only retrieve records that have been modified recently. Is this an oversight? Can this be added to the view? I also noticed that new fields made available in v11 in the customer record such as…
-
Can you customize the User Note Form
if so - how? thanks
-
How do I create a purchase order?
I don't see any way to create a purchase order via Web Services. It is not in the documentation and not in the web service reference map (that I can find). Am I missing something? Why would sales order be included in the API but not purchase order? Thanks, Ty.
-
salesrep woes
when i try to add a customer record with a salesrep, i get an error saying i don't have permission to, that it's available either only through adds or only through updates, or that an associate feature's disabled. i'm using WSDL v2.0. i'm using the same code i always used to use, and it always used to work then. i…
-
Changing behavior of the WS without notice
Hi, I have with many moments gotten changes in the WS so that existing code that works stop working. This is a little bit annoying when we have live applications that kind of depend of that the WS is not changing the behavior. How can I be updated as soon has been made? This time, all SalesOrders has been working fine.…
-
Risk mitigation with NetSuite updates
We have observed at least three occasions where automatic update revisions to NetSuite (AU release) has modified the behavior of the web services API, and caused our solution to operate incorrectly, or not at all (for example "tax codes on opportunity itemList v11", "sales tax on opportunity itemList v11" postings +…
-
Search for Customers not working
This could be probably related to the release last night. A simple search for customers is returning the following error. We have changed the search record (CustomerSearch) to have NO search fields, and it still returns the same error. Even the sample app returns the same error. Needless to say this is super critical for…
-
Multiple Sessions
Hi, I have detected that when using WS only one session can be active at one time. And we have this running on different servers, with the same username and password. At some times, the records are not pushed to NS because of…
-
Sales
Best group member, Right now I am using WS to push sales into NetSuite. However, that is not so convinient because it is put as SalesOrder and that require some manual steps (maximum status to set is pendingFulfillment). I was hoping that WS would support Cash Sales, but unfortunally it does not. What is the other…
-
Want to add a URL to intranet site
Is there a way to add a URL that calls out to another webiste to the intranet site. The example is a I have the intranet site in NS that I want to put links on to call to our internal site instead of posting up all the information all over again. Is this possible I cannot see an easy way to do this. Thanks.
-
New ODBC Driver Problems
I seem to be able to crash it at will simply by asking for a lot of data:( I can do this with Excel and Access on 2 different PCs at 2 different locations. Almost acts like I am crashing the NS server or something. An hour or maybe a couple of reboots later (can't tell which) it seems to work fine again on small tables. I…
-
custom code caching
i first noticed this probably saturday, after netsuite went down overnight for maintenance. before, when i needed to replace the code on a form, i'd just replace the file in the File Cabinet and reload the form. this doesn't work anymore. i have to either edit the form and rename the file, or replace the file and log out…
-
Writing to date fields via script causes error if format is wrong
I just noticed that when you write to a date field via client-script, the format has to match what the user has set for a date format preference (e.g. mm/dd/yyyy, dd-mmm-yyyy, and so on). Now I currently write to a date field via clientscript passing a string value in the format of "mm/dd/yyyy". Maybe I'm doing something…
-
Custom Field...sourced from related trans
This probably isn't as difficult as I'm making it, at least I hope not. We've had several customer requests for a common link (info) between the packing list and invoice (for matching purposes). Our Packing List shows the "Item Fulfullment No" on it and I'd like for that same number to appear on the invoice generated from…
-
Inserting a new line item
Hi, I've been trying to insert a new line item from javascript. I can get the item onto the form, but I can't get it to actually "Add"/commit the item. nlapiSetCurrentLineItemText('item', 'item' , itemValue); nlapiCommitLineItem('item');
-
Searching contact records using text with an imbedded space
I've hacked Evans example to look up an internalid of a contact using their name. It works fine as long as the search string does NOT have a space in it. If it contains a space the system throws a SQL error. I've tried putting escaped single and double quotes around the text, but the system then threw a different error…
-
Custom record not valid in Customer Centre
I have a client side script on the Sales Order (External) form that is used in the Customer Centre. This script searches a custom record type using nlapiSearchRecord and I receive the error "nlapiSearchRecord: type argument customrecord15 is not a valid record or is not available from your account. ..." When I attach this…