RE: contains vs. has keywords string = "The quick brown fox" search text = "th" will be matched by starts with, has keywords, and contains search text = "qu" will be matched by has keywords and contains only search text = "ow" will be matched by contains only Good example, but maybe it stopped working this way since you…

I can see potential value to such a thing, but there already is auto-numbering for transactions available, as well as the internal ID (database ID). Not sure I understand what you need further than that. Are YOU generating these numbers? Or are they supplied to you from outside the system? NetSuite does offer a similar…

Here's a stab at the pseudocode: function SaveRecord() { if PO# is not empty then run a transaction search with three filters: Type is Sales Order; Customer is same as on current sales order; PO# is same as on current sales order. if results > 0, reject. } Since you're doing it client side, consider a popup that tells the…

The saved search just needs to track create or edit of a record meeting the criteria. Basically, specify one of the Updated Fields in the Email tab of the saved search as the assignee field and then specify "recipients from results" as that same field.

Consider using a saved search for that alert.

after messing with Evan's suggestion, I'm not so sure this does what I'm guessing most people want. At the very least, it doesn't work for us. We want to choose a Class/Line of Business on the main line (order level) and have only items sharing that Line of Business to be available. Am I missing something? I sure don't…

Oh, my. Can't believe you didn't know that, Wiz! And here I was embarrassed yesterday that I wasn't entirely sure how custom parent-child record relationships work. :)

Is this still an open issue? Working with multi-select used to be nothing short of awful, but there was significant improvement in the past year (I think). I don't think it addressed this issue as I still can't source multi-select values from a customer into a custom record with a similar multi-select field using the…

Thanks. We did that but now have a bunch of duplicate customer ID's (ie different customers, same ID). We caught it before it got completely out of hand, but have still spent several hours correcting this: updating linked data from our databases and SalesForce, contacting customers with their new IDs, etc. I ran tests in…

Interesting. I'm sure we asked NS Support about this... or maybe not. I had wondered if we could restart the numbering down low and when, if ever, the numbers catch up to the new set, they just skip over to the end. EDIT: apparently we asked about this when it happened and we were specifically told it could not be done.…

.02 - using the auto-gen numbering, if someone accidentally adds a digit or two to the length of an existing numbered record, every record created after that will be that much larger. We went from 6-digit customer ID's to 8 because of this, essentially missing out on several million numbers and now having numbers way too…

I believe if you un-check "Records are Ordered" it will sort alphabetically by the Name field in the drop-down... It almost seems that way, but the help for that says the following... If this record type is a child record type, check this box to indicated that the child record entries are in a particular order. When you…

Hi Guys, I want to make a custom field on Item Fulfilments, which prepopulates an "estimated delivery date" of tomorrow-next day 1./So if the fulfilment was created on 26th October 2010, the "estimated delivery" field would say 27th-28th October 2010. That would be my ideal, if that is not possible, then just the "2 days…

Free-form still shows in system notes, but I seem to recall Long Text has always shown only the number of characters since I started using it in 2007. Maybe I'm not remembering correctly.

Which field? Is it going to be the same, static value for every customer? Do you want it to be set on entity creation? Should it override any pre-existing value?

I don't think that will set the form. Only if you can map it. There's always scripting or a scripted Mass Update...maybe workflow.

Confused by end of your first post. You said you untick "store value" and it works fine, but then you said it doesn't appear on the form. Do you mean it doesn't appear when in Edit mode but does in View? Formula fields cannot be stored, as I recall. Not sure why you would need it to appear in Edit mode. If your problem is…

I take back one of my ideas. According to Help, the Restrict Viewing and Editing (based on ownership) control does not affect search. For the permission settings in the Permissions subtab to take affect, the Use Permissions option must be selected for Access Type. Be aware that these permission settings are not used to…

I realize I didn't exactly ask a question, but does no one have ideas or thoughts? If you use custom records and need security around them, you probably don't have it. Somehow our contractor/partner that set us up missed the security issue and couldn't figure out how to solve it. I did, but I want something better.

Tricky concept. I'm not a big fan of the circular parent relationship. Can get very sticky for administrative tasks, among other things. Multi-select fields continue to be a headache for me and still seems glitchy; haven't tried Evan's suggestion about "show as list." I've seen a different approach that has its downsides,…

I appreciate the advice. However, I've had several theories suggested from NS Support, my manager, and some I've conjured, but none of them seem to work out. There are conflicts among field types, inability to source from somehwere, or potentially too great a difficulty to manage the lists (by my company's tech support…

After working with our NS consulting company, they ran into the same problems (but it only took them a couple hours to realize it couldn't be done versus my days!). What seems to be the primary roadblock is the inability to filter on Multi-Select fields, so using the filter sublist at the bottom is not possible.…

Does it reference the relative URL? That's the short one without the domain. Or maybe you're using nlapiResolveURL, which should manage it fine except the Id could just be wrong.

dansteg, there are several methods. One is to begin making a transaction search in the UI, choosing a Formula field option (text, number, whatever) and finding the field you want. It will autopopulate the name you need, and you can copy everything it puts out except the curly braces. It will even include the join if you…

Interesting error. Your SS deployment is Not Scheduled, right? I'm not sure what attempting to schedule an already scheduled deployment would do, but it's worth checking. Of course, be sure you spelled it right. Not sure if you're directly copy-pasting your code and the error here.

Your understanding of oldRec vs newRec seems fine. You didn't respond to my suggestion that your error is because of enough closing braces }. Keep in mind the possibility of someone inserting lines or deleting and adding another. Now you can't count on the logic that line 1 will be the same in old vs new for the users…

It would help to see it formatted, but my quick run-thru of your code brought up a couple questions. I don't think they are making your script fail. I recommend a try-catch with execution logging. 1. You're loading objects into your newRecord and oldRecord variables then putting that in nlapiLogExecution. That won't break…

I just realized something. You said the script is intended to execute from the button, which, though it was added via user event, the actions that button executes are actually client side. You can't use that function from client, so I suspect that's your problem. May need to change up your idea by maybe using a checkbox…

Kinda wonder if it doesn't like being executed from a client script. Try it on AfterSubmit. Disregard link below. Added it but can't figure out how to remove.

Thanks, rnedelkow. I've done that now. Shortly after I submitted the case, I saw some of the emails come thru. HOWEVER, it appears that none of the emails being sent to my test account (gmail) using a 2nd nlapiSendEmail are being delivered. The test account is a gmail address, which also serves as the Bcc address for all…