My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
Going to SuiteWorld? Connect with SuiteGurus—Your NetSuite Product Experts!

Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.

mkns Green Ribbon

Comments

  • We are also newly receiving this exact same error, even though none of our line item processing scripts have changed. Did something change on NetSuite's end? "TypeError this.miniform.elements.lineindex is undefined" It appears inconsistently (running the same code/same situation won't always reproduce it), and is somehow…
    in Question about return error Comment by mkns Jan 18, 2013 3:49PM
  • We still haven't received a solution but I can confirm it seems to only appear in newer versions of FireFox. We primarily use/used FireFox, so that doesn't really help too much, but we're using Chrome as a workaround. It also seems to happen on Mac much more than Windows but I haven't been able to determine exact…
    in Question about return error Comment by mkns Feb 1, 2013 12:20PM
  • Hi Lorne, I have created a case and given the exact Client script code file and function where this problem seems to occur. As noted in the case, this code file is carefully source controlled and definitely has not changed in many months. Although it may turn out that we were doing something wrong, I still heavily suspect…
    in Question about return error Comment by mkns Jan 18, 2013 5:07PM
  • Hi Marty, We are now exporting the data from Saved Searches in an automated manner to a separate system since we need snapshots to track the history better, but essentially yes the Saved Search API/GUI ended up being sufficient (but of course not ideal) for our needs. -mkns
    in Get Saved Report (Not Search) Results via Script Comment by mkns Sep 10, 2013 3:46PM
  • Just an update here...we discovered that using 2012.2 API for Saved Searches and using extremely complex Account by Account logic-based formulas allowed us to reproduce most reports we were interested in but in a parametrizable way. This is superior to what I was trying to do with Reports, although it is much slower (but…
    in Get Saved Report (Not Search) Results via Script Comment by mkns Jan 2, 2013 7:51PM
  • Hi Ivan, Depends on how you define "mission critical" but the reason I am doing this is indeed relating to a very important project for my company. I have been tasked with reporting data in a very specific way, and NetSuite Reports seem to contain certain columns that absolutely cannot be produced in any other way (even…
    in Get Saved Report (Not Search) Results via Script Comment by mkns Nov 14, 2012 1:33AM
  • Funny you should mention this. I suspect very soon I will at least make an attempt to do this by requesting the CSV version of a Report in the nlapiRequestURL call. Will let you know if that works.
    in Get Saved Report (Not Search) Results via Script Comment by mkns Oct 26, 2012 4:11PM
  • This seems to be doable. You need to reverse engineer the communication between the browser and NetSuite, but I *think* it is reliable. (I know the below is messy, and I'll plan to clean it up, but I'm curious if it works for everyone else). Step 0. Post as a parameter to your script the JSESSIONID Cookie value from the…
    in Get Saved Report (Not Search) Results via Script Comment by mkns Nov 3, 2012 8:04PM
  • If I run a Report in the GUI, grab its hash key using fiddler, and then hardcode that into my script, I can reliably access it as a CSV but the problem is I still don't know how to pass parameters. To call the Report itself you just need to use nlapiRequestURL and set the JSESSIONID Cookie. I use a Client Script to grab…
    in Get Saved Report (Not Search) Results via Script Comment by mkns Oct 30, 2012 3:27AM
  • I think all of the information here is correct. As far as I can tell Sourcing & Filtering is extremely limited and doesn't support a full Saved Search as the criteria for a built-in/custom field select filter. I think the "official" solution is indeed to create dynamic placeholder field(s) to store your custom/dynamic list…
    in Attaching a dynamic list to a field and changing its content through script Comment by mkns Sep 18, 2012 7:49PM
  • Hi, Thank you all for the feedback! Right now, I am basically using a variation of Brett's initial suggestion. I am searching for ALL Invoice line items (and tons of fields) using very broad saved searches and concatenating the results together so that I can MANUALLY re-loop through the array and perform…
    in SuiteScript Usage/Governance Limit Workaround Comment by mkns Jul 11, 2012 11:30AM
  • Hi, "minifying a javascript file doesn't have to change any variable or function names" Yes, I suppose that's true. I think this is what is usually done though, right? Not a big deal either way I guess, assuming you do this for ALL scripts so that your Client/Server scripts are not minified in different ways. "There is…
    in minify or pack SuiteScript files? Comment by mkns Jun 25, 2012 11:10PM
  • Hi amccausland, With respect to the search code and the .setOr issue, the problem has to do with using that undocumented API in Client Script (see: https://usergroup.netsuite.com/users/showthread.php?p=147857#post147857). You bring up an interesting point with regard to fuzzy() and undocumented Oracle backend access. I…
    in Proactively STOP / DISCOURAGE Duplicate Creation Comment by mkns Jun 25, 2012 1:25PM
  • I am no expert in this area, and I can't answer your performance question for certain, but my default assumption would be that you would see virtually no gain because I would not expect that the file(s) are being transferred anywhere upon execution let alone transferred rapidly/frequently. Also, isn't it actually extremely…
    in minify or pack SuiteScript files? Comment by mkns Jun 25, 2012 7:47PM
  • I wanted to do something similar for probability...I ended up having to use Saved Search API to load a Saved Search created in the GUI for what I wanted and then I output the filters using nlapiLoadSearch and searchRecord.getFilterExpression();... Apparently I needed 'TRANDOC.RPROBABILITY' instead of 'probability'.
    in Filter systemnotes by field Comment by mkns Mar 2, 2013 3:48PM
  • The single IP "167.216.128.40" doesn't seem to apply to my instance. However, as far as I can tell, the answer seems to be the IP range: 167.216.*.*
    in NetSuite IP Address Comment by mkns Jun 20, 2012 2:51PM
  • ultravividnerd: Did you ever get the IP address(es) or range(s) that nlapiRequestURL() can be sent from? This seems like it would indeed be very useful for whitelisting on external webservices. Thanks!
    in NetSuite IP Address Comment by mkns Jun 14, 2012 8:40AM
  • Hi BrettKnights, Your posts are virtually always amazingly helpful and expertly written. However, here I don't quite understand your last post. I may be missing something though, so please correct me if so. "Without scripting you can already create a saved search and save the results as a .csv or run that saved search…
    in Script to generate and display a CSV file Comment by mkns Jun 28, 2012 8:26AM
  • I am currently using this (nlapiSearchGlobal()) as a workaround to make a psuedo-interest list feature. Is there a way to get the internal ID of the Saved Searches which show up in the Global Search results? Or do I have to resort to forcing the Saved Search names to somehow map to the Saved Search ID?
    in Change owner of searches through suitescript? Comment by mkns May 10, 2012 7:47PM
  • Just a quick update here, in case anybody does approach this from the looping/manual CSV writing direction, there are in fact several substantial limitations/complications here. 1. NetSuite conditionally adds HTML boilerplate comments (with zero documentation) if you are using response.write() to output Rich Text fields.…
    in Script to generate and display a CSV file Comment by mkns Oct 2, 2014 2:21AM
  • Perhaps a better way of stating it is: 1. Brett's example code is GREAT. However, it's crazy that something so unintuitive/complex is needed to recreate functionality that ALREADY exists in NetSuite (any other CMS or programming environment etc. would ALWAYS expose functions like that so you don't have to reinvent a…
    in Script to generate and display a CSV file Comment by mkns Jun 28, 2012 9:01AM
  • Hi vVinceth, I'm sorry to hear that, but thank you for clarifying the situation. In any event, while we are waiting for this functionality to be added, please DO NOT break the hack/workaround I am using (although I don't see why it would get in anyone's way): //Use a hack to call the built-in NetSuite code to attach a…
    in Attach Case and Solution using nlapi? Comment by mkns May 3, 2012 11:53AM
  • Hi battousaix, I am really not sure why you posted on this thread (it does not appear to me that your issue/question is at all related to my original post). Furthermore, I think we are not clearly communicating. The function "nlapiSendEmail()" is a javascript API function used in javascript code files hosted on NetSuite.…
    in Author/Sender Nickname in nlapiSendEmail "from" line. Comment by mkns Jul 23, 2012 3:28PM
  • Hi Brett, Sorry, I think you misunderstood my position (and I think I've caused you to be overly defensive). I wasn't criticizing your experience or knowledge, but I think in this case your substantial experience/knowledge have caused you to look at this from a very different perspective than me. I am simply saying "your…
    in Script to generate and display a CSV file Comment by mkns Jun 30, 2012 9:45PM
  • Hi battousaix, I do not believe NetSuite has in any way expanded the functionality of nlapiSendEmail() to include nicknames/non-Employee Authors. However, I am not sure if you are asking whether the above has changed or simply what has caused the error you received. Are you 100% certain that '534' is the internalid of an…
    in Author/Sender Nickname in nlapiSendEmail "from" line. Comment by mkns Jul 23, 2012 2:56PM
  • I did try to do that using some code I found on a web site, however it doesn't appear to do anything. I'm not sure if this means it can't be done (I have a suspicion the code was designed for manipulating Netsuite-driven web pages) or I just didn't implement it correctly. The search continues. I'm also not aware of how one…
    in Dynamically show/hide subtabs Comment by mkns Jun 7, 2012 8:41AM
  • Hi vVinceth, I am grateful for your response, but I have to admit that I find your post/quote from the Help somewhat confusing. Are you saying that it is not possible to associate a Support Case with a Solution using nlapiAttachRecord, or that it is but it I have to use an entitygroup? Either way, all I really care about…
    in Attach Case and Solution using nlapi? Comment by mkns May 2, 2012 12:03PM
  • I agree, it also seems like you should be able to freely Add/Modify your own Custom System Notes (in addition to, not in place of, the built in System Notes) on both Custom and built-in Records.
    in System notes on scheduled script Comment by mkns Apr 27, 2012 9:19AM
  • Hi it seems like this is very easy to do with Client Script. I am very glad NetSuite has (perhaps not intentionally) exposed this functionality. I run the following Client script code on my Custom Case Form for onFieldChanged() (if field==company or field==contact) and also once in pageinit(). Thank you NetSuite! Please…
    in Add Quick View Pop-up to any text? Comment by mkns Apr 13, 2012 8:29PM
  • Yes, the one that includes various details about the record which is being hovered over. In NetSuite's scripting they call it a "dottedlink".
    in Add Quick View Pop-up to any text? Comment by mkns Apr 10, 2012 1:36PM