3950639

Bump. Does anyone have any suggestions?

We're also having issues. NetSuite is setting fields to NULL when they should be set to some other value.

For anyone wondering, the standard format is yyyy-mm-dd See http://msdn.microsoft.com/en-us/library/ms190234(v=sql.90).aspx for more details. -Michael

Hey, I wanted to bring this up again. If any of you would benefit from a Linux ODBC driver, can you vote for Enhancement 112864? Thanks!

Olivier, Thanks very much for that distinction! That makes a lot of sense. How did you learn that? I must have just missed it in the documentation. Michael

You mean have rows where the maximum : date result field is something other than one year ago? Evan, I'm afraid I don't follow your question. Can you please ask in a different way? All rows that get returned state that the maximum : date result field is exactly one year ago. However, I think that these results are a mix of…

That worked! Thanks, Evan!

Ok--I found that I can click "Include Field Labels" on the online customer form page to include the labels. It looks like NetSuite won't translate the labels on the custom form when I switch languages in the web store, though. If I use the default registation page, the custom entity field translations show correctly. So I…

I should add that we're using a bunch of custom tags, too. We're not sticking with tags like NLEMAIL.

Brett, Thanks for your feedback! I was hoping not to rely on the user's browser settings if I could get around it, but that may be my best approach. Michael

Brett, Apart from setting my own cookie when the user changes languages, is there any way to determine the user's language if they're not logged in? -Michael

The built-in form uses labels you can override and translate on the Setup | Web Site |Customize Text pages. It looks like translating one label into multiple languages this way would require some javascript. Something like "if user's language is Korean, show this text. if user's language is Spanish, show that text." Does…

The user role probably has an Create/Edit/Full access to Custom Lists (under the Setup area). Take that off and see. For some reason, I'm not seeing where to do this. I go to Setup > Users/Roles > Manage Roles. Then I click the role I want to edit. Under the Permissions tab, there isn't a Custom Lists subtab, and I can't…

This is a bit of a bump, but does anyone have any ideas?

@rnedelkow: Thanks for your quick feedback! For some reason, something's not working. Here's what I did: 1. Created a custom list at Setup > Customization > Lists > New. 2. Created a custom entity field at Setup > Customization > Entity Fields > New. This entity field type was List/Record, and the list I selected was my…

Excellent--that did the trick. Thank you!

Elham, I'll have to look into that. Thanks for the tip! Michael

Steve, I don't have an answer, but I just learned about the RESTful support from your question. Thank you! My company requires a password change every so often. Do you know a way to access a RESTlet or use web services without having to change your password according to the company's password-changing policy? Michael

"Be aware that the system reads your library files in the order they appear on the Library Script File tab on the Script record page. For example, if your first library file references the second library file, an error will be thrown, since the first library file is loaded before the second." Kate, I saw that in the help…

Thanks for the responses! Voltron, you didn't misunderstand the question. I just didn't see anything explicit in the documentation about when library scripts get loaded. I could have just missed something, though...

You may have to parse some of the date data. See here for some helpful methods to work with JavaScript's Date object: http://www.w3schools.com/jsref/jsref_obj_date.asp

Yang, For some reason, I couldn't create new cases when using afterSubmit. I may have done something incorrectly, but I couldn't create cases afterSubmit in either the workflows or a user event script. I didn't get an error--nothing happened at all. I'll see if I can fix that. Best, Michael

You can call nlapiGetOldRecord() from any submit user event to return a snapshot of the record as it exists in the database before the submit operation. Yang, Thanks for your quick response! Do you suggest finding the field that the new case is changing on the customer record, and then using…

Yang, Ok, I got everything working...mostly. Every once in awhile, I get an error that reads: TypeError: Cannot call method "getFieldValue" of null I know from reading https://usergroup.netsuite.com/users/showthread.php?t=1291 that I'm not supposed to use getFieldValue(name) on an object returned by nlapiGetOldRecord() if…

Thanks, Yang. I'll try the postSourcing event handler.

Olivier, That worked like a charm. Thank you! -Michael

This does not cause a problem though. SuiteScripts in subfolders are usable as if they were at the top level SuiteScripts folder. Granted. It would still be helpful to be able to save to the top level SuiteScripts folder, though.

I just upgraded to Firefox 3.6.3, and I can correctly upload JavaScript files now. -Michael

We actually are doing two things to rectify this issue for us. First, we are using the scheduled email feature where you can specify both an email address and a name for the email address. How are you scheduling your emails? -Michael

For filters, you should always use the internal id. Here is the complete list of item type internal ids: Assembly Description Discount DwnLdItem EndGroup GiftCert Group InvtPart Kit Markup NonInvtPart OthCharge Payment Service ShipItem Subtotal TaxGroup TaxItem Thanks, Yang Please add this to the documentation.