Hi Erick, I tested those changes but same result. The Netsuite POST to the API is definitely working fine, and the remote system accepts the multipart data and successfully decodes it. So I don't think there is an issue with compatibility between Suitescript https.post and the remote system. I can also manually upload the…

Hi Erick, I have largely solved this but still having trouble passing the GZIP file to the API. The root cause of this is that within Suitescript there is no in built handling of form data on the server side so I am having to do it from first principles. Please can you look at the following and let me know if you have any…

OK, I have submitted a support case. Thanks for you help.

OK. I got N/compress working, this creates a valid GZIP file which I tested by saving to the filing cabinet. And I can use N/encode to create Base64 to use in the form data. But the spec for the remote API says that the JSON must be UTF-8. I am not clear how I ensure that it is. In the N/encode documentation you can't take…

Thanks, that looks like just what I need.

Actually, I do need to solve this since I have another customer where the sales orders we are creating are sometimes for shipping domestically with one tax code and sometime are export orders so need a different tax code. So setting the tax code on the customer record will not work. I think I am beginning to understand a…

Hi Erick, thanks for checking, I really appreciate it. I double checked workflows etc but while checking I noticed there is an additional setting on the Customer record in the UI called 'Tax Item' (taxitem) and for the relevant customer this was not set. If I set this then it seems to enforce this tax code for all sales…

Thanks, that is very helpful! This solves my immediate problem but I am still wondering how I could have looked up the field name {item.taxrate1}

This is actually trivial. The cause is that I did not have this field enabled for the screen form. It was enabled for printing but not screen. The web service mirrors the screen form of course like elsewhere. Should have thought of that!

Fantastic, thank you. From reading the web services guide I see that in most cases I need to reference the Netsuite internal id, like in your example above. So I guess if I have the invoice number then I need two steps: - query Netsuite for the internal id - retrieve the invoice for that id (as shown above) Do you have…

Here in Sydney we have one user logged in and working fine but anyone starting a new session can't get past the login process. We have been using Netsuite for only a couple of months. I know there was one other major downtime incident when the whole system went offline a few weeks back but thats the only grief we have had.…

I still don't have a good workaround for this and have resorted to downloading files manually. I am not returning to this problem to try and solve it. The only solution I can see at present is to create a script in another language (e.g. PHP) and call that from the Netsuite script so that it returns a list of files on the…

Thanks, yes that is the workaround that I used. Works fine but just feels like it should be possible to create the search in the script!

Here is a SS1 scheduled script that does this. How do I do the same but in SS2? function main() { var folderid = '603907'; var filters = new Array(); filters[0] = new nlobjSearchFilter('internalid', null, 'is', folderid); var columns = new Array(); var filename = new nlobjSearchColumn('name', 'file'); var fileid = new…

I have it working with a vanilla CentOS SFTP server so would assume that most FSTP Linux based services should work.

Doing some more research on this and it seems that in SS2 a search for documents is not possible? Can anyone confirm? The syntax should be like this and of course this works when you create a saved search in the UI. var mySearch = search.create({ type: Search.Type.DOCUMENT, filters : myFilters, columns : myColumns });

Do you know if they achieved this using entirely Netsuite tools? I am hunting around to see if there is an add-on that might work. From what I can see its not possible to achieve this in standard Javascript and hence that is why the SFTP module is needed.

Perfect, thats a big help, thanks John

Thanks for confirmation, I must be missing something. Can you post a code snippet of how to search documents and set filter to parent folder? This is the first thing I tried but Search.Type.DOCUMENT doesn't seem to be a valid search type.

Understood, what I meant was that cloud SFTP services will most likely be based on a Linux backend so if thats true for the service you are looking at then should work fine. There is also this tool that allows you to test the SFTP server to see if it is compatible with the Netsuite module:…

Anyone done this before? I would really appreciate a code snippet for working with Fulfillments, thank you in advance.