There is code here: https://github.com/DeepChannel/netsuite-savedsearch-s3 Or you can install the SuiteBundle 271853 The bundle processes saved searches and saves a CSV of the search to S3 It manages very large files by using the S3 parts api.

I did some work for a company called Deep Channel and we developed a saved search to S3 exporter. When the search is large the script uses the SS2 task module to generate the search and then trigger the push to S3 so some very large saved searches can be managed. The company open sourced the work and it's also available…

You could try to trigger the entry condition for your workflow from a saved search. In the saved search you could have a formula field that only returns true during certain business hours. Then the approvals would stop at time X and start again at time Y so all of yesterday evening's orders would be approved on the correct…

The correct answer depends on information only you have. Try going to…

Hi Evan, Using the campaign response fields is problematic in a couple of ways. The first is that the campaign Id field shows up as a text rather than a pick list so if I have a number of campaigns I want to exclude the names would have to reliably contain a common string. Even if that were the case however using it also…

How? I found I can include a "none of group X" criteria in a search used to populate a group but the only groups that came up were static groups. If there is a recommended way to do this do you have a link to the help article or online example that makes the recommendation?

FWIW I found you can reference Groups in the saved search to exclude entities who are already members of other groups. It appears to work with dynamic groups too! I see a world of possibility open up... Of course this doesn't quite address my original post but it'll work for my purpose. If anyone has a more direct method…

No but in relation to your SPF post I took a look at Netsuite's SPF setup. It doesn't appear to be complete. The SPF record admits this with the ?all attribute which indicates other servers than those configured might send email for Netsuite. I imagine the net effect of that would be an increase in "probable spam" score…

Have you considered using bins and putting one reel per bin? I think that would force NS to pull amounts for a build from a single bin. If that doesn't work automatically it could be made to work with scripting. (Note: If you do not currently have bins turned on and are going to play around with this yourself it's pretty…

if you are comfortable with script at all or want to extend your powers you could try the following in a console window. Chrome and Safari have console windows built-in. Firebug for Firefox provides one and so does the developer toolbar for IE. You need the internal ids of the items you want to swap.…

You can't do this directly. Depending on your use case there are a number of strategies you could use to simulate a kit item with options for your web site. one possibility: [LIST] [*]Create a multi-select custom field that links a parent Non-Inventory item to a set of child items to define the kit. [*]Assign the same…

It's a user event script that breaks up the facade item into its components. For call in customers you could still add the facade item to the order and set its options. Then when you save the order the facade would be replaced by its parts.

It is.

You could do this in script easily enough. A non-script approach would be to create a static customer group of "10 days overdue customers" You'd fill that with a search on transactions where you find invoices exactly 10 days overdue. Then you'd base your invoice search on customers in the group. You'd have to manually…

Actually you may be able to do this with a custom field and a scheduled mass modify. Create a custom entity date field. In a mass update do a search on the customer's invoices where daysoverdue is 10. update the custom date field with today's date. In your search search on customer fields where the custom field is "today"…

There is a field on customers "Days Overdue" that can be used for this. When setting up your saved search criteria on transactions just scroll down. At the bottom of the list are all the records related to transactions. Find the customer and filter on Days Overdue > 10.

So are you wanting to set this up so that you produce a list of invoices for any customer that has at least one invoice that is exactly 10 days overdue. So you can run this daily but only list customers on that 10th day?

You could also install the pivot table report bundle and play with that. Pretty easy to achieve what you are looking for that way.

For what you are doing you might want to check out the following posts: https://usergroup.netsuite.com/users/showthread.php?t=28718 This shows an example of using internalidnumber. Note that in order to use this your saved search has to be sorted using a formula field. Just sorting on internal id will return records sorted…

FWIW I can confirm this is still a defect 15 months later: Defect #- 200435

OK all fixed, i just made a new parameter and passed in the value and retrieved it in the end. THANK YOU ALL FOR YOUR HELP, I REALLY APPRECIATE IT. I have one last problem, i promise its the last one ;) When the script creates my new xml file, i am able to navigate to it from my site and view it, but it looks like plain…

If you are able to verify the mime-type header issue I strongly urge you to file a case with Netsuite. There are a number of very useful things that could be done if this were fixed.

To partially answer my own question: Once the search is set up users can subscribe to them under Home -> Set Preferences -> Alerts. They can pick their own times for updates. Of course what I'm really trying to do is set up a series of emails: One at 9am for employees who haven't verified their weekly time One at noon for…

Is it possible in a saved search to show whether an item is a matrix item (parent or child) or if its just a standard inventory item without using criteria? Maybe using formulas? One of these somewhat bizarre Netsuite oversights. You can search on whether an item is a matrix parent or matrix child but you can't return that…

This works with transaction's Date Created: ({datecreated} - to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')) * 86400 Be aware though that this isn't a true Unix time stamp because I believe the date uses the system timezone whereas a Unix Timestamp should be relative to UTC. If all you are doing is sorting then…

Yes the first case works but the second would not return the customer. I'm trying to figure out how to make it so. It may not matter that much since there doesn't appear to be a way to limit an employee to only being able use a single search for customer access. i.e. set up some sort of rule based security. It looks like…

Hi Steve. Check the help on that field. "Records Ordered" just means that when attached to a parent record you can manipulate the order they appear in that parent's child sublist. AFAIK you can't retrieve that order doing any sort of search. When sort order is important outside of the context of the GUI I always just add a…

We have a utility service that'll receive the search results from a Suitelet and put it on a configured FTP server. Contact me off line if you'd like to discuss details. 206-866-5646

can you run the report for transactions this month and then group on trandate?

Dave, In order to actually just do your billing I'd take the following approach. Create a custom item field that accumulates the item's monthly storage charge. create a mass update script that calculates an item's daily storage charge based on the qty on hand. (no need then to sum transaction quantities) run the script…