Hi! Located in Melbourne Australia. I work for a NetSuite end user (office supply chain) as their in house admin / developer. We use primary ERP / CRM Michoel

Try changing <#list picktasks as lineitem> to <#list picktasks?sort_by('binName1') as lineitem>

Interesting solution, but it won't work reliably if you have multiple tabs open at the same time. My suggestion to use window.opener should solve that.

If you don't care about the transaction type, only if the page is opened from a transaction vs. the customer record, then you can just look at the page url If it was opened from a transaction it would be https://123465.app.netsuite.com/app/common/address/transactionaddress.nl and from the customer page, the address would…

Your client script can communicate with the originating frame using "window.opener" So you could do something like window.opener.nlapiGetRecordType() Or SS2.x version window.opener.require(['N/currentRecord'], currentRecord => console.log(currentRecord.get().type)); One gotcha to keep in mind is I have encountered cases…

NetSuite 2020.1 includes support for Sales and Purchase Custom Transactions (see release notes https://system.netsuite.com/help/helpcenter/en_US/PDF/ReleaseNotes_2020.1.0.pdf ) I haven't tried them out, but it may support what you are trying to accomplish.

Have a look at TCS POS - it's a point of sales solution built directly on top of NetSuite https://truecloudsolutions.com.au (Disclaimer - I haven't tried it myself so I can't vouch for how well it works or how economical it is).

It's there under Import Type = Transaction, and then Record Type = "Cheque"

You should definitely check out the Slack group https://netsuiteprofessionals.com/slack/ It's a completely different style to this group but it's an absolutely phenomenal resource with close to six thousand members

I've done a similar customization by creating a custom "Customer" field required filter, hiding the native one on the forms, and using a workflow to copy the value from the custom one to the native field whenever it is changed

SheetJS I linked above can parse .xlsx files For CSV a popular library is PapaParse

You can try your hand at using SheetJS. There is some info here on getting it to work with SuiteScript https://netsuiteprofessionals.com/question/does-sheetjs-work-in-netsuite-serverside-script/

Java 8 is the same as 1.8 so I guess any of the ones that say jbsdk8 should work Your other options are either to downgrade Webstorm, or (if you use Webstorm for other development besides NetSuite) use Jetbrains Toolbox to have both versions installed simultaneously

10 seconds is not normal at all. We get around 2-3 seconds typically and that's with a decent amount of customization. The first step is identifying the cause. NetSuite has a tool you can install called Application Performance Management (APM) for that.…

What type of script are you submitting the task in? What type of task?

There is a third part solution that looks like it does exactly what you are after https://cloudcoders.com.au/shop/productivity-tools/consolidated-purchase-orders/ I have never used this product myself though.

I had this same issue and the best I could come up with was setting them all to 'XXXXX' + random string

To retrieve a substring in Advanced PDF/HTML templates you can use a slicing expression: <#if record.linkedtrackingnumbers[0..4] <> "00108"> But there is also a ?starts_with builtin that looks much prettier <#if ! record.linkedtrackingnumbers?starts_with("00108") >

Are you using the latest ODBC driver? There was a mandatory upgrade just a couple days ago. Here's a copy of the notification email NetSuite sent out: You are receiving this notification because you are using the Connect Service. The cipher suites for SuiteAnalytics Connect will be upgraded to provide enhanced security for…

The latest versions of WebStorm use a newer JDK version that is not compatible with the SuiteCloud plugin. The workaround is to roll back the JDK that WebStorm uses to version 1.8 (IIRC) https://intellij-support.jetbrains.com/hc/en-us/articles/206544879-Selecting-the-JDK-version-the-IDE-will-run-under

You can't have a single invoice for multiple sales orders. You need to look into consolidated invoicing solutions. NetSuite used to offer a bundle for free as part of their SuiteSoluitions program which they have now unfortunately stopped. Other options I have heard of but not tried personally:…

You could look at the Advanced Procurement module which includes support for purchase contracts with tiered pricing https://www.netsuite.com/portal/assets/pdf/ds-advanced-procurement.pdf

You just need to Bill from the Sales Order instead of the Fulfillment.

Group your search by Item, and add a result column for Item Rate, with the Summary Type set to Maximum and When Ordered by Field to Date

I would recommend using a workflow to send statements. I'm pretty sure you will be able to set the email recipient based on a custom field. There's a lot of additional benefits such as being able to schedule in advance, customize the email message, send to more than 100 at a time.

I'm glad you enjoy the extension . The confusing thing is that NetSuite record fields are not always the same as search fields, so what is available for one is not always available for the other and sometimes the same field is named differently as well. My extension shows the record fields.

From what I understand the timeout is mandatory for PCI compliance and such workarounds could be problematic See for example https://security.stackexchange.com/questions/109805/clarification-of-pci-dss-3-1-requirement-68 Other websites solve this by popping up a notification that the user is about to be logged out and…

NetSuite's Advanced PDF/HTML Templates use an engine called Freemarker. There's pretty decent getting started guide on the Freemarker website that provides a good overview on how you can add logic to your templates, as well as comprehensive documentation. https://freemarker.apache.org/docs/dgui_quickstart_template.html

NS_CONCAT is great, but there is actually a documented Oracle function that is even more powerful called LISTAGG One of the advantages is that you can specify your own delimiter. So instead of having to wrap it in a replace, like REPLACE(NS_CONCAT({role}), ',', ', '), you can simply do LISTAGG({role}, ', ') And if you have…

To show the actual roles (not just a count) follow the above instructions, but in step 6 create a Formula (Text) column with a summary type of Maximum and the formula: "LISTAGG({role}, ', ')"