I've been working at this for 3+ days and have tried a dozen or more forge assets.

The task each month is to create 3000+ one-page invoices and save them as PDFs to SharePoint (see attached simple invoice example). These invoices include logos and other images plus a fair amount of formatting. I've tried:

• Filling in Excel templates --> converting excel binary to HTML --> Generating PDF from HTML. None of the forge asset's Excel to HTML handle the formatting / images correctly.
• Creating the invoice in a screen with input variables for all data --> Generate PDF from the screen's URL. I get a blank PDF.
• Creating the invoice in a screen with input variables for all the data --> From within the screen's On Ready action Generate PDF from the screen's URL. Same thing, I get a blank PDF.
• Writing raw HTML outside of Outsystems --> replacing a dozen markers with data --> Generating PDF from HTML. This has come the closest to working, but getting the formatting right is very frustrating.
• Using Ultimate PDF Print to PDF Advanced with the screen's URL. It does nothing and eventually times-out.

Id really like to be able to use an Excel template or a screen / block to process each invoice and be able to save the resulting binary or HTML to a PDF.

I've not found anything that lets me convert Excel straight to PDF (except a for pay asset that would be cost prohibitive).

I also have to generate hundreds of invoice summary reports that lists each invoice for a customer (can be hundreds of rows; multiple pages) and save as a PDF. This also has logos and images that need to appear in the report header, page header and page footer. I've tried to use the HTML2PDF_Advanced 's Footer attribute, but can't get that to handle URL's or HTML.

How can I create a report with headers and footers on each page?

I haven't tried fillable PDFs yet as I am awaiting a license to a version of Adobe Acrobat that I can create these with.

I've read many forum posts about this subject, but am unable to get any solution to work.

Thanks in advance.