It was actually a very elegant solution to the problem. Kudos. I took it a small step further and combined some of the status fields like this. decode({custrecordstatus},'FD -1 ','1','FD - 2,'1','FD - 3','1','FD - 4,'1') decode({custrecordstatus},'SD','1') decode({custrecordstatus},'SP','1') Thanks again. Hey ... is there…

Evan, That's just what I'm looking for, but I'm having a hard time making it work. I get 'invalid expression'. this is my numeric formula: decode({custrecordstatus},1,1) Is there something fundementally wrong with my formula? I know our formatting isn't great (no _ in the field id). The field sources from a list and the…

That works perfectly ... I'd never noticed the system notes before. Thanks!

When you enter a cash sale, you one of the fields available is 'opportunity'. This shows all open opportunities for the customer and closes the opportunity when the cash sale is completed. I would like to show the opportunities associated with the cash sales.

Thanks Evan ... I was 1 minute too slow :)

Yes, that works (both of them). Thanks so much. I'm definitely looking forward to the new filtering abilities.

Hmm ... The Rank function is a possiblity but when I use it the customers with the lowest transaction amounts are number 1. I have transaction amount in the search twice. Once as a sum and once as rank. Changing the sort order just inverts them lowest first. It seems like I'm close but still no cigar.

Thanks, I'll take a look. Do you have an enhancement request number that I can add myself to for the aggregate searches? Edit: This is now possible in V.2007

How do I do that? I don't see any row options on the Audience or Roles tab.

Wow. No Putty? That would be fantastic. So ... when we're on 11.0.4, how would I go about getting and setting up the new driver?

Basically surround the column that could be an error with a nvl. {Quantity}*nvl({custcolweight},0) For more info, do a search on SQL in the help Center.

I'm also noticing that I can't even limit it by the total amount. If I could just display those that have purchased more than 10,000 that would work too. But ... the total amount purchased field doesn't seem to work (and can't be limited to a date range) and I can't use grouped fields as criteria. This has sure been a…

How do I assign Enterprise Reporting to my role? What permission is it?

If it were me, I'd just do it with a cystal report. But these are for execs and bigwigs that want things one click away or sitting on their dashboard. Thanks for the suggestions though. Does anyone know about the Total Amount Purchased field? It doesn't seem to do what I think it does. If I give it a criteria of more than…

There it is! Thanks.

We have advanced analytics and I had no idea that this new feature existed. I just read that they are turning off the old putty support at the end of the year. It would have been nice to get an email from Netsuite. I can just see all of our crystal reports going offline in January with no idea why. Thanks for the info. It…

I don't have that. I have setup>company>enterprise reporting views but no Advanced Analytics. Hmmm.

For this purpose, is Date of First Order not the same as Date of First Sale which is available? Edit: Removed edit.

Thanks for the suggestion. We changed all the forms and the method names so that would work on the NetSuite side for phone orders but that doesn't solve the problem for online orders. There's no way for the customer to choose the "customer pickup" method without choosing a carrier first. Nobody's going to figure out that…

The message we get is is this: "Fulfillments can be shipped from only one location when using multi-location inventory." To me, that makes no sense. Also, the sales order that I got that from only had non-inventory items in it, so we're not shipping anything.

Hi Surendra, What do you mean when you say "We book all our sales orders in one location"? Do you start your orders with the same location for all items?

Thanks for all the comments and suggestions. All of our items must be fulfilled from the location that we've specified on the item record. No items are available from multiple locations (in this scenario) and all have inventory in their default location (or are non-inventory items). I'll take a look at writing a script to…

Hmmm ... I'll see how that works and let you know.

We got access to our preview account and many of our staff are distraught over the data density issue. It is going to be WAY more work for them. Many of the screens they look at all day long now have half of the information than they did before. This is going to cost us money and cause a lot of grief when things get crazy…

I agree. Gmail has 4 density levels. Cozy, Compact, Comfortable and Touch Enabled. Something like that would be great. Until then, we'll enjoy some of the other new UI features that make NetSuite better. 

Overall it looks really good Malin. Thanks for giving us a preview. I think our staff will be split on the new look. Sales reps and design types like me will love it but our accounting and data entry folks are going to dislike it. Like, really dislike it. They don't want lots of white space and what looks like a cluttered…

Is anyone else seeing frequent runtime error messages from the Drag and Drop module? I get alerts for multiple users every day. They start like this: File Drag and Drop Error Details ERROR DETAILS NetworkError: Failed to execute 'send' on 'XMLHttpRequest'

[FONT=Century Gothic]Woo hoo! July 22, 2104. Thanks NetSuite! ------------------------------------------------------------------------ File Drag & Drop Beta 1.5 will include the following enhancements:[/FONT] [FONT=Symbol]·Ability to drag and drop files into the File Cabinet – The SuiteAppnow comes with a dedicated File…

Tried it out today. Thanks for adding new features like this! It works, but all files are unavailable without login. Would you consider adding the option of having "available without login" checked just like it can with the regular upload? Files for the web site all have to have this box unchecked.

Case 1991950 filed.