3948344 Green Ribbon

I'm setting access via script and the only way I know of to do this in script is to find that contact in the "contactroles" sublist. The code below is s snippet that shows what is currently happening where newlyCreatedCompany is a record ID and subnewContact is the id of a just created contact. If I were able to do a…

Actually it is the reverse. Since the Contact ID is stored as part of the sublist record I was wondering if there was a way to do a look up of the sublist index using the contact ID as a filter. That would save having to iterate through every sublist item looking for the one that has the matching contact ID. As mentioned…

I am also receiving an error in mass update. When seeing the results of the update I am seeing the following. "Your mass update is complete, and has been successfully performed on 0 records. Your mass update failed to complete for 59 records: id " This occurs on ALL mass updates now. Anyone else?

Thanks, I would have driven myself crazy. I have two further questions. 1. What is the difference between "Use Permissions List" and "Require Custom Record Entries Permission" 2. I would like to set ALL users to view except administrator. Is there any quicker way than adding every role to the permissions list? Thanks, AGMNS

I have done what you've mentioned, however when I switch roles to Relationship Manager I still have the ability to created a new record or if a record is selected edit the record. Attached is a screen shot of the setup in the custom record. Where am I going wrong? [ATTACH]temp_638_1437759809572_654[/ATTACH]…

I do have that as well Evan, however it lists only the standard forms. The custom forms for a custom record are not displayed there. i.e. Custom External Case, Standard External Case are on the CRM sub tab and the Standard and Custom forms for transactions are on the Transactions sub tab. See screenshots below.

Thanks Evan. There is no allowance to set a preferred form on the Custom Forms tab in Setup, Users/Roles, Manage Roles then edit the role and go to the the custom forms tab. That tab only allows for setting permissions for the role.

To this point we have only been using the functionality that is in the Lists-->Website Content Manager in the NS Dashboard. Other than a custom Welcome page we've done nothing else.

They will already have log in access set up. We can manage a customer role for them, that's not a problem. There will be custom pricing levels for ALL of the customers which we already manage in NS. .... so far as the experience. ..... I've managed to do 99% of the scripting etc via suitescript for the rest of NS but have…

Initially this will be for a single customer, however I expect that once we are able to implement it our sales team will jump on it and offer the same to other customers (sigh)

Thanks David, I'll definitely be using the plug in in the future. Interesting when I create the saved search I choose 'is" withing the SS Criteria for the "custentity_cust_corp_ dash_account'" and when I export it using the plug in the filter changes to "anyof" GOTTA love NS. Thanks for the assistance AGMNS

Here's the final expression. BTW, ignore what I said about "anyof" I realized it was correct if you7 look past the "is" in the SS Criteria. IT's unfortunate that you can't search for the text value of custentity_cust_corp_ dash_account'. It must be the numeric value of record ID. var customrecord_cr_aedinfoSearch =…

As it turned out ironside the failure was because I was using nlapiCreateTemplateRenderer() ... this resulted in a rendered object within the yield which is not supported. This wasn't a problem previously because of the way I was handling the e-mail template's, however with 2015.1 that changed. I'm now nulling out the…

I've done this with a saved search many times. What I need is the functionality to call an existing "Saved Report" and attach it (Excel file) to an e-mail via suite script. The recipients will vary depending on criteria that I use in the script.

In this particular case the "recipients" are based on a series of criteria so I can't define the audience in the report.

I would not be able to use Dynamic Groups for this as there are too many variables.

FYI, I used a work around that gave me as much flexibility as I had before. Much of it using the code that you supplied Robbie and adding a twist of my own. I've created series of my own "merge" locations in a saved e-mail template. After loading the email template I run a series of replace statements and it works…

Thanks, sometimes another set of eyes is all it needs. That was exactly the problem. What I don't understand was why this working for all roles without a problem then stopped working a month ago. The audit trail shows no changes since it was created except for just now.

If I change 'EXCEL' to 'CSV' and change the file extension to .csv I end up with the base64 encoded data in excel when it is opened. It's annoying that this behavior also happens when attached from a saved search or Export from Save Search Results.

Let's start from the beginning. The code on the Suite Answers page https://netsuite.custhelp.com/app/answers/detail/a_id/25750/kw/create%20spreadsheet%20in%20script%5C contains the escape character set for all < signs and the > appear as normal characters. If the code is run as it exists a spreadsheet is created and the A1…

Interesting. I was playing with the upper section of code xmlString += '&lt;Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" '; xmlString += 'xmlns:o="urn:schemas-microsoft-com:office:office" '; xmlString += 'xmlns:x="urn:schemas-microsoft-com:office:excel" '; xmlString +=…

Nope the following (in part) returns in A1 using PLAINTEXT…

Here's the code. This checks each task for a contact and if one exists checks the contact record for one of 3 phone numbers and then populates one of the phone numbers to the task and saves the task. function updatePhone() { var contextGTRU = nlapiGetContext(); var usageRemaining = contextGTRU.getRemainingUsage(); var cust…

I did manage to do this with a change. Instead of creating a LoginAuditTrail search I created a customer search with a join of LoginAuditTrail. Now I can't seem to asssign the results to variables. Below are the results of the search in script debugger. I am trying to assign the date and everything I try resluts in null.…

I did manage to do this with a change. Instead of creating a LoginAuditTrail search I created a customer search with a join of LoginAuditTrail. Now I can't seem to asssign the results to variables. Below are the results of the search in script debugger. I am trying to assign the date and everything I try resluts in null.…

OK so if I understand correctly your textual values will never contain time in the original field. Ex: 12/14/2012 With that in my mind you could do the following : var date = nlapiStringToDate(mcdate); var dateTime = nlapiDateToString(date, 'datetimetz'); currcust.setFieldValue('custentity_cr_maintremcompleteddate',…

It seems the Role ID for the Role Field on the customer record is not exposed. Only the text. Solution was exporting all roles from NS, create a custom record with the Role (Text) as the name on each record and populate the Role ID in a 2nd field on the custom record. Then when the results are returned from the saved…

Yes on both

Ok, so the scheduled script runs "sometimes". However the script runs until it runs out of governance. The following code represents the customer loop. Is this the right format to force the nlapiYieldScript() to execute. Am I doing something wrong since it continues to run. for (var i = 0; custarray != null && i <…

Brett, thanks for the insight. Based on what I am seeing I think I will try to implement the use of tags for the inbound information in the case e-mail. You wouldn't have a short snippet of code that gives an example of retrieving the contents of a tag in an inbound e-mail or point me to the right documentation. Best…