User_I4269 Blue Ribbon

I can't remember what was mentioned at Suiteworld but I think I heard that the pivot tables will not be coming out of beta. Can someone confirm that I heard correct and if not what is the future of Pivot Tables. Thank you

Thank you that worked

I am having a lot of trouble with the loading of Customers and Transactions. Customers are taking 30 - 60 sec to load and about 98% of that time is from the server. I have a case open with Netsuite but they have not admitted that there is a problem on their end. I have been complaining about this problem for months I have…

I have been demoing the entire Google apps extender and I like what most of it, the calendar sync works great and the Google docs feature is great too. The only issue I have which is kind of a big issue is the fact that when I compose an email from NS in the Gmail tab the email does not show up in the Gmail tab in the…

I created the above as a workflow and I now have live Calculations rather then result upon saving/submitting. This have opened many doors for me to create other live calculation functions. Thank you

How did you get it to minutes. If I want to round to the nearest 1/4 hour How would I do that?

I am looking for Total business days in a month. This sounds like a simple request but in looking at the 45 pages of this thread I can't seem to find a clear cut answer. I took the Advanced Searches training at suiteworld 2013. We were given a search called "Order totals Evaluated by Days in Month" (Exercise 7-06 for those…

so this is for the result not the criteria correct?

I have created a customer saved search to count the number of records that have had a specific set of fields changed. I want to know haw many records and the total number of fields that were updated. I am doing this by searching system notes. I can get a count of Records updated but I can not get an accurate count of the…

This is the closest I can get.. But for you to exclude the Holidays it has to be the tran date, if not it will not be excluded. Days in a Month Excluding Holidays and Weekends: Formula (numeric) : ((Last_day({trandate})- trunc({trandate},'MONTH') )+1) + MOD((Last_day({trandate})- trunc({trandate},'MONTH') ) ,1) -…

business days meaning excluding weekends and Holidays? Identifying holidays is a road block since there are different holidays and this is not something that is built in the system. Thanks, Mon I am looking for Holidays and weekends. I have created a CASE WHEN which excludes the holidays which is not working too well .

I have created a field on a custom record to show the % of total sales on the category (custom record ) for all sales in the company. Example : Category Acrylics % of Sales 2.47% To get this I used an item search and used Transaction joins to pull some of my information. Once I got my results I exported them and…

my results CASE WHEN is : CASE WHEN to_char({trandate},'D') in ('2','3','4','5','6') THEN to_char(last_day({trandate}),'DD' ) ELSE 0 END However I am getting an error

I have a multi-select field and I need to set a workflow condition that is dependent on the value. The workflow state will only trigger if the value is A and/or B. Currently I have a formula of {custbody_invoice_multi_types.id}='6' but I need to add my other result which is '8'. I can not use the visual builder because it…

Are these lines of different transactions? Show me the screenshot of your result tab and criteria.. Regards, Mon I sent you screen shots earlier this week, did you get t them?

Are these lines of different transactions? Show me the screenshot of your result tab and criteria.. Regards, Mon I will send you a private message with that information Brett

yes I am using a case when in the criteria: CASE WHEN TO_DATE({trandate}) NOT IN (TO_DATE('03/26/2013', 'mm/dd/yyyy'), TO_DATE('1/1/2014', 'mm/dd/yyyy') , TO_DATE('5/26/2014', 'mm/dd/yyyy') , TO_DATE('7/4/2014', 'mm/dd/yyyy') , TO_DATE('9/1/2014', 'mm/dd/yyyy') ) THEN 1 ELSE 0 END

Was this issue ever resolved. I have a need for this functionality :confused:

We requested a sandbox refresh on January 11 and it has not started yet. The status is "Delayed". I contacted support on January 12 and was informed there was a system-wide issue that was causing all sandbox refresh to display the DELAYED status. Later in the day on January 12 I was told the issue was resolved and there…

I am getting reports from some of my users also.

My IT department wants to do some test pings to the IP address for the server. Where can I find this. My PETs are 55.99% netsuite (Server) and 38% my network(Client). This was 29 seconds for a page refresh of a sales order view. Any information IP addresses for Netsuite will be helpful.

I have been experiencing slow speed issues as well.

Brett, Are your performance issues in any way related to Customer Records slow loading with a large number of Bill To and Ship To addresses? Just curious. Thanks. David Why do you ask?

very slow here in Maryland

I have had many of my users complaining.

I was not called by anyone yesterday

Thank you I have submitted a case to support

I have a few of my sales reps that have email invoices from NS and copied them self and me. We are using personalized Gmail and the messages went into the spam folder. Any updates as to why.

I want to update many of my searches with a new email address but I can not find a mass update to do this. DO you guys know a way to do this. If I change the default will that change existing addresses such as noreply@... or netsuitehelp@...?

All of the contracts I am trying to delete have no contract items even deleted items. The issue I am having is that there is a hidden field called " Contract (Hidden)" and it is part of the contract renewals bundle. It is a locked field and NS support tells me there is no way to unlock it. I have come up with a work around…