I have not seen the challenge described. We are using both v2.5 and v2.6 WSDL's with the same login / password combination without issue.

As an update, one should convert DateTime to UCT. This changes: 2007-09-01T00:00:00 to 2007-09-01T05:00:00Z Silly me...

IMHO Relying on NetSuite to handle the queue is going to bite you at some point. If you write your own reservation / lease / release queue, then you can prioritize the availability of sessions. If you build a table that holds: email, password, account, role, maximum logins, current logins Then you can increment / decrement…

Part II We use this same concept for web services with Google, etc. All web service code obtains the login through the same queue mechanism. The second advantage is that the credentials are soft coded in all code. If we need to adjust the process, we change the stored procedure rather than 100's of pieces of code.

Have you filed a case with NetSuite? What is the case #? Support case 604382.

Now I understand you question but I do not know the answer. I have not worked with Sales Rules and Sales Territories. That said, I would guess that with the combination of web services and SuiteScript, that you could make it work. You may have to duplicate logic but at least it would be in the same system.

Danail, ...that the Sales Force Automation is not supported in Web Services. Can you please confirm that it will still be not supported in the 2007 release of NS CRM? The 2007 (v2.6) and I believe v11.x (v2.5) support opportunities, activities, and support via web services. Personally I have used activities but not…

Wow - cannot believe it has been 6 months since I worked on this part. The vb.net code below works: Dim custitem_large_image_default As New SelectCustomFieldRef() custitem_large_image_default.internalId = "custitem_large_image_default" custitem_large_image_default.value = New ListOrRecordRef()…

Here it is: 274 is the InternalId of the File in the file cabinet 29 is the TypeId of the file cabinet. Dim ns_custitem_my_image As New SelectCustomFieldRef() ns_custitem_my_image.internalId = "custitem_my_image" ns_custitem_large_image_default.value = New ListOrRecordRef() ns_custitem_large_image_default.value.internalId…

UnitType cannot be modified in the UI nor via web services. saleUnit, stockUnit and purchaseUnit can be updated via UI or WS.

VB.net code In a bit of a rush at the moment, if you have questions, send private message. 'Used for the NullFieldList for NetSuite Dim tempNullFieldList_AL As New ArrayList() 'Do we have a value to send If Row.ScratchCtProductsUrl_IsNull = False Then custitem_temp_urlcomponent.internalId = "custitem_temp_urlcomponent"…

My prior example was a bit too confusing, I shall try again: currentItem.nullFieldList is a one dimensional array which lists the internalId's (field names) of all custom fields that should have a null value. cfArrayList is an array that used to build currentItem.customFieldList. You cannot dynamically add to…

Never mind. My brain seems to have come back. :) For some reason, it did not register that .customFieldList is an array...

Would anyone have a sample snippet on how to update a Custom Item Field? To be a little more specific, I am looking for how to initialize and set the value for a Custom Item Field. Our current code will update the Item, update record refs, image fields, etc.; just have not mastered the custom fields.

dwhitfield, Thank you for asking. Yes, I did figure it out. NetSuite web services is challenging to figure out. The documentation states what it does but at least 50% of the time, you cannot find sample code. I need paint by numbers... :-)

Yes, you can import closed orders via web services. You set the "Closed" flag at the "Sales Order" item detail level. When all item details are closed, then the "Sales Order" header is therefore closed. There is no impact on g/l or a/r. It will allow you to attach to a customer and create queries based on what the customer…

Robert - Thank you for the insight. Great suggestion and I will study how to create the PO from the sales order via web services. This will be an interesting exercise. I am guessing the sales order must be open to create the drop ship PO. I would need to create the sales order as open, create the purchase order as open,…

Duh, I forgot ...Specified = True currentFile.attachFromSpecified = True That is twice I have forgotten it. :-( Ahh, but it works now! You can create files in the file cabinet using WSDL.

Sunil, What do you mean by test instance? You can pay NetSuite for a sandbox to test. I would guess the sandbox would let you execute web services. You cannot execute web services in the "demo" instances that you may get from your sales rep. Hope this helps.

trying to get the externalid generated by Netsuite, The soap response should contain both the internalid and externalid. On inserts, you set the externalid on the way into NetSuite and it replies with your externalid plus the internalid it created. On updates, I would suggest you provide the internalid along with your…

1) Row.NewContent is a MS-SQL blob. It can be written to the file system or written to a SQL table. 2) The error received is "ERROR: USER_ERROR - Please enter value(s) for: Attach From " Dim currentFile As File = New File() Dim tempFileLength As Integer tempFileLength = Convert.ToInt32(Row.NewContent.Length())…

In wsdl v2.6 yes, in wsdl 2.5 no. You can upload the file into the file cabinet. All I have tested is into the images sub folder.

"A record with the same unique signatures already exists. You must enter unique signatures for each record you create." As I understand it, within the UI, this error occurs when the Entity_Id is duplicated. For example, on the contact record, you might have "Seifert, Ryan". If you tried to enter a second "Seifert, Ryan",…

Steve, Was this matter resolved? I just realized you referred to "packages". Does this refer to v2007.0 packages so you can specify dimensions? If so, do you need WSDL v2.6? Just a thought. You have helped me more than you know.

It is my understanding that if there is no activity on the WSDL login for 15 minutes, the connection is dropped.

I am not clear where the 565 of "Invalid entity reference key 565." is being set. Is it implied in the c# code and I am missing it?

Is it the case that the nullFieldList is only used to set custom fields to null? Long, Have you determined the best way to set non-custom fields to null? My specific issue today is with date fields but I would guess the same technique would work for all fields. Is there anything special to do in order to set out of the box…

Thanks for the question, it did make me think if the field is necessary. The functionality of knowing when an entity is created is important to us. I am simply trying to maintain a backwards audit trail to our current system. For example, on items it is nice to see that an item was created in to "our system" in 2004, 2005,…

We would like to import Sales Transactions from 2004. 98% of the transactions were credit card transactions to residential customers. We would like to use this sales information for our marketing campaigns. If we import these sales transactions as Sales Orders, wouldn't NetSuite always see these as outstanding orders that…

This cannot be done. If you import a cash sale, it hits the GL. :-(