:o :o :o Oops, it appears that while the internalId is displayed in the UI, the internalId is not returned via WSDL. Once internalId is specifically added to the saved search, this is how to get the value. (vb.net) DirectCast(DirectCast(searchResult.searchRowList(i), ItemSearchRow).basic.internalId(0),…

Here is an attempt to scale down code to demonstrate how to do it in vb.net. Note: This is running within the context of MS-SSIS. Also comments using "//" instead of standard vb.net comments. Private oItemFulfillmentPackageUpsUpsList As ItemFulfillmentPackageUpsList = New ItemFulfillmentPackageUpsList() . . . Dim…

try the magic search value "@NONE@" Ironside, Thanks for the tip, I will give it a whirl.

*** Bump *** I am sure it is easy, I have search for about 4 hours and cannot figure it out.

...I have never needed to call SuiteTalk methods from javascript... How would the error control work with this? Does it become: UNEXPECTED_ERROR -> UNEXPECTED_ERROR or UNEXPECTED_ERROR -> UNEXPECTED_ERROR -> UNEXPECTED_ERROR? Seriously, it seems the error control would get nasty. You would have SuiteTalk bubbling to…

Anyone know how to set a time of day custom field? There is no TimeCustomFieldRef. Use DateCustomFieldRef() This is vb.net custitem_inventory_as_of_time = "Time Of Day" type on item record Dim custitem_inventory_as_of_time As New DateCustomFieldRef() custitem_inventory_as_of_time.internalId =…

Have you tried "any of" "- none -" ? I am trying to do it via the WSDL, maybe "1" is the value I need to use. I will test it.

*** Bump Bump *** How does one search for NULL?

Steve, Just curious would you be able to perform this search with the Saved Search in WSDL 2008.2?

Has anyone written a web service's client in VB .NET? Not sure what you mean by this statement. There quite a few NetSuite customers who use vb.net to talk to the NetSuite WSDL. What specifically are you looking for?

Have you tried using Job : Start Date -> after and including (today's date) ? Job: Start Date Filter: After and Including Date Range: custom From: 9/9/2008 I was not clear in my original post. I would like something dynamic where I do not have to continually edit the filter on the report. I have been using between to date…

Oops, left out an important question. We would prefer to do an XML version of the 940 and 945. Would anyone have sample XML and/or XSD's to share?

...you can find the list of webservices record names by moving to class view in VS and expanding the NS web reference.... Dave, Thanks - needed that.

Has anyone experience with creating a local Data Warehouse that is synchronized with your NetSuite account? We use web services to create a local "Data Repository". I say data repository because the data structures on the local side are the same as NetSuite and there are no slowly changing dimensions. (SCDs) We do use data…

I do not know how to fix the error completely. If you change your shipping from real time, you can get the order inserted properly. I was never able to figure out how to get real time rates to work when inserting an order via wsdl.

3 : when i retrieve the sales order i perform a Get() on the related customer and then loop through the addressbook to match the addresses #3 is the reason I went down the path of creating a bunch of custom address fields. Then I can just loop through the XML on the sales order rather than make another request for the…

Dave, The next version of WSDL will have the address information "fielded". The solution I was able to get to work is: https://usergroup.netsuite.com/users/showpost.php?p=38163&postcount=11 This post is part of the much longer thread: https://usergroup.netsuite.com/users/showthread.php?t=7719

Is it possible to trigger a Server SuiteScript on a record created/edited by Web Services? Jim, There is no DIRECT way to call a SuiteScript from web services. That said, web services is basically a programmatic user. If you have a user event that would fire when a user saves a record, then the same user event can fire for…

System-to-System as it pertains to smbXML is a method of moving data from one NetSuite System to another NetSuite System. If you have system-to-system integration which uses smbXML, then you need to port that functionality to web services quickly.

Suppose a web service is loading records... I could see a before-submit slowing things down a bit (depending largely of course on what the script is doing). From the perspective of the web service only: Would an after-submit be less likely to slow things down? ie. While the after-submit is handling record n, web service…

Steve, Are you using web services to add the record with an beforeSubmit userevent? Maybe the beforeSubmit is changing a value? Does the webservices call run ok without the beforesubmit? Just trying to brain storm here? You are always working on something interesting...

What version of the UI? What version of WSDL? Have you tried setting shipAddressList to the ship to address on the customer record? This should enable the fields to set properly on the sales order.

Once UPC code is your externalid, do an itemSearch based on externalId. Brad, In my opinion, you have three decent options: 1) Use web services as described by John and Ray. This is a solid choice. My mild concern is the combination of # of requests and speed. You would definitely have to put multiple UPC's into one soap…

Brad, Ok - so I am guessing the business purpose is something like this: DVA gets boxes and boxes of DVD's and when the check in occurs, you do not know if an inventory item record exists inside NetSuite. If the upc does not exist in NetSuite, then you want to create a list of DVD's for someone to add into NetSuite. Is…

Brad, Couple of questions: 1) How often does this process need to run? (once per month, per day, per hour, on demand?) 2) How fast does it need to happen? (1 minute, 1 second) 3) What is the source data? Is someone providing you an excel spreadsheet? Or is a user hand entering the UPC code? 4) What is the volume of data?…

Interesting -- I was hoping it was just: PN Ref # Authorization code That would be required.

Steve, I am interested in seeing your code. I am wondering if I could use your technique to create a vendor bill from a drop ship purchase order. I would need to create the vendor bill and then retro attach it to the purchase order.

I just tried it and Netsuite performs a sale transaction, not a capture. Mike, Did you try doing this in the UI? 1) Create the sale and populate all fields like Long suggested? 2) Then "bill" the sale to create a cash sale? If 1 and 2 work in the UI then it will work via web services.

Steve, That is cool. The key is the COMMAND_TOKEN. Maybe I can use this concept to help some issues we have.

Jamie, Has this been resolved?