Using transaction

status

as a filter doesnt seem to work... What am I doing wrong? Here is a quick draft using the browser console: I can retrieve the status of a transaction and it shows

'A'

as a result. But if I use

'A'

as a condition for the same transaction, it gives zero results. I'm sure it something obvious, but I'm lost... Sorry if the question is very basic.

that’s weird, it’s working for me

Nop

any chance you have weird characters in your quote marks

Using things like status =

'CustInvc:A'

seem to work, despite giving the resulting column as

'A'

in the results

weird

Well, I'm now able to use

status

as a condition, but at what cost sad cow

@Edgar Valdes You might want to take a look and experiment with the BUILTIN.CF function: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_161950565221.html

Noticed this in scripts some weeks ago… specify transaction in where clause like you said

There's a

transactionstatus

table which contains all the lookup values (requires the

ADMI_SETUPCOMPANY

view permission). The statuses are specific to each

trantype

I had this issue as well, it doesn’t behave like a normal string. BUILTIN.CF or BUILTIN.DF is the way to go (can’t remember which it is now).

BUILTIN.DF

is my best friend