Yes, the same result when I use Formula (Text) = Case When (TO_CHAR({case.createddate},'DD/MM/YYYY') ) > '1/1/2019' then {case.timetoclose} else Null end Yes, Formula(Text) = TO_CHAR({case.createddate},'DD/MM/YYYY') returns the correct creation date (without time, of course) Yes, my apology, I usually include a criteria…

I don't see where I can. I think because it is not my discussion. I think User_D244F has to consider and mark it. Thanks Camille.

GREAT NEWS!!!! Setting up the DKIM resolved our issue and Yes, it was easy. Navigation: Setup>Company>Email Preferences> Domain Keys tab Tips: Don't read too much into it. Your Domain Selector can be anything you want. I chose the first 3 letters of my company name and the date 10212020. Enter your Domain Selector Enter…

Yes, thanks Michelle. I have. I appreciate the suggestion. As you can imagine, looking at these tabs/fields is manual since not all fields are available to return in a saved search Of Saved Searches ?

I resorted to searching the internet for the nested email address info@autosupportdesk.com and find it may be related to Auto Support Desk but don't know how it was sent FROM: "support (info@autosupportdesk.com)" <system@sent-via.netsuite.com>. I'll keep looking, here. Don't spend any time on this. Thanks.

Thanks Michelle. I have been the Admin for 3 years and have never received an email related to this. I did look for a search and am still digging but finally reached out. Thanks

Dang ;) Thanks.

The Workflow is set to Execute on View or Update for ALL trigger types. If you want to prevent those roles from access to the Close button, the workflow is set to evaluate their role every time they View or Update it. You might consider and test a more narrow Client Trigger; Before User Edit Trigger? see SuiteAnswer Id:…

I have a similar question. We are considering inactivating a field and want to know the impact on user reporting so that we can plan/communicate the change properly. I want to identify all the Saved Searches and Reports that include a specific field. Any thoughts?

Yes, I am working toward setting up DKIM as well. Based on all the research I've done, this should solve it. I have experienced a hick-up (Domain Keys Setup > Domain is Used in Another Account) during my set up that the Support team is investigating but I am confident they will identify. I doubt this issue will occur for…

Using Google Chrome and Firefox, I logged out of NetSuite completely and successfully logged back in as Administrator. I have the NetSuite Support Center role attached to my Employee record. I navigated to Support and clicked SuiteIdeas. A new tab opens with the url…

Thank you Red. As I audit my results I find, I am returning incomplete and inconsistent results. I was not clear as to incomplete. I need to return All the Customers that were Won since January 1, 2019 and any cases they created. I have 54 Customers Won since January 1, 2019 but only 46 of them created cases. I need to…

Thank you Red. I am ultimately headed toward the following: List of clients that started with us since January 1, 2019 (Stage = Customer, Status = Won) Client start date, name, category (I am getting this from the Customer System Notes New Value and Date) For those clients a “bucket” that would provide me with their…

I want to know what the average time to close cases created after 12/31/2018 so I am attempting to only return the time to close value if the case was created after 12/31/2018. I will then need to return the # of cases created since then and divide the case.timetoclose by the # of cases created since 12/31/2018. First: I…

Yes, I am not sure when I last changed my password for my Production Administrator application access. I rely on NetSuite to prompt me to change it. Historically the single sign on to the NetSuite Support Center is in sync with my Production Administrator application. I do not normally get prompted from the NetSuite…

Feedback from NetSuite: Upon checking, e-Fix was release into Production and the status of Defect 597999 has been set to Closed. May I ask if you can please check again and let me know if the issue persists? In case you are still experiencing the same issue, kindly try this alternate solutions again then we'll update the…

Today 10/15/2020 using Google Chrome, I logged into Production as Administrator then navigated to Support>Support Overview and clicked SuiteIdeas. The following page was returned. I navigated back to the main NetSuite log on page and was able to successfully log in to Production again. I know that when I go to SuiteIdeas,…

Yes, Thank you John. This feature was already enabled in all my environments. Production: SANDBOX DEVELOPMENT

I am also experiencing an anomaly. I am the Administrator on all our environments. I created an Invoice PDF/HTML Template in our Development Account. I attempted to copy it to Sandbox but the Target Accounts are not active for selection, they are both grayed out. I am headed to re-build it manually but wanted to report…

Thanks Robert. I see the member's corner but cannot action on it. When I clicked "New Idea" I can't tell that it is going to be targeted in the Member's Corner, so did not enter anything, yet. Maybe we are still "getting there" :). Will keep an eye out.

Thank you Michelle. I voted for Enhancement Request #331991 and added comments. I also found Enhancement Request #160992 and added comments. If anyone is following this discussion and would find a solution helpful, please ask your administrator to go to SuiteIdeas> Enhancement Request #331991 and 160992 vote for the…

I changed to firefox and am doing a bit better.

Reports for data mining to replace Searches we have to export to excel then create pivots, eliminating manual intervention and allowing wide use at will of these pivot reports. Many fields are still not yet available for Datasets. Enhancement requests #549714, #56954, #594586, #596161, #550238 identify fields missing from…

Thanks my formula evolved to: Formula (Text), Summary Type = Minimum, Formula = REGEXP_REPLACE(min(to_char(substr({messages.message},0,1000))) keep (dense_rank first order by {messages.messagedate}),'<[^<>]*>',''), When Ordered by Field = Message Date. The results are inconsistent. I found that if the case message was…

* Scottsdale, AZ * NetSuite Administration Business Systems Analyst (functional) * NetSuite Software Vertical>ERP, CRM SFA, Customer Center, Case Management, SuiteAnalytics, ARM, FAM, Productivity Tools, etc. *

I received notification today that NetSuite has addressed this Defect and is scheduling the resolution for production migration. Thanks to all.

Hi Michelle. Attaching here is the file results from the "Send as Microsoft Excel" and a screen shot of the results that relate to the two cases above (44439 & 44438) I can't see where to "attach the file" may have to do separately.

Yes, Thanks Michelle. Great to hear from you. I did replace most of the special characters from the Emailed "Send as Microsoft Excel" results, except the final few characters. I combined minimum case message formula and the formula to remove/replace special characters into min(TO_CHAR({messagedate},'[yyyy/mm/dd hh:mi]')||'…

Thanks Coffeeguy, I am creating my Customer Dataset and I expect to return 4,144 Contacts with their Customer Center Role (they only have one each) When I add the Role:Name from Contacts/Role/Permissions The # of rows returned are multiplied and rows are duplicated. I only have 3 Customer Center Roles. At most, if anything…

Thanks coffeeguy. I will try the Analytics. I have a few other joins necessary for my information request and am hopeful with Analytics. I know all fields/records are not yet available in Analytics but have my fingers crossed. I should have tried there before asking. Appreciate the re-direction. Best.