Problem #1 is fixed in an upcoming eFix, I believe on the evening of the 28th. Really?! Let me make sure I understand so I don't wait for a solution that may not pan out for me; From a Foo search the reps email address is accessed like this (using formula syntax for example): custrecord_salesorderfield.salesrep.email I…

This is a Web Services question and most likely won't get answered in this forum because this is the UI Search forumn. But I can't help myself! You need to iterate over the array of SearchColumnCustomField instances and find the field you are interested in. This is more complicated that it should be because…

Steve, What if you created a Transaction non-saved field sourced to the custom record field? You should then be able to create a Transaction search with this custom field as criteria. Hi Jim, A good suggestion but it won't work for my setup. The Foo record is a child of the transaction and I don't have a field reference to…

I'm glad they separated these two fields because it is kind of an odd behavior to have one result column displaying two type of data. Agreed, it is nice and makes more sense. I just wish they would have put this in the release notes so I could have been prepared.

FYI, I think there is a bug with this new feature that causes it to send duplicate emails. I have confirmed that when explicit recipients are listed the email is sent once. When there are no explicit recipients listed and I use Sales Order : Sales Rep the email is sent twice. Case# 886368

Doh!! Stupid me... I just found it in the Function column. Sorry! Formula (Numeric) | Average | Round | SYSDATE - {createddate}

Ah, cool. My *real* search is a Custom Record search and the Transaction is joined so I don't have access to Sales Rep fields. It's still good to know how that works. Thanks for the info.

You can't do what you want to do. The upside is that NetSuite rarely changes field ids.

enhancement# 122897 Now I KNOW I entered an ER (or caused one, whatever; you know what I mean) and when I search for 'search description' it doesn't come up. Frustrating. The ER above is for another ER that sounds like it's close to my request. NetSuite, can you help me understand what I'm doing wrong with the ER search?…

IIRC there is none. Shipping comes out as a line item. So you have to filter on the memo or the account to grab just the shipping. Thanks Olivier, this was a good tip. I ended up actually being able to filter on the Item (Shipping Cost Item) to get what I was after. Oddly I noticed that the Account field for the Shipping…

I had to read this a couple times to understand and I'm still not sure that I do. One possible workaround for my scenario is to make my saved search Available as a List View then use the custom record list page. This WILL store the sort order. The downside is that it will not be available in the Reports > Saved Searches…

The field Id will be available, but not the ids of the field's (list's) items..... right?

variables in saved searches are a sorely needed feature. I have often come across the need to have account specific preferences accessible in a saved search. Bad news is this isn't possible. I think your idea of a custom record will frustrate you. In order to have access to that custom record in the search you will need to…

Solution! Add a Formula (Number) field like so: {datecreated}-{lastmodifieddate} == 0 There is a chance that I could have a tick(or two) offset from the datecreated and lastdatemodified timestamps but it looks like the Oracle TIMESTAMP type is accurate to the second so this would be an incredible occurence to hit right on…

Actually I never really thought about that. I was under the impression that the various "send on update" fields meant "send when changed" versus "send on a static schedule" If it DOES mean "send when updated" versus "send when created" then it's really not very intuitive (IMO). NetSuite has already exposed event types in…

We also need to add a description to a saved search. Sometimes I'm looking through a list and I will see a saved search and forget what I created it for. It's still valid and useful in most cases, but I still can't easier determine it's purpose. 'asdasdasdasdasdasdasdasd' isn't a terribly descriptive name either ;) I…

Ah, your first post! Congratulations! :p Thanks for the suggestion, but the problem is what to compare it to. It's unfortunate the the system note's field values are simple text fields, so I can't check for null. It's not possible to compose a criteria that says "If date created was empty and not is not".

Solution! Add a Formula (Number) field like so: {datecreated}-{lastmodifieddate} == 0 There is a chance that I could have a tick(or two) offset from the datecreated and lastdatemodified timestamps but it looks like the Oracle TIMESTAMP type is accurate to the second so this would be an incredible occurence to hit right on…

I think this one may have been sprinkled with a little EvanDust! ;) Status changed from Open - Work In Progress to Open - Fix Undergoing Testing

Defect 155871 - Customer would want only the live filtered search(using footer filter) be emailed.

I think the introduction is for NON-single results and the Single Record Results below it (not the field selector (which is broken)) but the one below that is what you want to use. It's been awhile, but I seem to recall it was something like this. Beware that it's not possible to specify line breaks (defect) in this field…

Yeah, footer filter is what I was referring to. I saw Phillip's response and had meant to test it but didn't get around to it yet. Case entered: 846511

I think the introduction is for NON-single results and the Single Record Results below it (not the field selector (which is broken)) but the one below that is what you want to use. It's been awhile, but I seem to recall it was something like this. Beware that it's not possible to specify line breaks (defect) in this field…

Wow, it was right under my nose! From the list of searches the data I wanted was the "Search Form" link.

It was the preceding '1' digit that was throwing things off. Duh! :p

Is it possible to put some kind of date criteria in a formula? I'm new to formulae by the way. I'm trying to count the number of tasks that have 2 custom checkboxes ticked and summarise the sum of them by the person they were assigned to. I'd like to show a summarised view over the last month and the last year. Reports…

Should be doable via Customer Search. Something like the following should return the customers who bought the item but haven't done so in the last 30 days and the most recent transaction date: 1 - Add customer name (or Internal ID) column (summary type=GROUP) 2 - Add joined transaction:transaction date column (summary…

It gets better. It doesn't need to be a joined search. I just tried a straight up transaction search with the following Criteria: Type = Invoice Item = MyItem Results: Amount Amount Paid Amount paid always returns 0.00 Although I could be missing something, at this point it would seem that you can't create a transaction…

date arithmetic will return days or fraction of days. So a criteria like: Formula (Number) ({SYSDATE} - {some_date_field}) * 24 'greater than' 4 ({2008-12-11 10:54 PM} - {2008-12-11 6:30 PM}) = 0.1770 0.1770 * 24 = 4.25 (hours)

That is the crux of the problem; using Item on Any Line will result in Amount Paid and Amount Remaining being 0.00. I'm sure there are other fields that suffer the same effect, but those are the two I've noticed.