user10648298 Newbie

Take a look at the sample code on the portal, both for Java and PHP (I'm guess you are not a .NET shop). Also the documentation in the product (help link in the upper right corner) is very good. It's keyword searchable. My advice would be to use JDBC to query MySQL, and then transform those new/modified records into in to…

Can you file a case with a very specific time range where this happened and the soap you saw from your side? -John

Just remove the applicationId- it's there as demo code, but applicationId should be used for specific applications known to NetSuite. -John

Could you please create a case with support including your SOAP and post the case # here? -John

What is the error message? John

Check the ws usage log to make sure that the requests are being made and are sucessful. You may also want to consider our odbc interface if you are going to be doing a lot of reporting. -John

Whether you can set tax rate is determined by what tax code you pick. Generally you would pick a tax code (eg ca-Santa Clara ) and let the system set the rate. -John

One minute per record is way too high. Can you file a case with SOAP/email address (of the user submitting the job)/ and exact date/time when it happened? Please post the case #. Thanks, -John

It can be, but you would probably want to do *inbound* single sign-on in that case. However, if you are on the desktop, why not use email/password since you can store them securely? It would be difficult to go outbound from NetSuite to a desktop app as there is almost certainly a firewall in the way. -John

You are correct. Externalid has to be unique by general type eg item, entity or transaction. You can include the record type as part of the externalid if you want to segment that way. -John

Sorry - you need to be logged in to NetSuite to see that link. -John

The code looks ok - what does the soap look like? -John

I think you need to initialize() (which will return a cash refund with the original items), you can modify the lines on that and add() and it will preserve the transaction links. -John

Not in 2009.2, but we're doing more work on Single Signon and it is on the roadmap - please vote for enhancement 135687. -John

I believe it is in the "memo" field of the sales order. If you have the "show internalids" preference on, if you click a field's label in the browser it will give you the Field Level Help and in the lower right corner the id of field (eg memo). -John

phone and mobilePhone shouldn't be RecordRefs (RecordRefs represent foreign keys basically). phone and mobilePhone should just be the text of the phone numbers. eg contact.phone = TelNo; RecordRef in .NET is an object with 3 fields (name, internalId, externalId). -John

NetSuite has both inbound and outbound Single SignOn capabilities as of 2009.2 A good place to start is the help https://system.netsuite.com/help/helpcenter/en_US/Output/Help/SuiteFlex/SuiteSignOn/SSOOverview_Single_Sign-on_Overview.html#1001000 Inbound Single Sign On has been around for a long time. To set it up you must…

Oops - and your account needs to have been upgraded to 2009.2. I PM'd you. -John

Are you using Advanced Search? That is significantly faster than get or standard search. -John

I think you should repost this in one of the Web Site / E-Commerce forums https://usergroup.netsuite.com/users/forumdisplay.php?f=20 -John

The latest version is 2009_1 - http://www.netsuite.com/portal/developers/resources/suitetalk-sample-applications.shtml Where did you see samples for 2_6? -John

By default search returns "bodyfieldsonly" meaning no sublist fields. Use searchPreferences and set bodyFieldsonly to true John

You should be able to get a static list however, since it is enumerated in the WSDL under the commonTypes xsd https://webservices.netsuite.com/xsd/platform/v2009_1_0/commonTypes.xsd -John

This is issue 160871 - please file a case and ask support to attach it to this issue. -John

We do not support formula columns in this release, it is definitely on the roadmap. -John

Can you post the SOAP/source code for your PO upload? -John

My first thought is it's strange you define the ns7 namespace twice <add xmlns:ns7="urn:messages_2_6.platform.webservices.n etsuite.com"> <record xsi:type="ns7:CashSale" xmlns:ns7="urn:sales_2_6.transactions.webservices. netsuite.com"> Could this have changed recently? -John

The constant you want is the ItemType enumeration in accountingTypes.xsd. You want to specify NonInventoryItem <!-- ItemType constants/start --> <simpleType name="ItemType"> <restriction base="xsd:string"> <enumeration value="_assembly"/> <enumeration value="_description"/> <enumeration…

In the browser is "location" dropdown populated only after the customer (or some other field) is set? If so, the current version of GetSelectValue does not support this type of dependant relationship. -John

Yes, ItemSearchBasic does have a "price" field that is a SearchDoubleField. However, I believe this is only the Base Price, so you can't search for Quantity prices or different price levels. -John