3950714 Newbie

We haven't done anything special on the results tab; we show the preferred vendor, display name, the usual quantities (backordered, available, on order, PSL, ROP, etc.) and some vendor custom fields that tell our purchasers how to work with the vendor.

Here is what we wound up with: ( Discontinued (Custom) is false And Inactive is false ) And (( Preferred Stock Level is 0 And Formula (Numeric) is greater than 0 NVL({quantitybackordered},0)-NVL({quantityonorder}, 0) ) Or ( Preferred Stock Level is greater than or equal to 1 And Formula (Numeric) is greater than 0…

We have been doing this sort of thing (external website communicating with Netsuite) for a couple of years. We were pretty excited to read about the RESTlet interface but in working with it, we have had problems with our searches timing out and/or being truncated, with the server-side error being the ever-helpful…

Thanks for your comments, we continue to grapple with this problem. Now I have an interesting one: we have 2 user accounts that, even with the same role id supplied (admin), return different results from the same restlet. One user account returns the results we'd expect, but the other one always receives a blank string…

I just logged in as Joey (using the custom role previously mentioned) and I was able to view the results of the saved search on netsuite.com.

To follow up my own post, I have 2 users: Jimmy and Joey. Both have the administrator and "custom category manager" roles. Using Jimmy's credentials and the custom role, I can execute my restlet request and receive back all the results I desire from a saved search. Using Joey, the same request returns me a blank string.…

Brett, thanks for the snippet. With a little modification I was able to incorporate it into the RESTlet work we're doing. Very useful!

One thing to consider about these records is that if you do a refund from a cash sale, it may affect your inventory in unexpected ways. We always start an RA and do the cash refund from there, even if we're not actually receiving the item back (e.g. if it was cancelled prior to shipment). That seems to keep our inventory…

We have been using Netsuite since 2007 in tandem with our X-Cart based site. When we started looking at Netsuite "back in the day" we examined the e-commerce part of it and determined that it would have been a big step backward for us wrt flexibility, SEO, and general product presentation. Instead, I wrote an app that…

I'm having a problem very similar to that reported by Nancy. When I make an initialize call to create a Return Authorization from a Cash Sale, the record I get back has a plethora of custom fields on it. Most of these custom fields are not at all applicable to any Return Authorization form, so when I try to use that…

owain, we have used both and are moving in what appears to be the opposite direction: from SOAP to REST. We have found the SOAP interface to be slow for most of what we do, and the REST interface has been much faster. Others may be doing more complex operations that require SOAP but so far we have had great success sending…

Wow, we have been using netsuite from Ruby since 2007 or so and I had no idea this was out there. It appears to be much more organized than our soap4r-based client. I have already forked it and we'll be examining this in detail shortly. Thanks for putting it out there! Jim

We have used the services of a company called SPS Commerce (we have no in-house EDI talent). You provide them with a seat license, and they pretty much take care of the rest.

It turns out that intercepting your own SSL traffic is not so hard. I installed Charles (www.charlesproxy.com) and used it to intercept my web services requests in flight to Netsuite's servers. The results were definitely not what I expected: I was unable to replicate any of my previous errors! Something about what the…

More research has verified that the missing character always occurs at the same byte position in the request (I sent two near-identical requests and confirmed that the error happened at relatively predictable locations in each request). Also, I checked on how my wiredumps are being generated and they are coming straight…

Thanks for the note Josh, nice to know it wasn't just me. As you said, Netsuite appears to have resolved the problem over the weekend. We noticed that all of our requests started working on Saturday or so and we have not had any more problems since then.

To follow up my own post, I've made the following discoveries: 1) In Netsuite, I managed to find one of these requests in the Web Services Usage Log (most of them do not show up there). In the logged request, the missing character was in fact missing. 2) The problem appears to affect only larger web services requests. I'm…

This bug just bit us over the weekend, since we were forced to update to the 2010.1 WSDL by another bug. Think this will cause Netsuite to bump up priority on this one? That would be really nice.

Thanks for following up on that. I do have an open case now, 1246555.

I'm having a problem with updating Inventory Items via web services as well, but the error is slightly different. The error I get is ""Uniqueness error - there is already an item with that name or name/parent combination." I just figured out that it probably wasn't my bad, so I haven't started a case yet. On to that next.…

One other note, for those using custom forms; updating to 2010.1 may compromise your ability to update Customer records: https://usergroup.netsuite.com/users/showthread.php?t=22243

I can confirm that migrating to the 2010.1 WSDL fixed the particular problem I was having with items and prices. It also introduced a new problem in another area, but it did fix this one.