Bulk Receiving of Multiple Receipts against Multiple Purchase Orders is in the 2012.1 release!

I just tested the function MONTHS_BETWEEN and it worked with a datetime field MONTHS_BETWEEN({datecreated}, {today}) So give this a try MONTHS_BETWEEN({custrecord_plp_project_id.lastmodified}, {custentity_nv_projorpricinglastupdated})

wahendrick-cws since you are using Chrome, look into Screen Scraper extensions. I don't use any of them so I can't vouch, but some even claim to scrape 'next page' automatically. https://chrome.google.com/webstore/search/screen%20scraping?hl=en-US

That's how I would do it too, JCirocco Alternatively, you can check the "Use Expressions" checkbox in Criteria, and use parentheses with AND / OR for two formulas.

Could it be that you have some results without an Activity, and that's causing the error?

A couple ideas... 1. what is sysdate, and shouldn't it be in {}? I typically use {today} 2. try running a simplified version like (CASE WHEN {accounttype} = 'Income' AND (Trunc(sysdate, 'IW') - Trunc({trandate}, 'IW'))/7 = 1 THEN {quantity} ELSE 0 END)/ ((SUM(CASE WHEN {accounttype} = 'Income' AND (Trunc({today}, 'IW') -…

I know with email generated from saved search, you can find the internalid of the saved search in the email header. See this thread: https://usergroup.netsuite.com/users/forum/platform-areas/reporting/407204-keeping-track-of-saved-search-alerts There may be a similar field for scripted email, not sure...

There's no way (in off-the-shelf NetSuite) to copy/paste a list of search criteria or filters. That would take a custom Suitelet. One way to accomplish the same result would be to use a custom body field, like a checkbox, and populate it on your pre-determined list of invoices using CSV import. The add the checkbox to your…

It's always tricky to get NetSuite to return search results for records that don't exist. The key is to return results in one column but not in another. For example [LIST] [*]Create a placeholder transaction everyday, such as an invoice for $0 to "Misc Company". You can create these through script, csv, etc. [*]Modify your…

I don't know if you can 'filter' in the strict sense of the word -- as in 'available filters' on a saved search. But you can use 'summary criteria' in a saved search. Standard Criteria Main Line = F Summary Criteria Count of Line ID = 1

Use summary search criteria of MAX of invoice date is less than 12/31/2015

It's not that straightforward. You will probably have to use COUNT of all service items >0, and MAX/MIN to of service items to be filter out the item you don't want. Try the other way first, using 'Items Ordered'.

I thought there was a thread about this, and did a quick check of the user group but couldn't find it. This should be possible to create using MOD, CASE, TO_CHAR and TO_NUMBER.

Sometimes it's difficult/impossible to use Saved Searches to find records or joins that don't exist, but here are a few suggestions: [LIST] [*]If you are searching for Customers, and the services are Items, try using the search criteria of 'Items Ordered' and then choose 'none of' Service C [*]Use a Summary Saved Search,…

You can export the list of Custom Transaction Forms to CSV but I don't see a way to search for them.

Sorry I misread that... I created something like this once, and I believe I joined for transactions as pcutler says, but then limited it to invoices, receipts, inventory adjustments, etc. (basically any transaction that can have an effect on inventory), then set a date criteria for <12/31/2015. The logic here is that in…

This should work and is a little bit cleaner Least ( (case when NVL({custrecord307},0) = 0 then 9999999 else {custrecord307} end), (case when NVL({custrecord13},0) = 0 then 9999999 else {custrecord13} end), (case when NVL({custrecord15},0) = 0 then 9999999 else {custrecord15} end), (case when NVL({custrecord17},0) = 0 then…

How do you find out about these undocumented fields I use Michoel's Chrome extension Netsuite Field Explorer it's awesome and worth the price!

Using joined records in searches can be tricky, and sometimes the results columns can act like criteria. That said, I can see one immediate problem: You have two criteria that are mutually exclusive [LIST] [*]Contract Item: Contract Item End Date - is on or before yesterday [*]Contract Item: Contract Item End Date - is on…

Try this CASE WHEN {custrecord104.custrecord127} = '1' THEN CASE WHEN {custrecordf} = 'No' THEN 'Requires Attention' WHEN {custrecord136} = 'No' THEN 'Requires Attention' WHEN {custrecord136} IS NULL THEN 'Requires Attention' WHEN {custrecord75} = 'No' THEN 'Requires Attention' ELSE CASE WHEN {custrecord104.custrecord127}…

I suspect that the data types are different or there are nulls, and this is throwing off the logic. I see that you are using sum() in your statements, that might be converting currency type to float. If you do end up using a custom field, you can add that that to the calculation. And add some handling for null. Something…

The key to simplifying this is to rewrite your commissions with cumulative percentages, as follows: (1% of the total) + (1% of the total over The key to simplifying this is to rewrite your commissions with cumulative percentages, as follows: (1% of the total) + (1% of the total over $1,000) This will give the same results,…

It can be tricky to discern the correct fields, there are a lot of Inventory and Location choices... in your case you want to use 'Inventory Location' and 'Location On Hand'

Can you post screenshots of your search criteria tab and results tab?

With multiple locations, you can probably accomplish what you are trying by making it a Summary Search and using Summary Criteria, and some SQL formulas.

If you only have two locations, you can do this with 3 criteria lines, making use of 'Inventory Location' and 'Location On Hand' [IMG2=JSON]{"data-align":"none","data-size":"full","src":"http:\/\/i65.tinypic.com\/r26mg1.jpg"}[/IMG2]

try this (looks like your first two lines are both at 5%) 0.05 * ({netamountnotax}-{shippingamount}) + 0.00 * (case when {netamountnotax}-{shippingamount} &gt; 6000 then {netamountnotax}-{shippingamount} - 6000 else 0 end) + 0.01 * (case when {netamountnotax}-{shippingamount} &gt; 12000 then…

You have two criteria, which gives you four permutations: Warehouse = 0, Showroom = 0 Warehouse > 0, Showroom = 0 Warehouse = 0, Showroom > 0 Warehouse > 0, Showroom > 0 But I have to say I'm a little confused about which one(s) you're looking for, since these are conflicting statements 0 inventory in the showroom but have…

Add yourself or another email account you control to all automated emails. It makes tracking down problems a lot easier.

Does the script use the actual search record (built in the UI) or did you recreate the search in the code?