John, Will be glad to create an enhancement but first I would like to brainstorm a bit to develop what the enhancement request might look like. To rehash the business goal, I need to automate the process of sending a data feed to GoogleBase, PriceGrabber, JellyFish, etc. What is needed for the feed that web services does…

-m, Any UI user can login as a web services user. The best place to start is: v2.6 SuiteTalkWebServicesPlatformGuide.pdf v2.6 SuiteTalkWebServicesRecordsGuide.pdf

Oh man. So when NetSuite emails the Saved Search, it converts currency values to strings. For online price, if the amount is less than 1000, everything is ok as the CSV values are comma separated without quotes. As soon as there is a value of 1000 or more, then NetSuite is putting quotes around just that value:…

After further thought, we cannot use web services to determine what items are active. The soap response is ~7mb. If we poll 4 times per day that is 28mb in storage that goes against our 10gb limit. Oh well, I guess I will write it against the save search that is emailed to us once per day. Why would I want it four times…

You cannot create a VendorBill from a PO. Issue number: 133535 The error is: <ns2:statusDetail type="ERROR"> <ns2:code>INVALID_LIST_ID</ns2:code> <ns2:message>You must specify a valid line ID. Please set orderLine.</ns2:message> </ns2:statusDetail> The only work around is not acceptable for us. That would be to update a…

All of this is opinion from 20 years experience in the technology world. That said, I have not made my living by programming since the early 90's. Good - In general, NetSuite's web services are relatively technology agnostic. You can use whatever language / tools you want to talk with web services. We use Microsoft SSIS as…

John, When you say to include the timezone, would provide an example? Like ogomo, we too use the .Net 2.0 DateTime objects which create SOAP datetime of 2007-10-11T00:00:00.000-07:00. When you send 2007-10-11T00:00:00.000-07:00, isn't the timezone inferred to be Pacific Time? (November 11 2007 at 00:00:00.000 (24 hour…

We are restoring the old behavior via issue 134298. John, Two questions: 1) For the rookie (me) would you describe the old behavior? I jumped on at v2.6 beta so I do not know the previous behavior. 2) Will the sending of the timezone supersede the "old" behavior?

Oscar, Let me know if you figure this out. You cannot create a VendorBill from a PO. Issue number: 133535 The error is: <ns2:statusDetail type="ERROR"> <ns2:code>INVALID_LIST_ID</ns2:code> <ns2:message>You must specify a valid line ID. Please set orderLine.</ns2:message> </ns2:statusDetail> The only work around is not…

Suite, You are correct, it does not work. Issue number: 133535 The error is: <ns2:statusDetail type="ERROR"> <ns2:code>INVALID_LIST_ID</ns2:code> <ns2:message>You must specify a valid line ID. Please set orderLine.</ns2:message> </ns2:statusDetail> The only work around is not acceptable for us. That would be to update a…

Jan, Yes, I have seen that issue many times. I always forget to convert the time to UTC. Webservices does not understand the timezone settings in the UI. You must manually convert the time to reflect a timezone. For example: 2007-10-11T00:00:00 would be 2007-10-11T00:00:00.000-07:00 (Pacific Time)

Lists | Accounting | Shipping Items I made sure there were not "UPS Real Time Rates" setup. I used flat rate = 0. You might be able to simply set all real time rates to "Inactive=True"

This is the update as of 10/31/2007. Issue number: 133535 -- Slated for q1 2008. Fast forward to 9/10/2012 and I received an email from NetSuite that Issue 133535 has a status of "Closed - Released in New Code Version" Details: The 2012.2 endpoint supports transaction links between purchase orders and vendor bills,…

Mmm. UPDATE: reading over the JAVASCRIPT code, it all makes perfect sense. I salute you for putting your code out there for all to see. However, one line that I read did give me pause. Line 43 is.... It looks like I'm comparing the value of a field to... the value of the same field. Should one of those be…

Manish, The way I differentiate is this: 1) Web Services: Use this when you want to get data out of or into Netsuite. I would not generally use web services for work flow. 2) SuiteScript: Use this when you want to automate work flow including setting field values on a prospect record when an opportunity is created. You can…

I keep thinking that this must be a bug rather than an enhancement, because it's an explicitly listed capability of Netsuite. You can download the Suitetalk platform reference guide today (last revised on 17 November 2008) and go to page 205. It's a table of transaction types and initialize reference transaction types for…

NetSuite Case 632953 Very perplexed... If I remove <q1: orderLine>1</q1: orderLine> then the vendorBill is created but then there is not link to the Purchase Order. &lt;?xml version="1.0" encoding="utf-8" ?&gt; - &lt;soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"…

JMPUser, I have seen a similar error. I had to temporarily shut off the shipping items to make it work. I am sure there is a better way to do it but that is what worked for me.

Manish, I think that when you create the opportunity, the Lead will automatically become a prospect. From there, are you wanting to do this via web services or suitescript? Since this was posted in web services, I presume you want to do it via web services. If web services, what language? java, c#, vb.net, php, etc.?

With the 2012.2 web services upgrade, it sounds as if by linking the PO to the Bill, the correct account (COGS for drop ship and Inventory Received Not Billed for DC receipts) will follow over to the Vendor Bill. Can you please confirm that assumption? Yes, this is the assumption. Prior to 2012.2, the way I had to do it is…

This is the update as of 10/31/2007. Issue number: 133535 -- Slated for q1 2008. The error is: <ns2:statusDetail type="ERROR"> <ns2:code>INVALID_LIST_ID</ns2:code> <ns2:message>You must specify a valid line ID. Please set orderLine.</ns2:message> </ns2:statusDetail> The only work around is not acceptable for us. That would…

John, I thought the same thing, I had to do a double take. I think Scott is setting the created FROM not create date...

... how about that suitescript you mentioned before?... Jimmy, Sorry for the delay in getting back -- busy season... The WSDL code is checking the PO detail to see if the quantity, price, etc match at the detail level. It will throw errors on the receive. If invoice for the drop ship PO matches at the detail level, then…

...(create a vendor bill that's properly associated with a PO)... bigjimmyk3, You will be stuck for a while. Please vote for enhancement 133535. This enhancement would allow you transform a vendorBill from a PO. You cannot do this with the 2008.1 or 2008.2 wsdl. Our workaround was to compare the EDI 810 against the PO. If…

Scott, I looked at your code and did not immediately see the issue. Have you considered using the initialize function found on page 133 of the web services platform guide? It would initialize all of the fields for you and then you adjust accordingly. I learned about it last week and have found it quite nice.

I'm trying to figure out how to do this in PHP. Any luck yet? Ultimately, I figured out the best way for our case is to iterate through ItemFulfillmentItemList.item until I find the correct orderLine. In this case, we are processing the notice from the vendor that our order has been fulfilled (EDI 810 / Vendor Invoice).…

*** BUMP *** NetSuite Case: 628074 Would anyone from NetSuite be able to provide assistance here? When creating an Item Fulfillment record, WSDL v2.6 wants orderLine to be specified. The challenge is that I have a drop ship PO in XML format coming from a vendor. This is the notice that something has shipped. I need to…

Any updates as of today? Anyone get this to work? Yes, we have fulfillments working fine. The code is a little challenging but it does work. The code is in vb.net, be pleased to share a sample. The challenge lies in creating an vendor bill against a drop ship PO. This CANNOT be done.

Soap response from v2.6 &lt;?xml version="1.0" encoding="utf-8" ?&gt; - &lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt; - &lt;soapenv:Header&gt; - &lt;ns1:documentInfo…

The code below is the heart of the WSDL call. By the time we get to this point, we have read the purchase order out of NetSuite. We have also read the EDI 856. The PO and 856 have been compared / contrasted. The UPS tracking numbers have been located. The record set being passed to this snippet is de-normalized.…