I've used this feature a lot and my guess is that you don't. But, if anyone knows otherwise I'd love to be proven wrong. David, I'm not sure I understand your comment. Are you saying that you know how to restrict an email alert to updates only? If so, I'd sure appreciate it if you could share your insight. Thanks.

OK, so you boys both passed math. Now if we can only teach NetSuite that trick! ;)

Maybe Date Created != null? Steve, you just gave me a great idea! I think this should work: Record Updated IF (Date_Created != Last_modified) Both of these are D/T fields, so unless the user modifies in less than one minute (unlikely) this should work. I going to test it now. Thanks Steve.

I just used TO_CHAR({custentity_company_description}). Mathieu, Thanks for the suggestion.:) Unfortunately when I try this I get the dreaded "Unexpected Error". :( My Long Text field is actually XML code. I wonder if this is causing the problem?

Suggest you search the users group for both auto numbering and autonumbering and you will see many cons and a few pros for turning it on. I agree. From my perspective, the CONS far outweigh the pros. IMO it is better to use either the built-in "Account" field or create a custom field to store the customer's number if you…

We also need to pull in Commission fees with invoices so that we can calculate "Customer Contribution", which is Gross Profit - Commissions. If anyone know how to do this, or has a solution for sale, please post here. Thanks.

We are looking at both allowing trend graphs on custom tabs and increasing the number of custom search portlets on the home page (at least by 1). Home pages get run very often so we are concerned about the impact large numbers of custom searches will have for overall performance. Thanks, -e This sounds great Evan! A min of…

The real issue here is that for some unknown reason the Home tab allows only one custom search to be added, whereas custom tabs allow as many as you want. For this reason, and others, we have evolved to a design where each major role/dept has a custom tab, and the user's pref are set to use that tab as the Landing Page.…

BTW, what is eFix short for? eMergencyFix? eVanFix? ;) Lot's of good choices: :D [LIST] [*]Essential [*]Elegant [*]Easy [*]Evan[/LIST]Don't really know, but I'm guessing it's code for the weekly Thursday-night fixes.

Super short list: [LIST=1] [*]Select Email templates to send in the message for single results [*]Option to record the email alert on a record's Messages list [*]Include attachments (as well as merge and attach templates) [*]Remove the "You requested to receive an email alert..." [*]Option to send plain text emails only…

A limitation from custom tabs though is that you cannot use trend graphs from custom KPIs on a custom tab. Good point John! I had forgotten about that issue. The same functionality that is available on the home page should be available across all custom tabs. I couldn't agree more.

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.

In 2009.1 you can use "{xxx.id}" to access the internal id of a list/record result field. Thanks, -e Evan, this sound very cool! :cool: So let me see if I understand how to use this. I have a custom record as follows: [LIST] [*]Name: System Parameters [*]ID: customrecord_system_parameters [*]Internal ID: 446[/LIST]The…

I have a solution that works for scripts, but not for Saved Searches. Briefly, I have created a custom record named "System Parameters". The fields of this record are things like Name, Type, Value, etc. Then, in any script, if you need a "constant", it pulls from the System Parameters record. To make this work for things…

Steve - there is a checkbox on recipients from results which is "send on update", won't leaving that unchecked get what you want? Steve, this should work for what you want. I use this all the time and the alert is ONLY sent when the record is created. No need to compare date stamps.

You can compare values to immutable internal IDs instead of mutable Strings. So just to make sure I have this right: [LIST] [*]Sales Rep is a record of type "Employee" [*]"42" referrs to a specific employee record [*]In this case "42" is the Internal ID for "John Smith"[/LIST] So we can write a formula something…

OK, that's quite different. So how could we use this feature to avoid "hard coding"?

Try imposing formula on the fields in the results tab , use inbuild filters And Or Thanks for the suggestion. I'm not familiar with "inbuild filters". Could you possible give an example? Thanks.

Thanks Steve. So the "Introduction" is ONLY used for multi-record results?

Thanks Evan, this worked like a charm. As always, you're a genius at these formulas. :cool:

If I don't get any feedback here, I'll have to assume it is a DEFECT and file a case.

I would like to get some feedback from the NetSuite account admins out there... as you probably already know, you can find saved searches via global search (by entering part or all of the name of the search as keywords). Admins can see all public and private (including other users') saved searches in the saved searches…

I think I have a way to do this. Use the following formula: median({XXX}) /* avg() */ and set the summary type to AVERAGE. Evan, this is a very interesting formula. Would you mind explaining how it works? Thanks.

Slightly off topic here, but is there a way to to just indicate that there is more than 1 on hand? We'd like users accessing the search to see just "Yes" or "True" if the on hand in that particular location is two or more. You should be able to create a Formula (Text) something like this:[INDENT]CASE {onhand} WHEN 1 THEN…

Can you describe what you are trying to accomplish, and provide some sample data, along with the expected results?

Steve, You're using Oracle PLSQL statements. I don't think that NetSuite supports PLSQL. I remember people asking about how to do IF-THEN constructs and someone pointed them to either the CASE or DECODE statements. Checkout this thread: IF/THEN/ELSE sytnax for formulas?

Evan, Thanks for the suggestion. This almost works. But if the Customer has an order for "Today" and for any date in the future, the customer is still returned by the search. If the customer has an order for today, I do NOT want them to be returned by the search, regardless of whether they have orders in the past or in the…

Add to the standard criteria ship date is not after today. My mistake. :o Your first suggestion worked. :D Adding "standard criteria ship date is not after today" actually causes Customers to be NOT listed who do NOT have an order for "Today", but do have an order in the future. I think I am now getting the correct list of…

JeanF does not want to apply the round function to the rows, so there's no way for us to know to apply it to the overall average. Thanks, -e Maybe I'm wrong, but that's not the way I read her statement:I want to apply ROUND to the grouped average results (and NOT at detail level...) The "grouped" average results would be…

This is a customer search, and you get no results on drill down? That is correct. When I click on one of the Customers that is returned it displays "No Search Results Match Your Criteria"