https://netsuiteprofessionals.com logo
#suitescript
Title
# suitescript
a

Azi

03/30/2022, 1:49 PM
I have a saved search on a bill payment. If I get the field
Applied To Transaction: Terms Discount Amount
then I get results, but if I add a column for Formula text or currency for
{appliedtotransaction.termsdiscountamount}
, no results are returned. Is every searchable field able to be put in a formula
b

battk

03/30/2022, 2:00 PM
{applied for {appliedtotransaction.termsdiscountamount}
isnt a valid formula
a

Azi

03/30/2022, 2:01 PM
Sorry that was a typo. I edited it to what I really used, which still isn't working
@battk are all fields able to be put in a formula?
b

battk

03/30/2022, 2:04 PM
if its an actual column, sure
if you are asking if all the fields on a record are available to searches, the answer is no
a

Azi

03/30/2022, 2:12 PM
So where am I going wrong here
b

battk

03/30/2022, 2:38 PM
probably a bug