Thanks! We've decided to use a scheduled script to run the search, create the CSV file from the results, and store the file in the file cabinet.

Thanks!! It's working now.

Hi Dylan, Unfortunately we did not. We gave our AR user roles permission to run it on-demand, instead. -Kristin

Thanks for the info! I've passed it along to our CFO.

Just wanted to say thanks - this helped me, too!

I second the "thanks!" This is exactly what I was looking for, too!

Corey, Thank you so much!! I checked and Java auto-updated using the 32-bit version, and I needed the 64-bit. Problem solved! -Kristin

Nelliott, Thanks! I wasn't aware that was possible. Is 'entityid' the (numerical) internal ID, or the text ID (for example, custentity_myco_abc)? Thanks, Kristin

I got a reply from NetSuite customer support: "I have researched internally that it's an expected behavior that nlobjSearchResult returns all of the columns of a search result including the synonyms to support scripts that references the legacy (synonym) field names of the columns. It's just that, using getAllColumns()…

Thanks kimosalen! I think my problem was related to the discrepancy NetSuite described. I was trying to use: var searchResult = searchRecords[i]; var columns = searchResult.getAllColumns(); The columns variable was different from searchResult.columns(), which was throwing me off. Now I'm using: var custID =…

Thanks for the reply. I'm very new to NetSuite - you're saying there's a way I can create a series of checkboxes, and depending on which one is marked, different fields will appear? How can I set this up? (If you can point me in the right direction, I'd be very grateful!)

Sponsors are similar to customers, but they need to be separate records. Some customers will also be sponsors, and the departments contacting them need to keep their information in separate places. (In other words, if someone contacts a sponsor about grant opportunities, she wants to capture that information in the…

Thanks for the reply! I want to run a saved search that includes information from the imported records. It seems like the best way to do this is to write a script that will do the import, and then initiate the workflow.