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

  • So is it not possible to remove the formatting when creating a dynamic/scripted Integer field? Ultra-simple straight-forward use-case: we want the user to enter a port number. Port numbers ARE integers but do NOT have formatting. Commas and periods are especially TERRIBLE to have in such a field because IP addresses use…
    in Dealing with 0 being interpreted as 0.0 for Integer fields Comment by mkns Sep 23, 2012 7:35AM
  • This is some really strange behavior, I just created my first Form Portlet and this is literally the FIRST thing I noticed. And by "noticed" I mean did a double-take and then grimaced realizing it was NetSuite and not my ordering of portlet.setSubmitButton().
    in Custom portlet submit button moved to top in 2012.1 Comment by mkns Apr 26, 2012 6:48AM
  • Hi Jason, This is basically what NetSuite already does in order to route e-mails to specific NetSuite instances/cases. I personally think parsing the subject line is easier, and I also think that relying on NetSuite to modify their coded e-mail addresses is not going to lead to a timely solution. -mkns
    in understanding recipient on Case Message Comment by mkns Dec 17, 2012 4:48PM
  • Hi Duong, If you are using e-mail Case Capture, then Before Submit User Event deployed on the Case record type is triggered when an e-mail comes in to the Case Capture address. Within that Before Submit User Event, you will have access to the "email" field via nlapiGetFieldValue('email') and that should be the e-mail of…
    in understanding recipient on Case Message Comment by mkns Apr 16, 2012 6:53AM
  • Hi sprintz, I would not presume to tell you that what you are trying to do cannot be done (or isn't the right way to do it). I wanted to say this up front because it's always a pet peeve of mine when people assume that a forum poster doesn't know exactly what he/she needs. However, since I'm not really familiar with what…
    in Suitelet List: Can I source with a filter? Comment by mkns Jun 7, 2012 8:26AM
  • Thank you from us as well! It was very easy to do a nlobjSearchFilter() and nlobjSearchRecord() then loop through the results to add them one by one with nlobjField.addSelectOption(). I am using it to get the Messages for a Case.
    in Suitelet List: Can I source with a filter? Comment by mkns Apr 20, 2012 11:47AM
  • Thanks to everyone, this helped me as well. I was worried I was going to have to use some really hacky Client script to remove items (which I was already gracefully creating in server-side using addSelectOption) until I found this thread! Edit: Maybe I spoke too soon, I seem to be getting "SSS_INVALID_OPERATION" no matter…
    in nlapiInsertSelectOption and nlapiRemoveSelectOption Comment by mkns Apr 25, 2012 8:38AM
  • If I am not mistaken, the Support Case After Submit even ONLY triggers on Case Capture e-mails which generate a NEW case and NOT e-mails sent to existing Cases. I have tried to explain my observations in another thread. https://usergroup.netsuite.com/users/showthread.php?t=19144
    in User Event on Email Case Capture Comment by mkns Apr 15, 2012 8:44AM
  • Agreed. However, I believe nlapiSendEmail does send the email, but a response to such an email does not get logged in the system. I think NS' mail server sends a bounceback on the message's way in when the server sees '-1' in there. Hi, As murco has already stated, this is a much greater disaster than is implied by…
    in nlapiSendEmail - how to have the reply back into NetSuite? Comment by mkns Dec 1, 2011 1:13PM
  • Thanks Cherryl. NetSuite seems to have just fixed the issue (Case 1405076). Although it is still eyebrow-raising that this issue ever existed in the first place, I am glad that NetSuite adopted the proper urgency in addressing and correcting the bug.
    in nlapiSendEmail - how to have the reply back into NetSuite? Comment by mkns Dec 1, 2011 9:54PM
  • To save anyone time on this, based on Yang's post in the other thread, just use a function to access Formula Fields by their custom label like: function getSavedSearchRowFieldValueByColumnLabel(result, columnLabel) { var columns = result.getAllColumns(); for (var j = 0; j < columns.length; j++) { if…
    in script help for 'sum' of formula search column Comment by mkns Jun 29, 2012 5:44PM
  • Thanks, this was really handy. I just decided to include the same sort of code in my pageInit() since I am including jQuery as a library anyway. I am using this to set the default "Subject" of the E-mail button on a Support Case to a specific Inline Text field which I have set to always show the "Subject" that a Message to…
    in accessing "new email" pop up Comment by mkns Apr 19, 2012 11:28AM
  • In case anyone comes across this searching, it would appear that this has been fixed. I needed to add a dynamic field, and using: var placeholderLicensingContactField = form.addField('custpage_contact_licensing_placeholder', 'select', 'Contact (Licensing)', null, null); form.insertField(placeholderLicensingContactField,…
    in Adding a field to an existing field group via nlobjForm Comment by mkns Sep 18, 2012 9:13PM
  • I ended up just using cURL (i.e. I use nlapiRequestURL() inside NetSuite to make a call to my own PHP code on another webserver) and constructing the raw request based on the communication I saw using Fiddler2...for example: [PHP] $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $websiteFormURL); curl_setopt($ch,…
    in nlapiRequestURL, POST form parameters AND a body Comment by mkns Dec 5, 2012 11:59AM
  • I believe that I too am going to be forced to use external code (PHP/cURL extension) to achieve this. It seems quite ridiculous to me that this should be necessary though. Edit: Requested Enhancement # 223973 to fix this issue.
    in nlapiRequestURL, POST form parameters AND a body Comment by mkns Jun 14, 2012 12:26AM
  • So does this thread mean that POSTing files/field data together is still completely impossible in NetSuite or can this still be done using pure Javascript (XMLHttpRequest)?
    in nlapiRequestURL, POST form parameters AND a body Comment by mkns Jun 10, 2012 10:09AM
  • Yes, these forums taught me how (frederic.jannelle et al have great posts about this). Here is the (not cleaned up yet) code I am using to attach Files to Cases based on the Messages on that Case. function attachMessageAttachmentToCase(caseid, messageid) { var filters = new Array(); var columns = new Array(); filters[0] =…
    in Access message attachments Comment by mkns Apr 15, 2012 7:31AM
  • Hi sklett, Did you ever figure out a superior alternative/"encapsulate this functionality into a nice little object that I can easily use in my assistants" as in your post? I think I will have to do this very same thing (persisting data across all steps in an assistant to allow for back/next functionality without losing…
    in Using Session to persist data in assistants Comment by mkns Sep 12, 2012 11:53PM
  • Hi Neil, I am not sure if I understood your original post, but you said: "I have written a script which takes an inbound email, extracts text from it, searches for an existing case for the customer and adds a new outbound message to the call. This is all working." Assuming you mean "adds a new outbound message to the…
    in How to force an update email Comment by mkns Apr 12, 2012 7:03PM
  • This behavior (attaching nlapiSendEmail() messages to records) is actually something I believe is common/highly desirable when automatically processing Support Case communication on Case records. There is some confusion about this though, because although it IS possible to generate e-mails with @(something).netsuite.com…
    in Reply address on email from SuiteScript Comment by mkns Apr 12, 2012 6:06PM
  • Hi, I am not sure if I do exactly what you want, but right now I am using a Custom CRM Inline HTML field (with a default value below) to add a "Custom Submit" button to my Custom Case Form: <table cellspacing="0" cellpadding="0" border="0" style="margin-right:6px;cursor:hand;" id="tbl_custom_submit"> <tbody>…
    in Adding Button that Saves and returns record to Edit. Comment by mkns Apr 13, 2012 9:31PM
  • I also need to do virtually the same thing. Is the only possibility here to intercept the actual raw POST data for the form and use that string as the input to this function (as opposed to constructing the POST data from arrays/cURL)? The raw POST data being something like: ------WebKitFormBoundaryFBbR253bb332242ZgI…
    in nlapiRequestURL to upload a file Comment by mkns Jun 10, 2012 9:00AM
  • For reference, it seems that now (2012.1) that if you do use "records" parameter of the nlapiSendEmail() function to attach the Message to the Case then replies to that e-mail WILL appear on the Case...although it seems that the e-mail domain will be messages.netsuite.com and not cases.netsuite.com in the "reply-to" field.…
    in Sending emails from a case using a scheduled script Comment by mkns Apr 12, 2012 4:58PM
  • Calling one suitelet from within another seems to be the only reasonable workaround to obtain synchronous results while circumventing the script usage/governance limit (offload one suitelet's functions into another suitelet instance), so thank you for this clarification.
    in nlapiRequestURL not working in a suitelet Comment by mkns Jun 28, 2012 7:56AM
  • The After Submit User Events seem to work as far as I can tell. It also seems that because re-adding Message Attachments as Files a second time does not cause duplicates, I am able to get away with just having a function called "attachAllMessageAttachmentToCase();" in the Before Load event for my Case form and I can open…
    in How to get attachment details in a email message Comment by mkns Apr 5, 2012 6:21AM
  • tng: This is fantastic code. Thank you. I am also going to try to expand this to run EVERY time a message is added so that the Files tab ALWAYS lists ALL files, I think. EDIT: I think I am beginning to understand the solution. In order to process ALL e-mails received by NetSuite to the Support system (cases.netsuite.com)…
    in How to get attachment details in a email message Comment by mkns Apr 5, 2012 1:54AM
  • Hi Yang, Is it still currently true that you cannot access the "Message" for a Case Capture e-mail which initiates a "Before Submit" on a new Case record DURING the "Before Submit" event? I have just tested it and it seems like I can only access the "Message" which was responsible for creating the new Case in the "After…
    in Email Case Capture and beforeSubmit Comment by mkns Apr 15, 2012 9:53AM
  • I received an answer from NetSuite which I posted in the other related thread (https://usergroup.netsuite.com/users/showthread.php?t=29274). Basically, right now, it seems I will still have to experiment with deleting the Case which was just created in its own After Submit event. Not sure if this will work though if…
    in Email Case Capture and beforeSubmit Comment by mkns Apr 15, 2012 6:37PM
  • If I'm not mistaken, this thread represents 1/2 of the mysterious question "how do I process all incoming e-mails through case capture". This is the half of the solution to deal with e-mails coming into EXISTING cases. The other half of the solution is how to deal with e-mails coming in as part of NEW cases. I found the…
    in Which Event Type should be used for when a case is updated by E-mail Comment by mkns Apr 5, 2012 3:50AM
  • It also seems that while this method does ATTACH the message to the Support Case, it does not necessarily give the same "reply-to" e-mail address as if the message were sent from a Case nor does it function identically when replies are received. http://usergroup.netsuite.com/users/showthread.php?t=14924
    in nlapiSendEmail() not attaching to record Comment by mkns Apr 12, 2012 5:59PM