So did you find out exactly what condition causes the problem? I was trying to do so and had confusing results.

How will the onSave function on the client side know the id of the assembly order before it's saved?

Is there a defect filed? I would like to understand the exact circumstances that lead to this condition. I can change the trandate from a user event script, but I will also need custom buttons with scripts attached to them. Is this now impossible?

It turns out that's exactly how I did it. Good point about deleting an assembly build. It won't enforce referential integrity on the custom (child) records, but having dangling pointers would be bad because I will be searching for "any of none" values. Thanks.

Thanks much, that's the trick. I searched the help center for "@NONE@" and found the documentation I should have read more closely.

Ok, I tried that and I'm really surprised by the results. I thought I would get an error since 'isempty' is not listed as valid operator. But I didn't. Instead it ignored it completely and returned records both with and without a value for the filter field. Strange. Thanks for the lead, though!

Here's the code. The trick is that it wants the numeric id of the custom record type, not its symbolic name. I do not know why. I tested it from a RESTlet and from a client script. function createNote(recType, recId, noteText, noteTitle, noteType) { noteTitle = typeof noteTitle !== 'undefined' ? noteTitle : ''; noteType =…

So it appears that the problem is that both the name field and the created field (created by NetSuite when you create the custom record) are not marked "show in list" and so there is no way to get them from getLineItemValue. This oversight causes me to have to load a couple hundred custom records in the browser, which is…

I'm going to be doing something somewhat similar. I currently use a custom record type to keep track of rolls of paper, so unique identifiers are allocated once at a time by the auto-numbering feature. I use a custom middleware layer that caches things (work orders, items, rolls, etc.) in the filesystem. So the file called…

Thanks.. that was it. :D It took me a while to figure out that you have to compare it to 'T' instead of true. Here's the working test search: function testSearch2() { var bT = '2/5/2014 7:00 AM'; var eT = '2/5/2014 12:00 PM'; var filt = new Array(); filt.push(new nlobjSearchFilter('created', null, 'within', bT, eT)); <span…

Yea, well in this case it's not really possible. I have to set the timeout to some value. A timeout will be reported to the user, who will just have to manually retry which is ugly. And updates won't be atomic so the state after a timeout could be indeterminate.

And then it suddenly fixed itself after I had figured out that if a *custom* item field was joined on (this is a transaction search for work orders) it would run for 30 seconds every time, but if a standard item field was joined on it would run in 3 seconds. I asked support the simple question: "do you yourself know why…

It got slower and stayed slower. I ended up drastically rewriting parts of my system. The same search using a retrieved search runs twice as slow as when you use the search API directly. And a search of a custom record with a join to a transaction runs many times slower than doing the two searches separately and joining…

I have redesigned it substantially to paper over their unpredictable performance. I now have no joins in any of the restlets, and I do, as you suggest, manipulate the user interface to make it appear that the change has been made, and the make the change in NetSuite in the background. Where the real rub is that I have to…

And then BANG yesterday at noon the re-written script suddenly got six times slower, and has stayed there. It's now faster to call the saved search than it is to use the API directly. This is of course all extensively documented and verified. Now I have to call them on the phone, wait until my ulnar nerve compression makes…

On a related note, here's how to test a PUT method (requires a Linux system). This took a bit of figuring. # curl -X PUT -H 'Authorization: NLAuth nlauth_account=<ACCT#>, nlauth_email=jeff@seamanpaper.com, nlauth_signature=<PASSWORD>, nlauth_role=3' -H 'Content-type: application/json'…

answering my own question.. apparently https://system.netsuite.com/app/help/helpcenter.nl?topic=EDIT_TRAN_TRNFRORD

So where is this "PurchOrd" et al documented ?

Or you could use the new paginated search API and keep calling it until it runs out of results, always appending the current iteration's results to a sort of master results array. Which paginated search API is that? I don't find any reference to it in the help.

for what it's worth checking for the transaction's customer == null seems to be a good way to differentiate an item fulfillment created from a transfer order from one created from a sales order

Thanks, that did the trick.

Ok, that's pretty weird. Adding a non-saved transaction body field sourced from created from /type works great, but only if it's not hidden. If I set it to hidden the getFieldValue call returns null.

right said Fred! Thanks.

many thanks to mhill from here too...

Does anyone have an example of creating a note attached to an existing transaction ? There's a transaction field, but the help says something about using getSelectValue which makes no sense at all. I have a transaction and I know the type and the internal id. How do I create a note on it? Thanks in advance.

Isn't the javascript boolean literal just true as opposed to 'true' ? In any case neither work. The line item fields are not disabled. Any other ideas?

It's an item fulfillment. Just for giggles, here's whole script. The rest of it works fine. A previous version is in production. function sp_casefull_pageInit(type) { //alert ('casefull init - ' + sp_getItemCount()); nlapiDisableLineItemField('item','quantity',true);…

Thanks, Steve.. I'm thinking along the same lines. The next thing I need to figure out is how to make a field appear and disappear on the PDF layout...

I ended up adding a second, plain-text field with a message to print on the PDF layout. It boggles that one can only specify a color for all fields in the PDF layout editor, but not for an individual field. What the heck use is that? The last piece was to write a user event script to run on sales order approvals that…

I may have hit on something. I changed the field type to "Rich Text" and it let me write styled HTML into it and saved it. Now I've got a big red ON HOLD at the top of the sales order in view mode.. this is 2/3rds of my solution.