User_KC8S1 Red Ribbon

I'm also looking for this. I would like a customer to contact their sales rep with an issue, sales rep enters case (so we can track what problems are the most common) - if sales rep can't resolve case then an RA (for service or repair - if that exists) would be created. This is the last big hole in our netsuite system that…

In my use case the System Notes turned out to be a flawed source for accurately filtering the search because a claim could be set to an "open" status multiple times. For example: [LIST] [*]1/1/2010 : Set to Open [*]1/18/2010 : Denial Received (closed) [*]1/19/2010 : (researched) [*]1/20/2010 : Problem resolved, set to Open…

enhancement 179214 - Home > Dashboard > KPI > Setup > To have a "Less is More" tickbox just like in a KPI Scorecard. :(

It is related but seems to deal with the scorecard which we aren't using. I'm just trying to get this to work on the regular KPI portlet. Thanks for the link though, I'm using it to explain to support what I want to achieve.

Thanks for the reply Evan. Just to make sure I have this correct: I would need a "Date Opened" and a "Date Not Opened" field? I can't accomplish what I want with the System Notes join on the Status field?

So I gotta get in and out quick before my users realize the amazing powers they have been granted and destroy my entire installation! :p Thanks for the comment.

Hey Ken, Thanks for the confirmation. Between Krish0nan suggestion and yours I at least know that I'm not missing something or going about this incorrectly.

There is a separate KPI for gross new leads that goes to a report based on created date. The "lead date" is the date the record in question entered a lead state based on the checkbox "include in lead reports" on the customer status record. Thanks, -e I followed a suggestion (that you confirmed) in another thread to get…

Something similar is already being done with Saved Searches that provide emails when a record is added to the search. I don't know the details of how it is done, but if that is possible then it would seem it could be extended to other areas. good point! I'm guessing that they create a trigger when the notifcation stuff is…

This is the minimum refresh requirement. There should be a setting in the Company Setup (which can be overridden by the user) for the following:[LIST=1] [*]Auto refresh all portlets at each login: Y/N [*]Auto refresh all portlets each time the tab/page is displayed: Y/N [*]Auto refresh all portlets at this frequency (sec):…

I still like the idea of just refreshing when the underlying search results changes too. This would require the search be executed on some sort of a schedule to determine if indeed a change has happened. They could use triggers on the DB to update something, but that would either be record-wide trigger or if they did it…

Anyone know what the refresh rate for a portlet is? Do they auto refresh if left alone for awhile? I also don't like it that a SIMPLE portlet like "Tasks" needs to be clicked and refreshed even when the dashboard is reloaded. Anyway to make it auto-refresh every page visit?

We're glad we decided to go with an integrated solution using Web Services rather than the ecommerce provided by NS. I too have seen the many posts about the ecommerce sites being offline or broken and am glad our site keeps slaving on. Our custom PHP solution is flexible and works pretty well. Shawn, Are you running…

Find my replies in bold in the quote above. LOL.... thanks man, hehe.... :p

I'm only using it because we've invested too much time and money in it. I've got many regrets about using it. I have little hope that It'll improve because I've been using it for a long time and beating the bush for fixes and they just never arrive. Some fixes that do arrive are just unusable versions of what we needed…

Thanks to all who replied and shared your experiences. This thread has been very useful to me and I'm glad I asked the questions, the responses have made the decision simple for me. NetSuite: What's up? I can only hope you've had a meeting or two as a result of this thread, seems that a PM over there should have some…

I agree with BrettKnights when it comes to an ecommerce store on NetSuite. I found that you can do a lot on the NS system. However I might also add that it depends on your company budget, size, manpower and so on. It is definitely not a one size fits all answer. The easiest solution is to have your website on the NetSuite…

Hi Steve, Here are answers to some of your questions: Guillaume, Thank you for sharing your feedback, I appreciate your perspective on things.

Hi Brett, I can appreciate the thought and time you put into your reply and it did make me reconsider everything I've read and also what you wrote. NetSuite is lucky to have you on their side, I hope they treat you good! :) However after reading the other responses and evaluating our expected requirements against the…

I just ran into this as well. Is it possible to remove this advertisement?

Martyn, I haven't had those problems with scripts and whenever I have its been client side scripts and clearing the browser cache has resolved it. This web service caching is totally unacceptable, there literally was nothing I could do to make my search return the actual columns I was requesting. Very frustrating.…

Still plagued by this and it's not just saved searches - even dynamically built searches are returning the same fields even though I'm requesting different ones. I checked that the searchId for each response is indeed different. Here is the request SOAP where you can see I have specified 4 fields: <q1:columns>…

This is ridiculous.... NetSuite? Come on, don't make me go through support with this, it will take days... This is still happening and it's stopping processes...

Except I just realized that homephone and workphone apparently aren't exposed in a saved search. :confused:

You need to create a saved search in NetSuite and invoke it through Web Services. Thanks for the confirmation elham. I had though about the saved search option but I'm unclear how I would pass the phone number to search for to the saved search. If I have a Saved Search using expressions how can I get the argument to the…

Oh, I get it. I basically just set the phone number fields to the same value then the saved search has the expression. Duh! :p

I just started researching what's involved in creating AssemblyBuild transactions from WebServices. My current solution is to use a proxy record that is created with Web Services then a SS script creates that actual assembly transaction. This was a workaround for the days when AssemblyBuilds weren't support in SuiteTalk.…

Thanks for the link, I'll read up some more this weekend.

http://picasaweb.google.com/SteveKlett/NSUGStuff#5402608960097207138 I have confirmed that the .Net DateTime.Parse() method will parse 1942-02-20T00:00:00.000-07:00 into 2/19/1942 11:00:00 PM I don't understand why though. If the timezone parameter is kicking the date back a day why isn't the time 17:00 (5pm) instead of…

I've been attempting to pull the time zone component from the Date field using TO_CHAR() using the following format string: 'YYYY-MM-DD HH:MI:SS TZH:TZM' That should print out something like: 2009-11-10 01:01:01 -08:00 However when I include the TZH and TZM arguments I get an Invalid expression. This sorta makes sense…