3957865

Did you get this working? I am having similar trouble. I need to create a search for all sales orders and the amount paid on any associated bills on a line item basis. I can get the SO line item data just fine. I can then get the bill data and group by the sales order number. But the paid/remaining data is stored in the…

OK. So it seems that I was having trouble with Summary views and the basic stuff is pretty straightforward. IN case anyone wants to know, something like this... LAG({transaction.internalid},1,0) OVER (ORDER BY {entityid}, {transaction.internalid}) ...will order by entityid then internalid, and then show the internalid of…

Is anyone using LEAD or LAG? I can't seem to get even the most simple LAG expression to yield anything other than an "Invalid Expression".

Ah. Of course! Filter Expressions. Thanks very much indeed. Rich

Here’s what we did: 0) Starting from clean 1) Import creditor balances (AP) including original transaction fx rate 2) Import debtor balances (AR) including original transaction fx rate 3) Ran NetSuite trail balance and noted down the original AP and AR balances ’APB’ and ‘ARB’ (these are the ones that don’t match ours as…

I am burg inning to think it may be a chunking issue. Does anyone know if Netsuite has issues with Transfer-encoding : chunked ?

I've had some feedback from NetSuite support, who have been looking a the issue: Chunked transfer encoding is not supported by the NetSuite APIs. If you want to download files using nlapiRequestURL you must use single block transfers with Content-Length set in the header, apparently. Another thing I noticed, that is…

Thanks Daniel. Yes, I have it working in Postman. Great tool. Now I want to test the code for my calls, so I am using the browser console to get them right. Quicker than uploading new client side script. The answer, in case anyone is looking, is that the inbound data in the RESTlet needs to be parsed into an object: var…

Sory, by NULL I meant excluding it altogether. If I do not add 'Accept" to the header (ie: do not add headers['Accept'] = 'application/json') or include any other type (eg: headers['Accept'] = 'application/pdf'), then I get an 'Unacceptable' error back from the server. If I add headers['Accept'] = 'application/json' then…

Stripped bare example: This works in client side code: var headers = new Array(); var response = nlapiRequestURL(encodeURI('https://depts.washington.edu/owrc/Handouts/Hacker-Sample MLA Formatted Paper.pdf'), null, headers); This fails with an "Unexpected Error": var headers = new Array(); var response = nlapiRequestURL(…

In case anyone needs a workaround, this simple "de-chunking" proxy server written in Node.js will do the job (you'll have to run it on your own server obviously): var http = require('http'); var UnchunkedResponse = require('http-unchunk-stack').UnchunkedResponse; http.createServer(function(request, response){ var…

And I don't have much control over the server side. It's an integration with our local post provider. I need to download a pdf of the resulting courier sticker and its that that's failing. If I knew what the error was, header or otherwise, I could ask the developers on their side to make some changes, but without a clear…

Thanks Carlo. That's a good lead. Perhaps it's a header issue? Chunking? Without knowing how net suite handles the response on my behalf I am having trouble working out exactly what the problem is. The error doesn't give anything away. I have a ticket open with Netsuite but I'm not getting much feedback. Should be easy…

Thanks very much, Marlon and Daniel. Is there a best practice for securing RESTLets? They have different permission levels to SuiteTalk services for me. I need to allow a third party to enter purchase orders and look at stock levels via HTTPS and I need to allow our own services to do a lot more via SuiteTalk. I seem to…

Can't view customer or supplier records. Unexpected Error.

Thanks Oliver. I want to find out why our Sales Team can't see the Purchase Order Register reports. And I can't see where those permissions are set. I have customized one of them and just can't seem to find out how to give them access.

Exactly the same here. We have to export as CSV if we want anything useful.

Thanks Oliver. NS Support have marked it down as a defect. I'll update here when I know more.

Sadly, no update yet.

"Advanced Bin/Numbered Inventory Management" is turned on...but we are not using it at this stage. We may use this in the future but right now nothing is binned. Plain old inventory items, with no Lot or Serial numbers.

Thanks very much Evan. That worked very well indeed. It appears my problem was trying to give users a link to that page. Searching for it yields nothing...I had to get the URL and add it to their menu manually. Thanks again, Rich