Follow-up to this... I see that I can add user fields to formulas ({user.internalid} or {user.email}) but as soon as I include these in my search formulas (result or criteria), no results are returned on the customer center (but there are results as an Administrator). Is this a security restriction of the customer center?

As a followup, I was able to get the navigation working with the following solution: I went to Web Site Themes and removed all the HTML from the "Site Navigation Portlet Template" section. I then was able to take the navigation bar HTML code (the top part of each navigation section that had the words "Navigation" in it)…

The web page is an Interanet web page so it isn't available to the rest of the world: just locally to one of my clients. I need the call to be synchronous because I am attempting to validate on click that a file exists in NetSuite. I was hoping I could call a synchronous RESTlet but the cross domain requests makes sense.…

Yes I was able to get my RESTlet to work synchonously. I just set up a .NET webservice on an .asmx page that called my RESTlet. Thanks for all the help!

So now I've got my Suitelet set up. I can navigate directly to the Suitelet so I know it works. But I'm getting an "Access is denied" error on my .NET web page. var suitelet = null; // Mozilla/Safari if (window.XMLHttpRequest) { suitelet = new XMLHttpRequest(); } // IE else if (window.ActiveXObject) { suitelet = new…

I changed the "Submit" button my Suitelet to say "Refresh" and then in the "POST" I called nlapiSetRedirectURL to go back to the same Suitelet page. Then when it goes back to my Suitelet, it will essentially be refreshed. You might need to pass some data via url parameters in the nlapiSetRedirectURL so you can filter the…

No I never did. The only way I've found to do it is completely refresh the page. It would be awesome if I could do this somehow. I know NetSuite does it on some of their pages.

I would like to see this feature as well. Is there an enhancement request for this out there? Thanks.

Thank you. This works great.

I don't have multiple quantity pricing turned on so I don't think the matrix code applies to me. I got the same error when I tried to set the matrix value. I tried the following code and it didn't break but it also didn't set the price. var kit = nlapiCreateRecord('kititem'); kit.setFieldValue('itemid', 'Test123'); var…

Anyone figure this out? Is there a way to get the group members through the API?

I tried that and it still didn't work. I submitted a case to NetSuite and right now the workaround is to put the submitRecord in a try/catch block. They have filed a defect and are working on a fix. Thanks.

The reason this is client-side is because this code goes on the estimate form and is used to generate a project from the estimate. To do this, I add a button and then call a client-side method when the button is clicked. We create estimates and like to generate projects directly from the estimates. I was able to get it…

I tried all the different combinations for these optional parameters and it doesn't matter what I set them to. I thought that ignoring mandatory fields would take care of the problem but it didn't.

So there is a way to create deployments in SuiteScript?

Thanks for the suggestions... One thing I'm wondering about is what about deployments? This scheduled script is going to be queued by every time something with the sales order changes. But it looks like nlapiScheduleScript uses an existing deployment. So if I have 2 deployments and the three people save a sales order at…

It's a little more complicated than that. Based on the quantities of the line items on sales order we update certain custom fields on the line items' member items. We do this whenever the sales order is created, edited, and deleted. So we need to know the old and new values of the sales order's line items and then have the…

Thought I'd bump this post and see if anyone has any ideas...

Ok thanks. I think this may be supported in 2008.1. It would be nice if the documentation said that those calls were for server-side only. :)

This is currently not supported but you could implement it in a Suitelet that gets called (requested) from the client. Could you explain what you mean by this and maybe post a little sample code? I created a Suitelet and then attached client-side code to that Suitelet form and then added a button that called…

After playing around with it some more I figured out how to make it work. Basically, on the page init, I select the line, edit the current line item value, and then commit the line. So the page init looks like this: var count = nlapiGetLineItemCount('item'); for (var i=1; i<= count; i++) { var taskId =…

I used a numeric formula field with the formula {quantity} - {quantityshiprecv} is not 0. Works good when I run the saved search results.

Yeah I thought about doing that. The only problem is that I'm using that saved search to do some filtering that I don't think can be done using nlobjSearchFilter. I only want to show purchase order line items where the quantity received is not equal to the quantity. I don't want to return all the PO line items and have to…

Even without that filter, it still does not work. The quantities show up fine in the results. Another interesting thing to note is that if I add quantity committed and quantity billed to the saved search, the quantity returns null (in SuiteScript). I just did that I found that out.

You mean this code? var poResults = nlapiSearchRecord ('purchaseorder', 37, null, null ); for (var j=0; j < poResults.length; j++) { var qtyTotal = poResults[j].getValue('quantity'); var qtyRecv = poResults[j].getValue('quantityshiprecv'); }

No I checked and "Status" is definitely not there on the filter. We are doing something different now so this is not too urgent anymore. But I would be curious to know if it can be done. Creating a sublist on the fly is probably a good way to go... Thanks.

Thought I'd confirm that this is now working. I was able to add two columns to my saved item search (Inventory Numbers: Number and Inventory Numbers: On Hand) and then I was able to access those fields via SuiteScript using the following code... var results = nlapiSearchRecord('item', 91, null, null); var t = ''; for (var…

I was able to create an Inventory Numbers Saved Search and this has all the data that I need. The problem is that I don't know what type to use. So when I call "var results = nlapiSearchRecord(type, 49, null, null);" where 49 is the id of my save search, I'm not sure what "type" should be. I've tried inventorynumbers,…

Yes that works fine for displaying the serial numbers. Of course, that does not help with accessing quantity information for lot number records. Thanks for the assistance.

However you should be able to search for them by specifying the item record type. do you mind giving a little bit of sample code? I tried the following: var cols = new Array(); cols[cols.length] = new nlobjSearchColumn('internalid'); cols[cols.length] = new nlobjSearchColumn('inventorynumbers'); var results = new…