Lists > Accounting > Shipping Items shows all of them (in administrator view)

You want to use the 'schedule' option on this saved search. Set it to run every day, and if you set the criteria to 90 days from expiration date, it should work perfectly.

What about making a custom record that joins both standard records, and then you can search the custom record.

I have a similar saved search, where this function is not equal to 0 CASE when TO_NUMBER({item.custitem_boxqty}) = 0 THEN 0 ELSE ROUND( ({quantity}- CASE when {quantityshiprecv} is null THEN 0 ELSE {quantityshiprecv} END)/TO_NUMBER({item.custitem_boxqty}),0)-({quantity}- CASE when {quantityshiprecv} is null THEN 0 ELSE…

I have a similar graph report for "On Time Shipping Per Month", which uses a custom field called "Ship Month" with formula: CONCAT(CONCAT(to_char({shipdate},'yyyy'), '-'), to_char({shipdate},'mm')) The format is YYYY-MM (such as 2012-01). Then I sort by this field, which is both alphabetical and chronological.

Just to clarify, this [INDENT]Customer Team X Employee Team X[/INDENT] would return results... But this wouldn't? [INDENT]Customer Team W Team X Employee Team X Team Y[/INDENT] Or would it only return the matched (Team X) results?

Under the criteria tab, there are two sub-tabs: standard and summary. If you choose the summary, you can put in a criteria for count of preferred bins equals 0. I think you have to turn the whole search into a summary search, so it would look like this: Criteria (summary) max of use bins = true count of preferred bins = 0…

You can filter for only parents with a criteria formula: case when {customer.parent} = {customer.entityid} then 1 else 0 end and then set the condition to be Equal to 1

Maybe a summary search, where count of preferred bins is 0.

You could hack it by making a concatenated formula: adding the other results of the other two formulas together.

Set a criteria filter of 'Status' and choose the appropriate options (ie 'Customer Closed-Won') You can also filter by 'Date of Last Order' or 'Date of Last Sale' to refine the list to your current customers.

Use expressions

You can get the rate conversion in a 'Unit Rate Search', and then merge the reports outside of NetSuite. Probably not the answer you are looking for...

Total Number of Weekdays in the current month: I'm sure you can do this with DATEPART. Are you going to account for holidays and leap year? All months have between 20 and 23 weekdays, inclusive. To get the total number of weekdays in a month (pseudo code) 20 + (IF 29th is a valid day & weekday THEN 1 ELSE 0) + (IF 30th is…

Ahh ok, I was hoping it was simple... I'm sure you were hoping that too. Maybe consider something a little different... here's what we do for the same situation: a saved search on the warehouse user's dashboard. Only orders with items committed show up on the search, today's orders are highlighted yellow and backorders are…

Evan - does this happen because there are posts to 3 GL accounts, and COGS filter would eliminate 2 of those posts?

You need Sales Order:Pending Fulfillment too

This is a transaction search? If so, add to your results Item Fields... On Hand

In your example you could use one of the date functions in NS to compare the dates, that will save some characters. Try MONTHS_BETWEEN(date1, date2) for example your code CASE WHEN (to_char({custbody_associatedcontract.custrecord_rencbd}, 'YYYYMM')*1)>(to_char({custbody_associatedcontract.custrecord_end}, 'YYYYMM')*1)))…

YW, I will have to try LAST_DAY. You might also want to try RANK, DENSE_RANK, or KEEP. I've never used them but the documentation describes them here: https://system.netsuite.com/help/helpcenter/en_US/Output/Help/SuiteFlex/Customization/Fields_SQLExpressions.html#1017959

There's no native functionality, but can be done with scripting and customization. It's not real complicated, but does take some time to build. What I did was make a custom search that builds each line with a formula: concat(concat(concat(concat(concat('xxxxxxxxxxx',SUBSTR(concat('0000000000',{number}),…

The internalid of the work order should be sequential with all transactions (including Sales Orders, Invoices, etc). Do you mean the tranid? Maybe post some screenshots of what you are encountering.

I think pcutler 1st idea is the best, make a hidden field {customfield} with formula of {cleared}, store value is No. Then change the formula in your existing field to CASE WHEN {customfield}='T' THEN 'Yes' ELSE 'No' END

Thanks that worked! I did have to place it on the Main tab to have it work, the Custom tab did not.

Check and see if there are other fields you can use to test for presence of {cleared}, such as {status} or {tranid}. For example, a nested case CASE WHEN {tranid} is NULL THEN 'No' ELSE CASE WHEN {cleared}='T' THEN 'Yes' ELSE 'No' END END

That's it thanks!

There's a hack to do it: https://usergroup.netsuite.com/users/forum/platform-areas/customization/custom-forms-fields/24021-default-sub-items-tab-to-items-instead-of-expenses-for-po It's buggy though, I ended up turning it off.

We've done a few things like this with scripting. It's not recommended by NS, but so far we have not run into any problems by modifying the DOM. But a better technique is to use the NS functions to give similar feedback to the user, just in a different manner. For example, use the validateLine type in a client script to…

I have a very similar script that will do this. I have it deployed as a client script but could be tweaked to be a user event too. function fieldchange(type, name) { if (name == 'itemid') restrict_char(name, '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-'); } function restrict_char(field, valid, ul) { //…

Hi Katherine - depending on your exact business needs, there are some other ways to get the ETA shown. I have a similar situation where I want to show ETA for out of stock items on our website. To show the ETA, I use a custom date field on the Item record. A script populates this field based on a search of open POs. So web…