Hi all, can anyone tell me if it is difficult to b...
# general
n
Hi all, can anyone tell me if it is difficult to bring the results of a saved search onto a PDF. I have a custom record in NetSuite that i would like to display the results of a saved search criteria on the PDF. I did some checking online and it appeared it was possible with a script to render the results, but what i tried didn't work (but i may have mucked it up or mis understood) The custom record links a bunch of return authorisations records together and its essentially the lines of the return record i would like to display on the PDF.
a
Hey Nic, you can do this without scripting using Advanced PDF. This help note explains how https://suiteanswers.custhelp.com/app/answers/detail/a_id/63077/loc/en_US
n
thank you i will take a look
Angela -you dont happen to know if i can set this to print from my custom record? In an ideal word i want to be able to easily attach this PDF to an email from it or print it. that link gets me most of the way there and i can make a workable solution but i am hoping to make it flow a bit better. In an ideal world i am hoping to produce the PDF form the custom record and include the details of the transaction lines that are all linked to that record (it doesnt have to be search results, but i could do it from search results if it was easy) PS thank you as what you sent is great too.
a
You can print to PDF by adding a custom "Inline HTML" field to the record with the URL of the search. Once you've created the search and print template, run the search and print as normal, copy the URL of that, and paste it into the "Default Value" of your custom field. You can include filters in the URL, so that it only prints the record you're viewing when you click the link. An example would be something like '<a href=https://[accountid].app.netsuite.com/app/common/custom/advancedprint/printsearchresults.nl?printType=SEARCH&amp;l=T&amp;e=T&amp;id=[saved search ID]&Transaction_INTERNALID='||{id}||'&searchid=[saved search ID]&csv=Export&printtemplate=[PDF template ID] target="blank"><img src="[URL of a button icon]"Print"></a>' In that example, Transaction_INTERNALID='||{id}||' is a filter applied to the search results before printing
I don't think it would be possible to email this from the record though...
n
Thanks Angela this is very helpful and they can live without email i think for now anyway
👍 1