CDuf · Business Systems Analyst · Bronze Trophy

I need to report the time a Case is in a specific status 'Waiting for Customer'. Theoretically, I am attempting to subtract the date:time the case went into the 'Waiting for Customer' status from the date:time is left the 'Waiting for Customer' status. While the System Information Date field format IS Date Time, the Field…

Thank you Michelle. Great to hear from you. I need to have this contact send another email to confirm my new Duplicate Detection setting. I wanted to let you know that we do not use/license Projects/Jobs, so not a factor.

I have one example lately that I cannot track down and am looking for hints. I have used NetSuite many years and understand that the above scenarios trigger the Case assigned to an Anonymous Customer. I have re-read the SuiteAnswers 23155, 68276, 90529 I have checked if there are multiple Customers associated to the…

I would add that NetSuite should consider automating the Duration capture when the Assignee "Edits" through Saves the Case. It is currently awkward to work a case and navigate to Duratioin to start the stop watch. It is often forgotten since the Support team is focused on solving the Customer Case. We have tried many ways…

just another thought.... Work Calendars.... Consider the below: All that use Support Management, please review SUITEIDEAS Enhancement Request 450157 related to Case Management. Title: Support Metrics - Incorporate work Calendar Details indicate: The support metrics are a good start but I believe the metrics should be more…

Dang, As always, Thanks

Thanks Michelle. Was Enhancement #88809 merged with Enhancement #76300? I don't find 88809. I have used Freshportlet in the meantime, but that is not easily available to the rest of my colleagues anymore. I understand that refreshing portlets realtime, would be an enormous drain on our resources but if we could have…

As a workaround, per your suggestion I re-saved my bookmark deeper into the the user group to https://community.oracle.com/netsuite/. I apologize for not responding sooner. Thanks Robert.?️

Ultimately I was prompted to change my password (per the normal NetSuite expiration period). I did reset it then and that synched up my Administrator credentials with my NetSuite Support Center credentials. It certainly wasn't urgent that I get into SuiteIdeas but it was unexpected that the two were out of sync. All is…

Yes. Thank you Michelle. I have what I need. I monitor both lists daily and have alerts set up. As you see, they "seem" to be coming from inside NetSuite, which is suspicious. I refer to these SuiteAnswers from time to time and others should find them helpful. Just posting these instances in case anyone else experiences…

11/04/2020 I received another 22 suspicious emails today. I am going to report to Google but wanted to share with all in case it is more than just our company. Hope this does not effect you.

Just information: Suspect the issue has many end user variables. Our User 2 successful test: Google Chrome incognito mode. Received password reset email immediately Our User 3 testing: Original test was Google Chrome incognito mode: Did not receive a password link email. Next Day same test with Google Chrome: Incognito…

Thank you Michelle. Yes, User 3 was using his "personal Gmail" address. I have additionally asked User 2 and User 3 the following: Which browsers were you using? Did you try more than one browser (particularly Andrew, User 3, since his failed but wondering about both of you)? If you did try different browsers, were the…

Yes, thank you Michelle. We did some testing here as well. Scenario 1. I created a Customer and added a contact with my home email address then tried to log on and went through the Forgot my Password process and I DID receive my reset email link at my home email address. Scenario 2. My colleague did the same thing and she…

Thanks coffeeguy. I appreciate the tip. I am not a developer so this will take me a bit to digest and test. I will circle back when I make progress ? or fail.

Great! Thanks, Red. It worked with both Formula (Text) and Formula (Numeric) The difference being: Formula (Text) is left justified as text is. Formula (Numeric) is right justified as numbers are. I will use Formula (Numeric) as long as I can since my final results will be numbers. (fingers crossed) ? This gets my formula…

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…