Technically you could do CONCAT({number},CONCAT('/',{custbody12})) but the pipes are so much easier to use and understand.

CONCAT should work, but the double-pipe operator '||' should do the job as well. For example: {number} || '/' || {custbody12} || '/' || {shipto} Note that strings must always be contained in single quotes in your formulas. Let me know if that works.

it feels like the system could override functions, right? Something like that, yeah. Keep in mind the SuiteScript API is made to be extremely simple and easy to use. You don't have to worry about inheritence, polymorphism, function overriding and any other object-oriented concept.

nlapiGetOldRecord() returns the record before changes were made to it. When in beforeLoad, there have been no changes to the record, therefore there is no "old record".

Did you follow the exact instructions found here? http://suitesource.netsuite.com/s.nl/it.A/id.82/.f One thing to consider: it's possible that the plugin doesn't work on newer versions of Eclipse. The link above says to download Eclipse 3.4.

I don't know if this is related to your issues, but when you're looping through your line items and possibly removing line items, the line items shift up and you have to adjust your line item counter to account for that. Ex: You have 3 line items: 1) Apple 2) Orange 3) Banana If you remove the first one, the line items…

Anyone experiencing the prblem of Invoicing not saving and printing? It's working fine in our demo accounts. Could you be more detailed as to how you're trying to invoice and print, and what the error is?

- Do you have any scripts in your account? - Do you ever do CSV Imports, direct list editing or mass updates, particularly for items? - Do you have any web service applications connected to your account?

As a small side-note, be very careful when using Main Line True with Item Fulfillments. Unless they've corrected it, currently the main line on a Fulfillment is actually the first line item. On top of that, if you ever edit the fulfillment to remove that first line item, the Fulfillment will no longer have a Main Line at…

Just sales orders Criteria: Type = SO Date = 2/1 - 2/28 Custom field = name Results: Date Number Name Amount GP (Transaction) The only thing that would have to be looked into is that custom field. Also, make sure you don't have any summary criteria in the summary subtab.

Just sales orders You might have other criteria that are conflicting then. For example, if you have Main Line True and Item Type is Inventory Item, you will get no results since the Main Line has no item on it. Can you tell us what are the other criteria you're using?

Even www.netsuite.com is down.

Sounds like a serious issue. 2009.1 or 2009.2?

I just tested in 2009.2 beta demo account and couldn't reproduce it. I did the following: - Transactions > Customers > Refund Cash Sales - Chose a random customer - Added a random item - Saved. No error - Clicked Edit on new Cash Refund - Changed Department and clicked Save. No error. - Clicked Edit and Save right away (no…

That's odd. It works fine on my end. Do you have any scripts running on that record type? Also, is that in 2009.1 or 2009.2?

This has happened to one of our clients recently. The issue was simply that their home page was NetSuite's home page, and when opening a second browser window it would effectively log them out.

Slow/down here in Montreal.

Back online here! Same here. Looks like it was a little hiccup.

I'm not sure if it's a fluke or not, but I've been working on an e-mail alert saved search today and I've received e-mails 2 hours after they were "sent". I also received a question from a client today asking why it's taking hours before he receives his e-mail alerts from new Leads coming from his online Customer form.…

Hi Steve, I entered the following code in an Opportunity BeforeSubmit function: //TEST var myArr = new Array(53,78); if ( !myArr || myArr.length == 0 ) { return false; } for(var i=0; i<myArr.length; i++) { nlapiLogExecution('DEBUG', 'Array Test', myArr[i]); } //END TEST The loop was successfully entered and the script…

Sounds like you don't have the "Assembly Items" module in your instance. Try asking your NetSuite sales rep about it.

We've been having similar speed issues for about an hour now. We're getting lots of page timeouts. Edit: Seems much better now.

I ran into this today, and it looks like nlapiGetFieldValue() on a checkbox returns 'Yes'/'No' if the checkbox is Inline Text, and 'T'/'F' otherwise.

This seems to happen from time to time. I have two scripts that seemed to have gone "In Queue" at the same time on October 30, and are now deadlocked. Neither will start and all my scripts that are "Scheduled" status aren't entering the queue. Note that this is in Sandbox, so it may have something to do with a refresh we…

A client of ours wants to be able to direct-list edit item Preferred Stock Level and Reorder Point on items. Note that they use multiple Locations, but currently the fields in question are always associated to the main Location of the item. I checked the Lists > Accounting > Items with Administrator using their custom list…

I just spoke to Partner Support and they filed a Defect regarding columns that have pencils beside them yet they can't be Direct-List edited. The Defect Number is 135532.

You definitely don't want to try to bypass the NetSuite "Sales Order equals Customer" behavior. It's way too strict on that. For example, if you have an existing Customer with a Sales Order, you edit the Customer to revert to a Prospect, then simply Edit/Save the Sales Order, NetSuite will convert that Prospect back to a…

Personally, I'm always alternating between Chrome, Firefox and IE, but for client testing I always stick to IE. It's visibly slower, but seems more stable to me.

Looks like it's working now, thanks!

If you file a defect for these, they usually get fixed pretty quickly.