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, doing a saved search to get baseprice, doesn't work when use formula {pricelevel1}, something wrong? thanks

What type of saved search are you creating?

search.create({
                        type: 'item',
                        filters: [['internalid', 'is', itemInternalid]],
                        columns: ['baseprice', {name: 'formulacurrency', formula:'{pricelevel1}'}]
                    }).run().each(res =&gt; {
                        log.debug('res', res)
                    })
the output is following
{"recordType":"inventoryitem","id":"19846","values":{"baseprice":"400.00","formulacurrency":"ERROR: Field Not Found"}}

depending on your account's setup, you may be able to simply use the base price column

yeah, just curious, works for other pricelevels like {pricelevel5} but not {pricelevel1}

depends on the features enabled in the account, item pricing gets complicated quickly