3943809 Green Ribbon

sklett, I like your suggestions as well. I just found a preference for this! Home > Set Preference > Reporting & Search > Show List When Only One Result This is a global preference. I think it would be helpful to have a per saved search override.

Vote for Enhancement 142302 to be able to search sales territories. Without this you'll never be able to reassign leads through scripting (unless you create your own custom record to track members of a sales territory of course)

We also are looking for a way to automatically reassign leads untouched by sales rep after a certain time to other sales reps in that territory. I don't mind using a script, but I don't see how you can access the list of sales reps in the territory. Does anyone know if this is accessible some how, or is this an enhancement…

Wonderful, will you elaborate on the functionality that will be included in the Q2 release? This will be helpful for planning purposes.

Thanks for the suggestions, but I am hoping for something in the footer that could be less confusing. When you receive any marketing emails from NetSuite you get a message such as the following tagged to the bottom of your emails: Click here or reply to this e-mail with 'unsubscribe' in the subject to unsubscribe from this…

Is it possible to have each email campaign attach a record to the customer record so that when we pull up a customer we know what has/has not been sent to them?

Just another thought for the Enhancement... It would be great to be able to see bulk marketing mails attached to a customer record so that when viewing a customer record it is apparent what has been communicated.

I called support and they told me that they were upgrading the databases and it was impacting my ODBC? This sounds a bit off. Case 685145

I tried this with both drivers.

It took me 6 minutes to select the top 10 cases. Any ideas why this takes so long now?

Thanks for the reply Malin. We'll have to rethink our use of ODBC if there is no way to stop a user from seeing everything.

I found another issue with the ODBC. I am doing a simple query: SELECT * FROM suppport_incidents WHERE case_number = 165983 I get no results even though that case number definitely exists in the UI. Also, I can pick another number and it works. Case 685967

I believe the caseissue view is for the case issue list that is found in the Support Case Record. I hoping to gain access to our Issue Management Record. Any other thoughts? Will someone from NetSuite chime in please?

We purchased the ODBC connection on the premise that we could access the Issue record. We were told that all records were exposed. Now that we have purchased a pricey product, it appears that the Issue record is in fact not exposed through ODBC. I've been trying to get Support to get this fixed for over a month. It is…

It appears that getdate returns Pacific Time, but all times are recorded in UTC. Is there a way to do a getutcdate? That function specifically doesn't work, but I'm looking for an alternative.

Just a little frustrating again. I just got off the phone with support a third time regarding not being able to find the Issue Record. (I was supposed to get a call back from someone who knew what they were talking about after the last call). We just purchased the ODBC connection. One of the main reasons we wanted it was…

I setup a link server in SQL Server 2005, but it was very slow. A query I was able to do in seconds (returning only 22 rows) with MS Access took over 25 minutes in SQL Server with a link server before I killed it. Any ideas why Access performs so much faster than a SQL Server connection?

A scheduled mass update? How long to close them probably depends on your sales cycle, but I would reference the Date Last Modified when determining which to close.

See this thread... https://usergroup.netsuite.com/users/showthread.php?t=17307

Option 3. I would like something similar to seeing inactive records by adding the "+" to the end of a global search.

One thing I have found helpful when assisting others with Saved Searches is to have the user email me the URL of the page in question. Then there is no need to guess and find the right variation of the name. Also, you don't have to worry if it will show up in the global search or not. It saves a lot of time for everyone.…

For educational purposes, is there an example when/how i would use TREAT?

Saved searches are powerful, but wouldn't it be great if we could have a Advanced Saved Search Editor where we could see/edit the underlying SQL? I'd love to be able to do subqueries, joins (joining tables not directly connected to the saved search type), etc. ODBC works great for certain situations, but I'm constantly…

Thanks Evan that worked! I tried to_number without success before, but now it makes sense why not.

I believe you only get this option if you have Publish Saved Search ability, not just running the search.

Evan, I'm also eagerly awaiting this enhancement. Sounds Great!

Thanks for the suggestion. I believe our Tax Item/Groups are setup. I'm wondering specifically if it is possible to add custom fields to this record. Thanks,

We had this problem, and ended up resorting to a client and user event script to verify it was unique before save. The user event script handled every situation including web services, but the client script helped the user know they had a problem before they got the dreaded Script Exception screen.

When the permissions are set right it will definitely work. We do this with some custom customer centers.

Just for clarification, you can only have 5 scripts per event (i.e. before load, before submit, etc.).