Has anyone managed to get footers on advanced pdf templates to only appear on the last page? Lots of sources online say it's not possible due to the way Freemarker and BFO work for NetSuite's pdf generation but some have mentioned that it is possible with suitescript/PBR tags

Dont do it as a footer. Do it as a table that you put in the end of your code and place it in the bottom of the page. I’ve never done it myself but I guess it could work