CDuf · Business Systems Analyst · Bronze Trophy

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.

Thanks, Looking forward to it.

Yes, thanks Michelle, I am using Google Chrome. I have not "needed" the navigation, myself, but noticed the missing path so I reported it, in case there was an issue. I will use Firefox in the meantime. From years ago, I thought NetSuite was "optimized for Google Chrome". Was that true? Is it still? Should I advise my…

Seems like there should be a better way (I'd like to see a Workflow Action that executed Save we could use) but, I resorted to a second workflow on the Issue Record Type that contained a Custom Workflow Action Script executed After Record Submit the Script is: /** * @NApiVersion 2.x * @NScriptType workflowactionscript */…

Thanks Shamaine. I will firm up our "process" to ensure we prevent the status changing to Billed until appropriate. Appreciate the help.

Thanks Michelle. I apologize for not responding earlier. I have been out. This solution looks good enough that I am asking the users to regression test it. I am hopeful, I will be able to mark this latest as the correct Answer. As always, Thanks so much for your patient and continued support.

Thanks, I updated the start of my last reply and provided more detail.

Thank you Shamaine. I may end up putting this in a WORD document. In this case after the user reported it to me, I investigated and could not "reset the status". Before I could log this question to the user group, my user "copied" the prior invoice so she could get to the Customer as a result print screens may be…

Thanks Michelle. I want to return all Cases Not Closed, with only this criteria my current count is 108. When I add this column I do return 108 Cases but the results in each Formula(Text) column is different. The new inserted Formula (Text) column improves the results in the original Formula (Text) column but when there is…

Thank you Jack, Although I am disappointed that Document Type fields are currently unsupported by SuiteAnalytics Dataset/Workbook, I am glad to be aware & especially to know I was not doing something wrong. THANKS I did create an Enhancement request for the Customer's Sales>Download list available in Saved Searches and…