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, is there a way to get the internal id of the pdf document which is in file cabinet using formula? The pdf document is populated in the document type custom field in the invoice. I need to get the internal id(File id) of the pdf using saved search formula.

You can get the file without using formula but new instance of saved search.
Type : Document

or

Maybe try to search if there is File fields... on the saved search you are using and checked if there's an internal id

i need to use the formula since i have only formula field in the WF action script.

i tried using the field id of the custom field that pdf is populated .. am getting the value as xyz.pdf

i cannot process a value in the script which has .pdf in it.. thats why am trying to get the internal id

Record browser shows Internalid as search column for the file object

i need to get it from the document type ..

am getting it as abc.pdf if i use the internal id of the custom field