Point taken but basically nlapiGetNewRecord(true) under the covers would be no different from nlapiLoadRecord( nlapiGetRecordType(), nlapiGetRecordId()) if I am not mistaken? Thanks, Yang If that's the case, then yes, would likely be simple to just write a wrapper ourselves. Was thinking on your backend you may do things…

nlapiGetNewRecord() returns the record as it was submitted plus any changes to it made in user event scripts. What are you trying to do anyways and why can't you update the current record (nlapiGetNewRecord()) directly in the beforeSubmit script. Yang, I seem to recall that the beforeSubmit process performs user custom…

It isn't possible to throw an error that would block the submit operation without user feedback. They would always end up seeing the error message that prevented the submit operation. Thanks, Yang So then I presume the only other alternative would be an afterSubmit and delete the record? Is it possible to delete the record…

I'm not sure what you mean by "Silently error". What is the desired user experience? If the user is not allowed to register in the webstore because of a "silent error", how would they be able to check out? Thanks, Yang Hi Yang, Frankly, these are "registration" attempts (re the web store), as well as other online form or…

OK, needed to pass the full name for contact id (entityid), but worked. Curious of how this relates to duplicate ID errors or not. BTW, another undocumented field 'contactrole' to set the primary contact is accessible and works // sets this contact as 'Primary Contact' // (accessible via the 'primarycontact' field on the…

Thanks Andy and James. Never connected that the address was line items. Make sense once you mentioned it. then knew where to look (re: List Field Names). As for contact, yes did notice the entityid as required but was assuming this was automatically set. Perhaps passing it a null value so it creates automatically is…

Steve, the contactroles is a list of items on the customer record. You can access fields in this way e.g. companyRecord.getLineItemValue('contactroles','email',j) but ONLY for contacts that have access already. Contacts without access aren't visible... so you can't use the code to give them access. I have a case open to…

I would do something like the following: if ( invalid_condition ) throw error_message; You can throw anything in JavaScript including Strings. We convert whatever you throw into a String and as long as it is thrown from a beforeSubmit or beforeLoad user event script submitted from the UI, we display that object (String) on…

Just curious. Where does the error get thrown? There is some confusing text in the documentation. E.g. InsertLineItem inserts "above" the specified line item. That would suggest that you can NOT append. Thus count (which would be the maximum line) would be where you want to insert (rather than count+1). Count+1 would look…

Minor inconsistency right now between the UI and SuiteScript. In the UI we should all possible associated contacts and let you assign access to anyone. In SuiteScript we only return associated contacts that have already established login access with this customer. Feel free to enter a case/issue for this. Thanks, Yang…

...and as long as it is thrown from a beforeSubmit or beforeLoad user event script submitted from the UI, we display that object (String) on the error page. Thanks, Yang Thanks Yang, the script would only go when the transaction has been approved which is usually after it has first been created. However, I was going to do…

running into same problem. I have a string field on a transaction that identifies a "common" company name (not ID, just the string interpretation of the company name.) I want to be able to search existing customer records to see if this customer (company name) exists. I've tried several different approaches ('entityid',…

My Suite Script is attempting to update a transaction custom column field. The field has a value equal to null before the update. The value I am updating the field with does not stick. I have pasted a snippet of my code below--with some comments on what I am seeing when I run it. salesorder.setLineItemValue('item',…

Hmmm... we don't yet validate invalid filter operators but the problem is that you are using the 'equalTo' operator with a text filter. Try using the 'is' or 'contains' filter instead. Thanks, Yang Hi Yang, thanks. The 'is' worked, but I had more problems with columns not being the correct fields. Took me a bit to figure…

worked for me, same problem. 1. Get rid of submitrecord if using beforeSubmit. 2. Make sure fied is the ID and not the text name. Other than that, the code looks fine.

It will be anywhere from April to July depending on what release group your account is in. Thanks, Yang Seems we're in the last group all the time (at least to-date). Anyway to get bumped up the food-chain?

Unfortunately, setting a non-stored hidden field in a beforeLoad script is the only way to pass this information along to the pageInit script. Please enter an enhancement to this effect with details on how you would like this functionality to work. To answer your 2nd question: We have enhancements coming in our Spring 2007…

I created a custom body field in the Estimate screen called 'custbody_totalprofit'. Whenever a new line is added, the Total Profit is calculated. I have flagged this field as 'Save Record' so I assume it is saved in the database somewhere. Now I want to retrieve the value so I can display it on the Sales Order related to…

Never mind, found it. Was passing the text name rather than the ID. Always trips me up...

Thanks for trying it! When you say it worked, do you mean it successfully save the customer field or that the code worked? I did take out the submit, but I still am unable to save the record with the customer ID. The field I am sourcing is entityID. Actually, I was attempting a very similar process, trying to save a…

We have a similar need which perhaps the summary unit would help us with but maybe someone has some optimization that can help now (Yang, is "Spring 2007 Release" 11.5 or 11.0.6? Hopefully the latter since I'm told 11.5 is more like 3rd or 4th quarter 2007). Anyhow, we have sales orders which the standard "customer" field…

You are correct. Adding a "mainline" = "T" search filter should limit the results to just a single result per transaction. Thanks, Yang Excellent! I've seen this mentioned before. What does mainline represent? the root record?

No this information is currently not available via SuiteScript. Please enter an enhancement request issue for this in order to help us prioritize it. Thanks, Yang Accessing company info would be helpful as well as the ability to add custom fields to these records/forms. For example, to create some additional custom…

Try calling nlapiGetFieldValue(fldname, true). We had to restore the semantics of nlapiGetFieldValue(....) and nlapiGetFieldText(....) for multiselect fields and instead add support for returning the results in an Array (only available for multiselect fields). Otherwise you get a CHR(5) delimited String which is the old…

Note that I found that using nlapiGetFieldText to extract the selected text values (versus the value values) comes back as a comma delimited string NOT ascii code 5 delimited. -Steve

Has this been resolved? I am trying to email using CC and continue to get 'Unexpected Error'. Anyone? I have successully executed the nlapSendEmail API when I only pass a 'to' email address. Whenever I pass an array for 'cc' (or a string), it errors with 'Unexpected Error'. Can anyone confirm? Thanks. -Steve

Case # 510127 Thanks! --Tim Has this been resolved? I am trying to email using CC and continue to get 'Unexpected Error'.

I'm sure you already thought of this, but as a workaround could you perform the second attachment via nlapiAttachRecord()? Actually... I'm not sure how you would get the id of the new message. Sorry, bad suggestion. I will still post it though because nlapiSend*() should return the id of the record it just created. Not a…

I have a situation that I'm not sure how to handle. We are sending out an email to the primary contact of a customer. Using the attach record to messages parameter definitely works, but I can't seem to connect to BOTH the contact record AND the company record the contact belongs to. Since both are 'entity' records, the…

BeforeLoad scripts don't fire when you navigate to an online form (only the actual case record). Your best bet would be to have them publish the internal URL for the online form which allows you to parameterize the URL with values that can then be used to default in fields on the online form. There was a POST a while back…