I don't think you can set a form in a before load script, because the form has already been chosen by the system. You can use it in go to record actions. Evan, thanks for clarifying this in a very direct manner. I'm probably missing something, but this does not make logical sense to me. ;) You can change the form in…

2) This is indeed invoked as a before load user event.. Thanks for your reply. So what do I enter in the "Before Load Function" block on the User Event Script record? How does this interact with a pageInit function that I have on a Client Script?

Hi Jim, were you not successful in getting the script I provided to work? No, I was not successful with your script -- probably my fault, not yours. We can discuss details in the other thread. Thanks for your help. My main point here is that we all need to have a clear understand of the scope of beforeLoad, what it can do,…

Any chance of getting a "user documentation" subforum or something set up for this kind of thing? Specifically, case studies and how-tos? I could see huge potential for a NetSuite wiki or similar. dfcowell, That's a great idea. It was widely discussed with large support about a year or so ago. Unfortunately it was never…

Here is the suitelet. If you are outside Australia and want to try it, try the postcode 4213 and distance 30. Wow! That is very cool! :cool:

Please log a case for this and post the case # here - we will take a look, there should be no system notes logged unless the value changes. I think there may be a generic problem here. I have observed system notes being logged for fields that did NOT change across many record types, and for both built-in and custom fields.…

Steve, Can you use SQL expressions in script calls? If so, you might could use this expression or some variation: (EXTRACT(YEAR FROM {FEESCHEDLN_FLD.EFFECTIVE_DATE}) = 1998) HTH.

First, let me state my conclusions from reading this thread and other related threads as well as script testing on my end. Please advise immediately if any of this is incorrect. [INDENT] Updating Stored Field Value in the beforeLoad Method[LIST=1] [*]You cannot set the value of a field on an existing record in the…

Wally and Mathieu, Thanks for the suggestions. The Excel Web Query sounds very interesting. I would just need to determine a method to automate the Query refresh at a particular time without user intervention. I wonder if SQL Server can execute an Excel Web Query? Anyone know?

Yang, Can we create Work Orders in script now?

Have you looked at the Line Init and Validate Line functions/events? You should be able to issue a standard JS alert in response to either of these events.

The same risk exist if you use custom records. What if 2 records are created at the same time, thus running a lookup on the "next available" number at the same time and getting the same info? Exact same problem exists.. You could be right. But I'm hoping that Oracle will handle this for us and ensure a unique ID. If two…

You can rest assure that two custom records (of the same type) will never have the same internal ID since this internal ID happens to be the primary key used for storing that record. Thanks for the confirmation Yang. This is exactly what I was expecting.

Yeah, you could do it with suitescript. on beforeSubmit of create I would fire off a nlapiSearchRecord to find the item most recently created and increment the number by 1.. What happens if two or more users try to create a new Item at exactly the same moment? In classical DB design, one would use a separate table to track…

Having said that, the real problem is that the component sublist on the assembly build record is initially empty. Until we release support for dynamic scripting (i.e. sublist is dynamically populated when you set the assembly item on the transaction) which is on our roadmap, there is actually no way to populate this…

I think this can be done in Javascript. Is it possible to write some Javascript in an INLINE HTML field that would do this?

Paul, I'm sure it would be helpful to a lot of people if you don't mind sharing how you solved this problem.

Steve: Permissions are great unless you want agents to have the 'edit' function without allowing them to delete the case. Once that is the instance, you MUST use scripting to control permissions with suite side scripting. Rmarek, I'm not sure I understand your statement. When you assign an "EDIT" permission for a specific…

I don't know how I manage to find so many bugs. NetSuite should hire me. Steve, Keep up the good work! You're the best QA tester that NetSuite has. :D

The customer record does not have direct access to transactions. A beforeload suitescript that does the search would be required. Note that will cause the customer record to load somewhat more slowly. To get this information I generally go to the transaction tab and filter to sales orders, ordered by date descending. Or…

You might check out "Publishing Dashboards" in the Help file. I'm not sure about User preferences, but for everything else you can create, save, and then publish a dashboard to every user of a specified role. From the online Help: Administrators can share, or publish, their customized dashboards to users logging in to the…

Create a script for Sales Orders that has an afterSubmit function. David, Thanks for sharing. One question: Should "Last Sale Date" be based on Sales Order or Invoice? I believe that the built-in field "First Sale Date" is based on an Invoice. A SO might never be billed, so then it wouldn't be a "sale", right?

Unfortunately the Publish Dashboard option does not carry the Set Preferences settings over to other users. It would be great if it did! That's too bad. If you would like to submit an ER to add this capability to the Publish Dashboard option, I would be glad to vote for it.

... Finally, we are working on a major initiative for 2009.1 to improve the stability of the platform in preparation for increased adoption and more powerful capabilities. You should hear more about this initiative in the coming months. Yang, This is very good news. I look forward to seeing the details. In the meantime,…

The recommended JavaScript editor for Eclipse is going to be Aptana (rather than JSEclipse). Aptana provides better support for SuiteScript API auto-suggestion/code completion and jsdoc (javadoc-like) reference information. Thanks, Kate Kate et al, It appears that Aptana can be used stand-alone, or as a plug-in to Eclipse.…

Thanks Kate. This is very helpful.

One thought would be to use a before load user event script, evaluate the record, and redirect the user to view mode conditionally. Tim, Thanks for sharing your idea and script! This is very helpful. This would be a great example to include in the Online Help and PDF docs.

What? I don't understand your use case, please elaborate. Oliver, I'm guessing that he would like to have conditional editing, based on the record's fields. So the editing would only appear if certain criteria were met. This could be very useful behavior.

What were the NetSuite designers thinking when they created the "Role" field?? :confused: It just doesn't work for most customers. :( <rant> OK, I can see just ONE "Primary" role. But what about the other choices? Most of these roles need to be assigned to more than one Customer contact: [LIST] [*]Alternate Contact…

Thanks Kate!