Olivier Gagnon NC Red Ribbon

Amit, Thanks for the attention. I cannot create cases as I'm getting unexpected errors (tried from my account as well as directly from customer center). I just sent in an email at support@netsuite.com with my case description and the information you asked for. I got a case number returned to me - 646005. Let me know if you…

Yang, My script is not firing on Print of Item Fulfillment - I just submitted case 645470.

Packing Slip, which comes from Item fulfilment.

Adding line items via the nlobjRecord object is always a pain (you can run search here and find a few threads about it). Usually, you need to manually set everything mandatory on the line, there is no sourcing. You also need to set the transaction total and the taxes. However, that usually throws an Unexpected error, not…

You are right, it actually says that in the doc, bad reading on my part :o New question: why are checkboxes returning null when I read their value via server-side script? I've tried beforeSubmit and afterSubmit, nlapiGetFieldValue() as well as newRecord.getFieldValue()... I keep getting null. What am I doing wrong there?…

I'm working with Mathieu on this script, and here's where we're at now: function addInsuranceLine() { var record = nlapiGetNewRecord(); nlapiLogExecution('debug','Open Line Count',nlapiGetLineItemCount('item')); nlapiLogExecution('debug','Open Item Name',nlapiGetLineItemValue('item','item',1)); var linenum =…

You can create your search via the UI, complete with summary criteria, and then simply call the whole thing from your nlapiSearchRecord. Of course, if you need to add criteria at run time, this may not work.

Isn't there a function for inserting values into custom multi-selects? I only ever did it once, a while ago, but I don't remember having any trouble with inserting values.

Is there any way you could send me a sample of the code that links the Alternate items? I am new to scripting in NS and the support is not that detailed. Once I get an idea of what it looks like and what I need to to display in webstore I should have a good start but I can't get a detail description with working code to…

Olivier - I like your alternate item solution. Do you find you are limited in the UI with the item entry machine? We have a few things already going on and horizontal real-estate is at a premium! Hi Matt, Yeah, we originally made the alternates for one customer, but we found that some of our other customers liked them a…

As a Netsuite partner, we've done so many... Here's a few of the more interesting ones I can think of right now [list] [*] Rewrote Partner assignation rules based on zip codes (combination of custom record and client side script) [*] Server-Side script to properly assign Cases created via incoming email - instead of…

ablank: function calls are case sensitive. In your code I see you make two errors: // Get the Ship Date from the Sales Order deliverydate = currentRecord.GetFieldValue('shipdate'); // Set Date value on the Delivery Record recordCreated.SetFieldValue('custrecord1', deliverydate); That should be currentRecord.getFieldValue…

... if ( !record ) ... record is indeed not defined in your script.

I think your "User Error" are coming from the alert() you have in there. Putting alert() will result in script failure in Server Side scripts when the script reaches it.

You can also deploy Server Side Scripts as "testing", which means they only trigger for the script owner. Depending on your situation, that may be enough.

As far as I know, no it's not possible (I'd be delighted if someone says otherwise!). In your example, you would need to run 4 separate searches and merge your results.

You can remove rows from lists YOU create using server-side code. You cannot manipulate any lists that were created through the Netsuite GUI.

You can execute Client-Side javascript. Of course, you could call a suitelet from client side, which means in most cases you can also execute server-side code.

I just tried this out: Add an Inline HTML field to your form. Paste your code into the default value surrounded by <script> tags: &lt;script type="text/javascript"&gt; function myInlineHtmlFunc() { alert('hello'); } &lt;/script&gt; Then reference the function from your view mode button:…

Ah, nevermind, I figured it out. It's due to a Netsuite bug (oh sorry, "enhancement request") regarding Revenue Recognition and multi-currency.

If you were to call the NS Integration team, you would hear a recorded message warning that they are "fixing a bunch of broken operators". That's our warning, I guess.

A gigantic and needlessly complex work-around, yes. Here's how it goes: Journal Entry 1 - generated by Netsuite, this is a Rev Rec Journal Entry for an Invoice billed in USD. The Journal, however, is in CAD. (If you try to edit/save this record, you get an error, because it's a CAD journal for a USD customer, which is…

For the operator, try 'is' or 'equalto' Unexpected errors from nlapiSearch are usually from fussy operators.

If by "make it editable" you mean unlock it in the GUI so a user can change the value, then I do not believe this is possible. If you mean modify the value with scripting, then this is possible, but tricky. I think the only trigger that will allow yo to change the unit price is validate line. Otherwise, from a non-script…

I can confirm that - none of my scripts are triggered from add multiple. If it's critical the script be called, I suggest you remove the ability to add multiple (add multiple is an option in the form header when you are customizing it)

Hi Matthew, While such a script would be very easy to do, have you tried doing this through tax setup? I'm guessing you're using an Australian edition, so I don't know if you have this, but in my instance (v2007) I can go to Setup->Accounting->Set Up Taxes, and from there specify a tax code to always use for international…

Should be doable, yeah.

Hi, *Now* is not the best time to make Web Service calls, as Netsuite is down and all WS calls are failing... Refer to this thread

Unless your post only has that error, there is an extra space in nlapiGetCurrentLineItemValue('item','serialnumbers '); (right after serialnumbers). That would cause a problem.

The 1st var below works OK for me without adding 1 after the 'class'. It returns the current value of the class for the item. var classitem = nlapiGetCurrentLineItemValue('item','class'); Next is a line of code that does not work for me. Basically I am trying to read the value of a custom item option for the item in the…