-
Getting the opportunity system notes
Hi All, Apologies for such a remedial question but I am having real difficulties in trying to link the opportunity to either the notes system of notes system custom. I have the Enterprise Reporting View manual but this is hardly helping me at all. Thank you, Si
-
Parameters
I am using : as the parameter marker (e.g. WHERE Bill_Batch = :Bill_Batch) and receiving a syntax error. What is the correct parameter identifier for the new ODBC driver.
-
Query Customer records remotely.
We have a Windows 2003 server wherein a customer enters their name. Once they have entered this, I need to query the NetSuite database to make sure this customer exists prior to moving to the next step. What are my options for doing a real-time query of the customer record from a remote machine? Thanks in advance.
-
Is an RMA record type the same as the PO?
Hello All, I am creating some suite script on the item receipt transaction and have been trying to figure out how to determine when the item receipt was created based on a PO or from an RMA. I take the internal id of the createdfrom transaction and then load the record casting it with the purchaseorder type. It was my…
-
nlapiloadrecord for custom record
I cant seem to load a custom record from a user script. I have a custom column that I look up, which returns an internal id of the custom record. I need to get at the text value of that rather than the internal id. How do I do that? In the documentation it says you can load custom records but doesnt explain how and each…
-
Removing Tax ID from Sales Slips
Hello, I need to remove "Tax ID #:____" from all sales forms and email notifications to customers. Does anyone have any suggestions for quickly removing this tax info from all forms and emails. Thank you. Rapid
-
Custom fields on Tax Item/Tax Group
We would like to create custom fields on Tax Items and Tax Groups. It doesn't appear to be possible. Will someone verify this one way or the other? Thanks.
-
Customising the Item Fulfillment screen
I guess this is a question for one of the NetSuite employees who frequent this group, but what I’d like to know is if there is a plan to make the Item Fulfillment screen customisable at some stage in the future, specifically with a view to adding custom scripting (as per Sales Orders, etc., etc.) to it. We’re trying to…
-
Using Multiple Criteria with a CustomRecordSearchBasic
CustomRecordSearchBasic srch = new CustomRecordSearchBasic(); // Define custom record type RecordRef recordType = new RecordRef(); // Set record type internal id recordType.internalId = "11"; srch.recType = recordType; // customfield search SearchCustomField [] scf = new SearchCustomField[1]; // Transaction Reference Id…
-
Problem while creating CreditMemo
Hi, When we are trying to create a credit memo (Webservices 2.5 version) it is giving the error as Error Code: INVALID_KEY_OR_REF Error Message : The Specified key is invalid. I have given the code below. this.login(true); CreditMemo cmo = new CreditMemo(); cmo.altHandlingCost = 1000.00; cmo.altHandlingCostSpecified =true;…
-
Updation of Customfield
Hi All, We have created a custom field in salesorder.When we try to update that custom field it is giving the error as Error Code: INVALID_KEY_OR_REF Error Message : The Specified key is invalid. I have given the code below. Can u pls help me out where i did wrong SelectCustomFieldRef sel =…
-
Performance issues
Hi, We are trying to do some performance testing and have fairly consistently come up with the following during peak hours on a test account: For 200 records (sending 20 at a time), we are experiencing ~190 seconds in calls to netsuitePort.updateList(updatedCustomers). We have the following questions: (1) Is the…
-
Set preferred form based on a user's role or sales division?
we have two sides of our business; Retail & Wholesale Each side has different custom transaction forms. I would like to show the preferred form for the business division based on the role of the user or if possible some other criteria. I havn't flushed out the whole plan yet, I just know I would like to show employee x, y…
-
entitystatus returns Null??
I'm getting an unexpected result in my SuiteScript. I'm trying to determine the entitystatus of a record, but no matter what I try I get null. This is a mandatory field, and I have verified that the record has a status. A sample of the code: currentRecord = nlapiGetNewRecord(); // Get the Lead Status var clientId =…
-
Commit line using serverscripts
Help! Help!! I have a serverscript to create a brand new invoice when an invoice fulfilling certain conditions is saved. I get the following error: Script: invoiceAfterSave Error: USER_ERROR You must enter at least one line item for this transaction I'm quite sure I'm missing the code to commit the new line - can anyone…
-
adding text information on invoice
how to get extra information standard printed on every invoice as footer (a standard footer so not a message to choose, but a standard text which gets printed automatically instead of using partially preprinted paper... anybody has a clue?
-
Restrict access to certain forms
Does anyone know a way to restrict access to certain forms we use. I understand I could make a form preferred, and disable the Custom Form field. Unfortunately, I need to provide access to a few forms for certain roles, and then restrict a few others. I would rather not have to use a client side SuiteScript because it…
-
V2.5 - Accessing knowledge bases
Hi there, in the 2.5 version WSDL there are operations like TopicSearch, which regard to knowledge bases. When trying to perform a search using an employee role... : <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Header> <platformMsgs:searchPreferences…
-
Logging a script on a record (w/ note)
Hi - Does anyone have a simple note-creation function they'd like to share? I'm realizing that automated edits to records should really be documented as such. Right now, the change gets noted in the system notes, but there's nothing (at least that I can see) to indicate that the change was done by Suitescript. I'd like to…
-
Anyone seen this Error: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed?
Has anyone encountered this error on attempting to execute a simple query over the Netsuite ODBC driver? I have one Win2k Server where the driver works well; no errors. But on attempting to use an installation on a fresh 2003 Server and a fresh 2k Server (using ASP classic), I get this error message: "Microsoft OLE DB…
-
**** CHARACTER LIMIT in TEXTAREA HELP *****
We use a textarea field to get "Gift Card Message's" from our customers. The problem is we only have so much room to print on in the gift card, but no way of limiting the number of character's the customer can enter in the field? It's the old if you give them an inch they will take a mile. With the holiday rush approaching…
-
Field change function on custom column fields getting ignored
I am having a strange problem with scripts on the Expense Report form. There are a couple of custom column fields on which I need to code a field change function. E.g. if (name == 'custcolproj_customer') { alert("TEST"); .......... } but the code is just ignored and I don't even get the TEST alert. I also noticed one other…
-
TransformRecord
Hello I am trying to Transform SalesOrder to Purchase order (on saleorder creation) function AfterSubmit(type) { if (type!="create") return; var so=nlapiGetNewRecord(); var po=nlapiTransformRecord("salesorder",so.getId(),"purchaseorder"); nlapiSubmitRecord(po); } I am using the code avobe but failing so fare with…
-
forcing scheduled script execution
Hi - Hopefully a stupid question: is there any way to force a scheduled script to execute "now"? As far as I can tell, it's only possible to schedule it to execute in half hour incremements, greatly complicating debugging since I have to wait until the next half hour slot. Thanks! --Tim
-
How to add last update to Case Assignment Notification
Hi, Im trying to update the template which produces the email sent out when a support case has been updated. The bottom line in my Case Assignment Support Notification template shows the following - <BLOCKQUOTE> <P><B>Message History</B><BR><FONT color=#666666><NLCASEHISTORY> </FONT></P></BLOCKQUOTE> How can I get the last…
-
Comparing Custom Password field to an Employees password
When capturing a Cash Sale, if an employee enters a discount above a certain percentage, we went the supervisor to approve this Cash Sale by keying in their password. So on the Cash Sale form I want to compare a custom password field with the Supervisors NetSuite password. Is this possible or will I have to create my own…
-
InvalidSessionFault - requests on session
Hi there, I was just running a web services test - we login to netsuite and then spawn 2 threads that attempt to retrieve all customers. This test was to check that we could have two requests running at the same time in the same session. However, I'm getting the following error:…
-
Make an Item behave like the Discount Line Item
When one uses the Discount line item, a dollar amount or percentage (plus or minus) can be entered and it will calculate an amount based on the line item (or subtotal) immediately above it. I need to create a new Service line item that would behave in the same manor (i.e. enter a percentage and have it create the amount…
-
Web services permission on non-general access roles
Hi there, please correct me if I am wrong. I believe in version 11.0.3 we had the Web Services permissions for the Employee Center role, for instance, which means our employees could login using web services. Now in v11.0.4 the permission is gone, even in custom employee center roles! Which means our employees can't access…
-
Cannot write to PO Rate field
Hi, Seems to be an issue writing to this field on an invoice form. This is a simple client side script which is executed upon save record. Here is my code: function saverecord() { var comm = nlapiGetFieldText('custbodyagentcommtrans'); comm = parseInt(comm)/100; for(i=1; i<= nlapiGetLineItemCount('item'); i++) {…