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

Search Columns are not the same as Fields. `approved` is a Field on the <https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2023_2/script/record/journalentry.html|Journal Entry record> but is not a Search Column available on the <https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2023_2/script/record/transaction.html|Transaction Search> object.

I see what you mean. The way I do it, I'm reading the transaction table, and I should read the journal entry table.  Right ?

For `search.lookupFields`, you should be reading the Transaction table. For `record.submitFields`, you should be reading the Journal Entry table.

How can I access the Journal Entry table ? I tried many things without success

When I say "reading", I literally mean "reading the Records Browser" pages I linked above

Searches and Records use two entirely separate data models.

I will tell my customer to stay with the Workflow. Meanwhile I will contact Netsuite to explain me how to do it.
I greatly appreciated your help

the record, search, and query modules access data differently

dont expect record field ids to match search column ids

Thanks. I simply try to access that field. I just opened a ticket with Netsuite support.

you are using simply as in you are trying to access a record's field the same way as a search column

Yes. I'm missing something.
I can't access the field using lookup.field, nor SuiteQL.

you will not get very far without understanding that there is no approved column available to transaction in query or search

there is no guarantee that there is an approved column even if there is an approved field available to the record module

When you are writing your code, what are you using as a reference for obtaining Field IDs?

It is possible to access the field approved in the workflow. I want to do the same thing in a script.

I have opened a ticket with Netsuite. Thanks a lot

do the same thing that the workflow is doing, use the record module