If you want to sort in the opposite order you can change the formula from "ROWS BETWEEN UNBOUNDED PRECEDING" to "ROWS BETWEEN UNBOUNDED FOLLOWING"

I've shared instructions in the past for creating a report like this as a subtab within NetSuite https://stackoverflow.com/a/37015961/3230114

Haha I just saw your post on the other thread How do you make sure your customers pay (or can pay) for goods before shipping?

You should be able to change the URL in the formula to a relative URL (/core/media/media.nl?.....) An alternative approach to printing barcodes in a saved search without having to reference a font at all is to utilize a service that generates images such as http://barcodes4.me/apidocumentation…

You could create a Custom Record to save the link The custom record would have two fields, one a List/Record of type Opportunity record and the other List/Record type Estimate. On the first field set "Record is Parent" so you can see a sublist of all linked estimates on the opportunity record.

Absolutely the first step is to learn JavaScript. If you are looking for supplementary resources or cheaper alternatives to the NetSuite offered course there are two options I have heard very good things about: NetSuite Development With SuiteScript 2.0 (by Matt Dahse) https://leanpub.com/netsuitedevelopment Stoic…

You can create an Item Saved Search to exclude the products you don't want available, and then set that as an "Item Filter" on the sales order form (Customize Form > Sublist Fields > Item Filter) For more details see https://system.netsuite.com/app/help/helpcenter.nl?fid=section_n551064.html

NetSuite uses an Oracle database under the hood, so searching for the function name and "Oracle" in Google should give you plenty of results.

So basically, the user ticks the box, then you use a field change event script to 'do something'? I can see how that might work. There's no way to have a button or clickable dynamic URL / link within a sublist is there? Yep that how we use it. We have a "Lookup History" customization that shows a popup with the previous…

The "Lookup History" customization sounds great. Is this code available? Enjoy :-) https://gist.github.com/michoelchaikin/cb0632060be368943bf6a7e8e1f34534 It's one of my first Netsuite customizations, so it may not necessarily represent best practises

We do this via a custom Check Box field, and handling the field changed event.

You can authenticate either via username / password or token based authentication (OAuth 1.0). The later is alway preferable - more secure, don't have to deal with password expiration, can use admin role in 2018.2 etc.. I think that you need to "proxy" your api via their web server instead of the client authenticating…

Yes, that's a perfect use case for a Restlet

I think this is the better way to introduce scripts in view mode. It is much more managable than trying to but all your script tags in javascript variables. I agree absolutely that this is the recommended approach. I only use the "inlinehtml" method as a shortcut for short snippets.

One thing to note with the above approach, try and ensure the inlinehtml field is added to the form as late as possible otherwise fields you may be trying to access may not be available to the code. You can solve this by adding a delay to your code. Just yesterday I had to do this in a script that automatically chooses a…

Looks like you got the right approach, though note that this line is currently redundant: [CODE]<#elseif item.itemtype == "Markup">${item.description}<br />[/CODE] You can absolutely add a custom field to the Item records, however, keep in mind that you will need to also create a corresponding Custom Transaction Column…

The "?keep_before" built-in was only added to Freemarker version 2.3.21. Netsuite is still using an older version of the library (I believe 2.3.19). As an alternative you can try something like the below - [CODE]${record.entity.contact?substring(0, record.entity.contact?index_of(" "))}[/CODE]

Hey Russ, That error is if there is no space in the contact name, so ?index_of returns -1. Here's a revised version that checks for this. You are correct about ?substring being deprecated, so I've updated with the code to use "slicing expressions" instead (though I don't think that was the cause of the above error).…

I would be interested in the UI hack you are talking about... there are so many columns on our transactions that its unwieldy for small screens! It's just to clear out all the text in the "Label" field, but to keep "Show" checked. This works for most fields, and keeps them hidden in the UI but available in the printed…

This should be able to work, you will need to make sure that your Suitelet is 'Available Without Login'. You need to carefully consider the security implications of this. Also, have a look around, there are already existing Netsuite - Mailchimp integrations available.

The ODBC schema is documented in the "Connect Browser" https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2017_2/odbc/record/account.html?mode=domain&domain=general_accounting I don't believe there is any way to see the SQL for NetSuite saved searches and reports

If you are to still use your admin role my guess is you got an extension on 2FA enforcement and you will run into the issue in 2019.1

So you believe that SuiteAnalytics Connect would still only work with user credentials, not TBA? Hopefully they will add it in a future release. My concern besides for permission issues is password expiration.

Are you perhaps on one of the other datacenters? Can you try odbcserver.na1.netsuite.com / odbcserver.na2.netsuite.com?

I'm in the same boat as you. It sounds like you will have to create a non admin role with all the permissions you need.

I had a quick look in my account and they don't appear to be available.

You can copy an event by opening it in View mode, and clicking Actions > Make Copy. If this option doesn't display, it's possibly hidden on the form. Customize the form, and on the Actions subtab, ensure that 'Make Copy' is enabled.

I tried that, I get the warning, and can ignore it, but I then get another warning that you cannot have zero qty and it will not allow the credit to be saved. Interesting. I've done this many times on customer credit notes, but it sounds like it doesn't work on supplier credit notes.. Worst case of course is you can…

One option is to change the quantity to zero so that it doesn't affect stock, and override the amount column to the total amount you are adjusting. You will get a warning that amount does not equal unit price times quantity which you can ignore. Another option is to create a non-inventory adjustment code and use that…

That link just goes to main help page. Any ideas? Sorry, fixed the link now.