If you're talking about Support Cases, you can change the setup by going to Setup > Support > Support Preferences. You can also set up Case Rules and Case Territories to determine which employee will be assigned to each case.

What are you trying to get in your search again? You want a count of how many Customers have more than 2 Sales Orders in your system?

For future reference, is there somewhere I should be looking for all the CRMSDK fields when playing around with letter templates, other than trial and error with the datasource .csv? Look up "Using CRMSDK Tags" in the NetSuite Help Center.

In that case, try this: {MERGEFIELD "NLCOMPANYNAME" DEFAULT=" "} {MERGEFIELD "NLADDRESS1" DEFAULT=" "}

If you go the custom list route, you don't necessarily need scripting. NetSuite has a solution to filter a drop-down based on another drop-down's selection. Search for "Multiple Dependent Dropdowns" in the NetSuite Help Center for more info.

This is a longshot, but did you try using the DEFAULT attribute and putting a newline in there? Something like: <NLCOMPANYNAME DEFAULT=" "> <NLADDRESS1 DEFAULT=" ">

nlapiCommitLineItem is not required when using nlapiRemoveLineItem. Now that I think of it, if you're doing this on adding of a brand new line in validateLine, the line technically doesn't exist yet so it can't be removed. Try nlapiCancelLineItem() instead.

The 2009.2 release will expose Accounting Periods to SuiteScript, so you will most probably be able to do that. In the meantime I don't see any way of accessing the Accounting Periods. Is it something that can wait until you get 2009.2?

Did you try nlapiRemoveLineItem(type, line)?

Does it need to have a dynamic number of rows and columns? I've had to do this for a client once, and it involved an HTML form. When clicking Save on the record, I would fetch the values from the HTML fields and do whatever processing is needed. However, the number of rows and columns were pretty much static.

1) What type of script are you trying to do this from? 2) In scripting, generally you specify the search type yourself. How are you retrieving a list of searches from inside your script?

I just tested it in our demo instance and <NLUSERCOMPANYNAME> does indeed reflect the instance's Company Name found at Setup > Company > Company Information.

And where are you using the e-mail template? Are you clicking the Email button in the Messages tab, or are you using the "Customer Message" Text Area when creating the SO, in conjunction with the "To Be E-mailed" checkbox?

Hmm, looks like it's just not available. The following thread dealt with a similar example: https://usergroup.netsuite.com/users/showthread.php?t=14457&highlight=email+template+shipping We've done fulfillment e-mails with shipping method included before, but that was a fully custom e-mail in HTML with a script doing the…

The reason it's not working is because the search is referring to a Customer, and NetSuite can't make the jump from the Case to the Customer, even if there's a Company specified on the Case. One relatively quick solution is to "Show in Footer" the filter you created, and make it "Customer" instead of "Customer : Internald…

Hi Chris, 1) What kind of record is the e-mail template for? 2) Just a hunch, but did you try <NLSHIPVIA> ? 3) As for FOB, my guess would have been <NLFOB>. You can always try creating a custom field Free-Form Text with Store Value unchecked, and in the default value of the custom field put {fob}.

I don't see how you would insert an entire form into your e-mail and link it to NetSuite. Maybe an iframe pointing to a NetSuite Online Form? If that doesn't work, your best bet, as you mentioned, is simply a link in the e-mail to an Online Form.

You're not the first person with this request. Check out the following thread: https://usergroup.netsuite.com/users/showthread.php?t=6415 Right now, the best thing you can do is vote for Enhancement Request #124514.

What transaction type do you plan to send the e-mail for?

Depending on what you're trying to do with the merges, did you consider using a Scheduled Script with nlapiMergeRecord?

Did you mean "custom form" or "custom field"? NetSuite has a built-in HTML format editor, and it usually does a pretty good job unless you're looking for very complex HTML templates.

Could you give a bit more detail on what the search displays exactly, and how the custom record is linked to the Case?

I don't know why it's not available through a saved search, but if you actually load the Case record in a script using nlapiLoadRecord(), you will have access to the form ID using "customform". If you absolutely need it through a Saved Search, I would suggest filing an Enhancement Request with NetSuite Support.

Hi Jonathan, Did you try the "Description" field? Depending on the circumstances, that field usually shows either the Purchase Description or the Sales Description.

If you create a Saved Search with "Show Totals" checked and use it as a Custom Sublist on your Customer, you should see totals for Currency and Number columns at the bottom of the sublist.

The External ID field is indeed a perfect field for importing purposes. We used it when moving data from one NetSuite instance to another to store the old internal ID and thus keeping a link between the old and new instances. JMU's partially right about the external ID not being easily displayed on a form. If you want to…

Hi Erp, Try using the new nlapiGetFieldValues() function and use .length on the array that is returned by the function.

Why generate your subtab and fields in beforeLoad when you can just create them directly in NetSuite?

Hello ERP, Could you be a bit more specific? which fields in particular did you want in your custom record?

Hi Charlie, getFieldValues() should return an array of values. Printing an array doesn't always return what you'd expect. I'd suggest trying to iterate through the results: if(sodays != null){ for(var i=0; i&lt;sodays.length; i++){ nlapiLogExecution("debug", "Iterating Through sodays", "sodays[i]: "+ sodays[i]); } }