Sounds like a defect, you should open a case. As a workaround you could try to highlight if the value is not between 1 and 20.

It shows up for me as PO/Check Number and it's not where you might think in the list, since the O is capitalized it's at the beginning of the P's. ... Options Originator P/N Ref PO Rate PO/Check Number Package Count Paid Amount ...

I just ran into this same thing, for slow-moving inventory. I have an ugly way of getting it... Create one invoice to a fake customer, and on that invoice is every item but with a qty of 0 (thru csv import). Then I ran a summary search for items with a only 1 invoice in my date range.

Thanks Kelly and finops I'm going to try those.

If you discover it please post it here I could really use it (other than the old export to excel trick). Maybe there's some other creative way to get it, but saved search results don't work well with this concept of none or zero.

We use odbc and excel, but I'm experimenting with a tracking report. So far it works well: [LIST] [*]Nightly saved search that appends data to various .txt file (eg inventory, cogs, invoice amount, etc) [*]Google spreadsheet links to the .txt files, on separate sheets. [*]Summary sheet and chart that consolidate the data…

If you make this a summary search you can use 'maximum' of this formula.

'Ship Via' is an choice in my search, I think it's the same as 'Ship Method' since the field id is {shipmethod}

I do something similar for successful estimates search, I want to know what % turned into sales orders. Here's my exact formula: CASE when {applyingtransaction.amount}=0 THEN 0 ELSE 1 END This is a summary search, with 'Average' for this column, and 'Show Totals' is checked.

Your reports or searches can't span more than 1 table join away from the start. So for example, if you start on the customer record then you can get to the opp and transaction tables, but you can't get to the task table, because that's two joins away. For this type of report, you have to export the data and create a…

You could create a custom field (checkbox) that represent the record's current state -- T or F. Then have an aftersubmit script compare the checkbox to the new state of the record. If it's a mismatch, you toggle the checkbox, and then this would fire off a saved search email alert.

You should be able to use a formula that multiplies member quantity by member item weight, and then sum that.

How about a summary search with 2 conditions: maximum is canada and minimum is canada.

You can use formulas (text) with substrings.

Use a formula (text) SUBSTR({item.name},4) ... or whatever the {field} is and then set the criteria to be 'XXXX'

You'll want to create a saved search with 'Formula (Text)' as one of the results., and use the SUBSTR function in the formula.

If there's a null it might cause a problem. See if you can run the same report on a small date range as a test.

Chris - instead of using formulas in your search, you could add 8 custom, calculated fields on the record -- one for each formula -- and uncheck 'store value'. Then you can sum these fields in the 9th column.

Can you post the results?

A scheduled script could fire every 30 minutes. Out of curiosity, why do you want the 5 minute delay?

I haven't tried workflows, but there is a 'Delay' in there that might work.

Right, that doesn't work, I forgot it's a little more complicated... you have to filter with a formula of {quantity} > 0. That has worked for me on Item Receipt searches.

I don't think you can't use one search formula in another. But you can add a field to the transaction, with a calculated value of the SQL formula (don't save value), and then you can reference that field in searches.

How are you populating the label fields, through scripting? If so you can get the results through two separate summary searches, and tie them together in the script.

Right, I think I unfairly blamed SQL. To get around this I created a user event javascript on the transaction, that parses the long field, and saves the value into a custom field.

I don't think you can do it in one step without scripting. Since you are exporting the file, you could always add a step in your process: open in excel and sum up the lines, it would be an easy macro to write. Another script option is to sum up the order qty aftersubmit, and write this value to a field. The use this field…

Can you filter it for qty>0?

You might be able to use a two finger scroll on the ipad. http://forums.macrumors.com/showthread.php?t=916041

There should be some 'created from' fields you can choose from.

I ran into this too in a little bit different situation, but found a work around. Using formulas, the vendor can be accessed with {item.othervendor} and the cost with {item.vendorcost}. But you will get (every vendor) x (every vendor cost) returned in your search. For example if you have 3 vendors with 1 cost each, you…