3958329 Green Ribbon

You hit the nail on the head there JCirocco I had no idea I could create a custom field on Class. That would have saved me so much time writing these CASE WHEN statements. Thank you!

Criteria: SOW Requested (Custom Checkbox) = True Results: Opportunity Status Document Number Title Customer Sales Rep SOW Requested Date (Custom Body) SOW Request Completed (Custom Body)

This would be a huge enhancement for my company as well. Added my vote to the enhancement request.

NetSuite Support provided an answer, so if anyone else is looking for this solution here it is: - Navigate to > Customization > List, Records, & Fields > Entity Fields > New - Type = List/Record - List/Record = Transaction - Applied to tab = JOB - Sourcing and Filtering * Filter using = Customer | Compare to Field = Parent…

Store Value is not checked. I just verified that the calculation is working, but only after the record is saved. I was hoping to get the field to automatically calc the value based on the number entered in the unit cost column.

Hi jacky071087, I did save the record and no change to the field.

k_dunc Coming back around to this. The problem seems to be that script is still allowing the opportunity to be saved. Then when I go to edit the opportunity record, another script does a check for a sales rep, error's out with an "id" error and I'm stopped from setting a primary sales rep. I have to turn off the deployment…

Thank you david.smith , that was what I was missing. It uncovered a larger issue in my design in that if I deploy that script to the Opportunity Record, clientSaveRecord function, it always runs because before the save, the sales rep field will always be blank. I don't think I'll be able to accomplish what I'm trying to…

Yes I did add the quotes around sales rep. Yes I am the script owner and testing the creation of and saving of the opportunity.

k_dunc The primary sales rep is stored on the Sales Team sublist of the opportunity. Ideally, that list is pulled from the Customer record that the opportunity is tied to, which works 90% of the time. What I'm trying to script for is the other 10%. When someone forgets to mark the primary sales rep, either on the customer…

I was able to find where the problem was occurring. Surprisingly it had nothing to do with NetSuite. It was actually an issue with the way the Distribution Lists were setup in our O365 instance. There is a checkbox that says something along the lines of Only Internal or Authenticated Users can email this distribution list.…

Hey wwinters, I marked up the alert as you mentioned to alert(practices[i]); however now the Alert shows undefined instead of showing the Values that make up the array. When it was just alert(practices); the popup alert would show the values correctly. I also did the same thing in my If statements and no change.

david.smith That worked perfectly. Exactly how I envisioned it. Thank you so much!

erictgrubaugh You are quite right, each "else if" statement is the same function as the hardware (product == 8) function, just a different input on the markup. I appreciate the advice on simplifying the script. This is one of the first scripts I've ever written so it's wholly inefficient.

Hi david.smith, I've never used that script event. I guess my question is how would invoke a recalc for the whole transaction after the line items have been changed?

MikeBucklaew The nlapiSubmitRecord worked. Thank you for the advice.

errol You were right. I made that update to just True and it worked exactly as expected. egrubaugh You are also right. Once I started analyzing the amount of combinations that could exist, the script would hundreds if not thousands of lines long. There are 16 different choices that can be made and it's also a multi-select…

Hi J.J, I've had another person suggest to me using a Suitelet to accomplish what I am trying to do. Unfortunately I've never created or worked with a Suitelet up to this point so I'm flying blind on this one. I appreciate the suggestion. Hopefully I can figure out how to make this work.

The simplest answer is always the right answer. Thank you wwinters.

al3xicon The record is actually in view mode. EDIT: You inspired me to try it in edit mode. It worked exactly as I expected it to.

Thank you khultquist and al3xicon both for your help. I'll get screenshots of the deployment up shortly. As a quick test, I took the advice to log the output of nlapiGetLineItemCount("salesteam") and the console showed "-1". This has to be where the hang up is. The record I am running the test against has 4 sales team…

I must be missing something with the logging. I added the Log Execution you noted, al3xicon, re-ran everything and nothing is being appended to the log. I verified the script deployment is set to Testing and Debug log level. Both logs for the script and script deployment are empty.

It is a client script that is called by a UE script that deploys a button.

TMann, I actually ended up implementing both of your suggestions and this worked. What really worked was changing the function to BeforeRecordSubmit, but also changing the if statement to do some validation seemed like a more hardy way of doing what I wanted to do. Thank you very much!

Is there a list of NetSuite SMTP servers that I could provide to my IT department to make sure our O365 instance isn't blocking them?

What's most frustrating about status.netsuite.com is the fact that all functions are showing a green check right now and yet no one can login in my organization. If they can login, they'll time out eventually or while loading a record and be kicked back out. What's the point of a status page if you know it's objectively…

Myself as well as a few other uses in my organization cannot load transaction records as well. The issues are random as there are other users experiencing no issues at all.

This was fixed. I found that I forgot to add the "form.setscript" code to the User Event script. It had been working for so long because we did not have any other client scripts deployed against the record. Once I created a new test script, the form.setscript code became mandatory.

JCirocco We don't care about the specific item the customer is trading in. In this case the Trade In Credit SKU is a basic sku provided by the vendor. We do all business as Drop Ship. I believe switching it to Non Inventory for Resale will be the right way to go. Thanks for the suggestion.

We currently use the Box Integration and it wasn't able to solve one larger issue for our business process. In our environment, we would like for the documents saved to Box on an Opportunity to flow through to the Sales Order. Unfortunately, with Box each individual record is self contained. No migration processes seem…