My Stuff

JohnCCole

Comments

  • The answer is simple NetSuite needs to support CORS, but they don't. So you either have to put your code in a browser extension or create a web service, server side page on the same domain of the third party site or another domain that supports CORS which will call your restlet. I have not tried this with restlet, but I…
  • Ok I logged a case and afterwords using the concat method on a string everything works fine so. The following will fail var strRegEx = '^TY.0401.0.010'; var arrSearchResults = nlapiSearchRecord('item',null, [ ["formulanumeric: REGEXP_INSTR({itemid},'" + strRegEx + "')", "greaterthan", "0"] ],null); and the following will…
  • jdforrest in my companies particular needs I use one user for simple integrations and just configure the role to have access to what I need to provide in the integration. The problem with using a single account is NetSuite will restrict the number of concurrent requests I think to 10 per user. So if your app used the same…
  • Defect re-produced and filed Case #2312135 Update : Defect 247052: Client Side vs. Server Side Filter Expression problem
  • I am using the library NetSuite references https://github.com/ddo/oauth-1.0a
  • What does NTLM mean in this context? Curious what you mean by 'ntlm and a suitelet'. I meant NLAuth authorization must be my old windows days.
  • If you are making an ajax request from a client side script and your in a context of a suitelet authenticated session can you not just use the relative path [CODE]$.ajax{ url:'/app/and_the_rest_of_the_internal_url' }[/CODE]
  • So, Ii'm building an external app and wish to communicate with Netsuite via tokens. So far, things have gone fairly smooth (lots of trial and error, but I've got token-based communication with RESTlets working). Last step is end-user authentication. My hope was to allow the end-user a traditional login screen with…
  • Yes, I totally agree, so how am I supposed to implement the code suggested in the help center here? If NetSuite wanted us to employ one of those methods you suggested, shouldn't that information be part of their post? I think we can all agree that NetSuite's documentation is lacking, but that seems like vital information.…
  • This is a bug from my perspective. The following code runs fine on the client side and throws an SSS_INVALID_SRCH_FILTER_EXPR_OBJ_TYPE exception in a Suitelet. var strRegEx = '^TY.0401.0.010'; var arrSearchResults = nlapiSearchRecord('item',null, [ ["formulanumeric: REGEXP_INSTR({itemid},'" + strRegEx + "')",…
  • The javascipt framework suggested by NetSuite does not include realm in the authorization header. Now that I've corrected that I get invalid login attempt. I can see the attempts with an Audit Login search in NetSuite, at least I know the request is getting to NetSuite. The HTTP status code is 403, which by Netsuite's…
  • First step is to get your developer API access key if you have not goto https://www.ups.com/upsdeveloperkit Here is the contents of a template file I use at the start of every request. <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"…
  • I finally had some success.Turns out I was missing a file in my manifest of the chrome extension. If you find yourself needing to make calls to NetSuite Restlet with TBA from a javascript environment outside of NetSuite, and you use the referenced library NetSuite recommends https://github.com/ddo/oauth-1.0a You will need…
  • If you can post your XML that is being sent in nlapiRequestURL I can see if anything looks wrong.
  • I can confirm it can be done. I have done rate retrieval requests against both UPS, and DHL. The APIs are different but in principal there the same. Construct and XML string send it UPS/DHL parse the response.
  • No I'm not setting any headers. One line of code was missing from my sample code after make nlapiRequestURL you should have the following var strResp = resp.getBody(); var respDoc = nlapiStringToXML(strResp);
  • Figured it out the item column is orderline. SuieScript records browser has no mention of this field. Perhaps the best way to see what columns or body fields are available is to load the record on the client side and inspect the object returned.
  • Hi All, Then in my saved search i would create three results columns of type formula numeric and extract each of the values as follows: TO_NUMBER(REGEXP_SUBSTR({custcol_comment_field},'< tag1>(.*)</tag1>')) - For numerical values REGEXP_SUBSTR({custcol_comment_field},'<tag2>(.*)</tag2>') - Text Values etc. Don't you need…
  • I have had success on the client side doing the following filters[0].isor = true; filters[1].isor = true;
  • The BFO Big Faceless Report Generator invoked via nlapiXMLToPDF does allow you to create many documents within one using the pdfset tag does it not? &lt;?xml version="1.0"?&gt; &lt;pdfset&gt; &lt;pdf&gt;&lt;body&gt;&lt;h3&gt;Document 1&lt;/h3&gt;&lt;/body&gt;&lt;/pdf&gt; &lt;pdf&gt;&lt;body&gt;&lt;h3&gt;Document…
  • Not sure about the docfilecab:URL but the first error is because your not escaping the ampersand replace the & with & in the URL for that image. Instead of using docfilecab:URL could you replace it with a URL instead
  • I know this to be possible, so not sure what might be happening. In your suitescript code as a test have you tried to attach a file to a non - custom record? Can you post the relevant suitescript code?
  • Perfect, exactly what I needed. Instead of looping through all the fields I just call getFieldValue('total') on the object returned by nlapiGetNewRecord(). A value of null for total performs the same check without the loop. Thanks so much.
  • The work order is auto created by NetSuite, because the auto create work order column on the line item of a sales order was checked off. Not sure how NetSuite is creating the work order, but it would be plausible that it could be a user event script. So your saying a work order (or any other record type) created in the…
  • Just to contribute to the discussion as I too experienced some frustration on this. First the result. The only way I was able to call a suitelet from another script was to check off "Available Without Login", "Execute as admin", in addition I had to select the Online Form User under the audience tab of the script…
  • You can group by the internal id. Below groups and sorts the internal id var filters = new Array(); filters[0] = new nlobjSearchFilter('mainline', null, 'is', 'T'); filters[1] = new nlobjSearchFilter('trandate', null, 'onOrAfter', 'daysAgo90'); var searchresults = nlapiSearchRecord('journalentry', null, filters, new…
  • I did a custom solution for my company. Using nlapiGetJobManager and the related functions. I think it's what you want it allows you too merge entity records. Like the UI all merge operations are queued, so you need to store the jobid so you can check later too see if the job was completed, as the merge won't complete…
  • This is part of my back end code. The mergeOp variable you see in the code below is an object sent from the client side which indicates the master record and array of records that are duplicates. var manager = nlapiGetJobManager('DUPLICATERECORDS'); // Create the merge job object. var mergeJobRequest =…
  • I created a custom suitelet. Most of the duplicate issues in our company can be resolved via the fields that are indexed under the global search. The suitelet allows the users to search for a record (using global search behind the scenes). Results from that search are put in a merge bucket where they can specify the master…
  • We have some complex logic surrounding what processor to use. At the time when we first got on NetSuite I looked at the workflow and I didn't see the creditcardprocessor field as something I could set in the workflow so I used client side script. Just looked and I still don't see it available in the workflow unless the…