Is there a .getText() option?

Can you use a summary filter for min of date in system notes?

Yeah it's a little tricky, you'd have to make a formula where you check for {trandate} month and year equal to {today} month and year. Something like this Case when TO_CHAR({trandate}, 'MM/YYYY') = TO_CHAR({trandate}, 'MM/YYYY') then 1 else 0 end and then summarize that with 'sum', allow only a value of 0

That's correct, a summary type is required for all columns you want displayed

By using a summary type of 'group' for your formula, you will only get one result.

Very nice, thanks for the tip

I don't know if this is possible without scripting/exporting/odbc.

You might be able to do this with summary search. In your summary criteria, you want the count of main to be 0, and in your summary results, group by customer and set all other fields to max/min/group as needed.

Yeah sorry I think I misled you a little. It should look like this (untested)

Sometimes the fields aren't shown in the list, but you can try using formula (text) field with it's field name {revalue}

Maybe (I haven't tried it) you could have a custom html body field on your Sales Order. Install a barcode font on your computer. Most barcode fonts use * as an open and close to the barcode, so Sales Order 12345 would be *12345* in barcode. For the html field value, set a formula to concat(concat('<font…

try using nvl TO_CHAR(ROUND((NVL({averagecost},{cost})*{transaction.quantity }),2)*-1,'9999999.00')

There's a criteria called "Item On Any Line". I've never tried it, maybe that is enough? Also you could possible use summary searches, MAX or MIN, and then manipulate the results to show all lines.

I did the same thing as JCirocco... a dummy invoice for 0 qty of all items.

NP... It might be worth trying the summary search though, you can get lots of detail if you add multiple groups to the results... for example if you want to see every line on the transaction, then show results for Number (grouped) and Line ID (grouped). Meanwhile your summary criteria can find orders where the MAX or MIN…

It's possible as a report to see the inventory as of a date, not sure if that helps. If you really need it as a search, you could build a custom solution, I've made a similar one for summarizing SO quantities for historical purposes. It involves making a custom record that stores a item number, date, and quantity. Then a…

from another thread rnedelkow NetSuite Employee Join Date: May 2007 Location: Toronto, Canada Posts: 425 A date field can be converted to show the day by using a formula(text) field in your results: Try Formula (Text) --- to_char({createddate}, 'day') --- for the text day Thanks, __________________ Robert Nedelkow |…

You probably have a script running on the record, such as an aftersubmit user event, that "updates" the record a second time.

Is the Special Order number on the SO line? If so, you can use 'Created from Fields...'

For committed, I use a summary criteria filter of 'Quantity Committed' >= 1. This also captures partially committed. If you only want fully committed lines, you could set up a filter for 'Quantity' - 'Quantity Committed' = 0. For date tracking, we use the 'Ship Date' field -- the date the order is supposed to ship. It…

Clay - we track this kind of thing thru a nightly saved search. Any SO that could have been fulfilled, but wasn't, is included in the email. Each morning, a clerk in our Quality dept investigates each one (typically it's one one or two), edits the SO, and chooses a drop-down field on the late line for the 'late reason'...…

You can use ASCII and SUBSTR to get a value of the second character, then make the criteria between 48 and 57, inclusive. ASCII(SUBSTR({billzipcode}, 2,1))

We do it that way because we often ship partial orders. For a 10 line order, if 9 are available on the ship date they will go, with 1 backordered, giving us a 90% fill rate on that order. Some of our orders are 40-50 lines.

The second statement will never be true, because if {name}='Q-01MG-SP2-AB' then {name} cannot be 'R-01MG-SP2-AB' Same thing with {quantityonhand}

yes I've got a saved Item search, works well Criteria Bin On Hand Count >= 1 Results Name Description Bin On Hand Count Bin Number Available Filters (Default Text Field Filter: Any) Bin Number (Show in Footer) Bin Number: Location (Show in Footer)

I agree. I never use reports, only searches.

Excel Web Query has some variables you can set, maybe to handle as text instead of number? I've never tried it but worth a shot http://www.exceluser.com/explore/webqueries_1.htm

In the criteria, can you choose "Default Shipping Address" is True?

How are you generating the list of 30 items... Is it a static list, or a dynamic list? If it's static, then a custom field on the item record would work. If it's dynamic, are the results from another NetSuite search?

OK, so with some scripting you could do what you want with a textarea field. Something like this: Create a saved search Create a custom record with a textarea field and a button to run a script When the user presses the button the textarea is split (comma separated?) into array and used as filters in the search The search…