This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, How can I pull the value of the employee who created a transaction (purchase order)?

what have you tried, there are multiple ways to get record data, and basically all of them should be able to do this

That info is stored in the system notes, you could create a saved search that pulls the employee from the system notes.

I haven't tried anything yet, I've been looking through the record browser for an entry point. I can give the system notes a try, I was just wondering if there is a more direct way to do this?

if you want to do a search, make a search in the ui and copy it in script (in this particular case you can lookup the specific column you need)

if you want to load the record, load an existing record and examine it for the field you need

i personally wouldn't do a query, but you can do the same thing about making the query in the ui and copying it in the script

or just make a simple sql query to get what you want

This may also push you in the right direction: <https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_2/script/record/transaction.html>

Hmmmm. Actually, that won't. Surprised they don't have all the fields listed.

I can try loading the record to examine, yes, it's interesting that it's not on the record browser.

I'm not familiar with using sql queries but I can look into it, is there a benefit of that over using a saved search?

Add &amp;xml=T in your address and you should find what you're looking for in the XML.