mshuman, Thanks for confirming my suspicions. Would you mind sharing your scripts?

Eric, Thanks for sharing this technique in such a well thought out manner. I'm sure many will find it useful.

Generally many to many is handled by creating a multi-select field on the child, checking record is parent, and also setting display type to "show as list". Thanks, -e Evan, can you give a more detailed example of this? I think it would be helpful to many.

Hi I was wondering if there was a way to have a custom record flow the workflow / approve process of a standard record like Purchase Orders. So when a new custom record is created it follows the same approval process as purchase orders. NetSuite does NOT have any general-purpose work-flow system at this time. AFAIK, there…

Steve, if you open up the child record does a "Delete" button appear on the child form?

Steve, have you looked at the "Other Names" record?

I agree -- we need to set permissions for EDIT separate from CREATE. Best Regards, JMU

I would like to be able to take fields from a Custom Record and merge them with other fields on an Entity to put into an email template. Brian, I think you can achieve this by using the nlapiMergeTemplate function which allows you to add custom merge fields. You would need to fetch the data from the custom record, and then…

I have this bundle installed on my account. Where did you get it from?

Another option is to create a custom formula field that does the math, and then display that field. For more info, see the Online Help for "Custom Fields".

"Customer Center" is the ONLY built-in role which can NOT be set inactive. After creating a custom role based on "Customer Center" we should be able to set it inactive lke all the rest.

You're right, in 2008.2 you can apply an item search to a (custom) customer online sales order form to limit the products available. Thanks, -e Will this work with an internal Sales Order form?

Hi, I have a Suitelet that I would like to insert text into the Rich Text Editor at the cursor position. I was planning on simply having a text field and a button, when the button is clicked, the content of the text field to the Rich Text Editor. Does anyone have any ideas how I could possibly achieve this? Any help would…

I've tried the script in Before Load, Before Submit and After Submit all with no joy. An After Submit should work regardless of the method the order was transmitted to NetSuite. Make sure there are no IF tests in your script limiting it to just the User Interface. Have you reviewed the Script Execution Log after one of…

NaturalBaby, Sorry, if there is a question in there somewhere I missed it. What exactly are you asking for?

I too would like to know what the order is by design, but I would not rely upon it. ;) Since a WF can call a script using a Custom Action, I would use the WF as my master control and call the script when you need it. Whatever the design is today, it could break after an upgrade, or even just change on purpose.

Increasing the scope somewhat, we use the following function to cover all cases where the variable does not contain data. (Note: I am not the author. Someone else wrote this long ago. Don't know who.) function isempty(variable) { if (typeof variable == 'undefined' || variable == null || (typeof variable == 'string' &&…

Wouldn't it be simpler to just set a global var for gsExecType in the pageInit() function?

I have just finished a rather complex project that involves several workflows, scripts and groups. This would have been much cleaner if I could have found a way to 'inject' information into email templates. . . . . . . I am now wondering if I merge in script does that process have access to any of the information in the…

console.log(f.values[0].toString()); Thanks Brett. I think this is piece I was missing. Couldn't find anything in the docs about how to get the VALUES out. I'll give it a try tomorrow and let you know. Thanks again.

Thanks Olivier for your reply, which is very helpful as always. One followup: [LIST=1] [*]Can I search on multiple Transaction Types, like "Invoice" and "Credit Memo"? [LIST] [*]It looks like the Script Search syntax allows only one transaction type. [*]If my Saved Search includes more than one will the Script execution of…

Thanks Olivier. I thought I had checked for "transaction" as an option for the type parameter but didn't find it. A second check does indeed show it as an option for SuiteScript Supported Records than can be used on the nlapiSearchRecord(type, id, filters, columns) method. Dumb mistake on my part. :(

I'm not sure if you can set a Workflow field via Script, but it is easy enough to do in a Workflow. You use the same Set Field action that is use to set a form field. Hope this helps.

Have you considered using the Department field (or a custom field) on your invoices to identify which department should handle the invoice? I agree with NetSuite -- it is probably best not to modify any transaction number after it has been created. Use the Invoice number to uniquely identify each invoice, and use other…

- the sample you are referencing contains code excerpts only to help users understand how to work with pricing sublists via script. The vital piece of information you have mentioned is actually not that important on this example. Note, when you use nlapiCreateRecord, it is almost automatic to use nlapiSubmitRecord in…

Perhaps you could create a custom formula field that applies the suffix to the actual invoice#. Then use this custom field to show on your invoice forms (internal and PDF).

Thanks Steve. That's a great idea. I'll use it. :D

var record = nlapiLoadRecord(nlapiGetRecordType(), nlapiGetRecordId()) record.setFieldValue('fieldname',value) nlapiSubmitRecord(record) Olivier, Thanks for the sample code, but I can't get it to work properly when EDITING records, like a Sales Order. Probably something I'm doing wrong. Issues:[LIST=1] [*]Although the…

FWIW I found Steve Klett's comment on this helpful. According to the documentation you shouldn't be able to do what he suggests since the docs want any parameters to be prefixed with "custpage". However I thought I'd give it a shot since I needed the functionality and behold, a script that does a server side redirect to a…

There are technical reasons why we can't make these work. OK. So I take that to mean that you don't necessarily disagree with my logic, but that it is just too technically difficult/costly to provide these features. OK, so given that, the next best thing would be for the Help system to provide clear details on: [LIST=1]…