3936391 Green Ribbon

You may need a space after the distinct. Also - you may want towrap the denominator in nullif(.../0) to avoid divide by 0 errors, though they may not be possible if all time records have an employee.

try count(distinct {internalid})

use summary type=sum formula = case when {custentityXXX}<{today} then 1 end

Did you try Created From : Purchase Order?

I think the problem is you don't have an aggregate function for the denominator. In a grouped search, all formula expressions must be implicitly or explicitly part of an aggregate function. When you split them up, the top is explicitly inside an aggregate function (min()) and the second is implicitly (because if there is…

You can search for an enhancement request in the NetSuite support center, if you can't find one then contact support.

I don't believe that is currently available from search.

Try using "Inventory Location" instead of "Location".

Under search criteria you would choose formula (numeric) and then use formula something like this to calculate the % savings: 100*(1-{pricelevelXXX}/nullif({pricelevelYYY},0)) Where XXX and YYY are the ids of the online and retail price levels,respectively And then use different comparisons, i.e. between 10 and 20

You should be able to do that with formulas using the {pricelevelXXX} fields.

I can't think of a good automated way to do this without using SuiteScript. It would be a pretty simple script - search the goal records based on employee and month end.

If you are trying to copy values from the PM Setup record into fields on the PM record, using the sourcing/filtering tab on those fields and set source list=the PM Setup field and source from=the corresponding field on the record.

you will need to group by order # e.g. and then have formula fields, with a sumamry type of sum, that look something like this case when {item.id} = XXX then {quantity} end Where XXX is the internal ID of the various items.

We will add "Memorized Fields..." into transaction search for 2012.1. Thanks, -e

If it is a saved search I think the message header has that information. It looks something like this: X-MailingID: SEARCH; scompid=XXX; search=YYY; action=scheduled;

Try eliminating the "Purchase Order:" portion of the old and new values. You can look at the system ntoes for a record to see what the actual old and new values you should be looking for are.

Version 2012.1

I don't see a reason why this wouldn't work when you substitute "email" as a recipient from results. You want this email to go out when the order is created from the web store?

As far as I know, you can't do that kind of programmatic behavior in SQL (setting variables). In addition, I don't believe you can test a single row value against an aggregate value, so I don't know of a good way to do what you want in a single search. You could create a script to set a custom field to last PO date on all…

Try without the quotes on the '1'?

If those custom fields are of type time of day then to_char({field}, 'HH:MI am') should work for extracting the times.

can you change back to daily event and clear out the end by field?

It has been there for years, I believe since the multi partner feature was released.

Can you use the "Partner Team Member" criteria field?

You can only highlight entire rows in search.

you could use summary highlighting with a formula max of formula (numeric), formula = case when {call.title}='CAMPAIGN UPGRADE Q3 2011' then 1 else 0 end and compare that to 1

You can check "My preferred form" but that will affect all item searches.

Unfortunately department is not a supported join on the employee record. It should be, I will look at adding it.

Unfortunately custom sublists can only filter to a field on the record itself, not to values from other sublists. So I don't know a way to create the sublist you want without scripting.

The reason for this is once there is an expression the system cannot easily determine whether the required filters (e.g. main line and type for transactions) are in effect. We could develop a more sophisticated expression analyzer to determine this, but that would require us to enhance the system. Thanks, -e