Hi,

I want to build a CV Management solution in NetSuite where for each Employee, we can list their assigned Projects (roles, duration, etc.) and generate bulk CV PDFs based on filters (e.g., department).

However, the challenge is that Employee and Project data are not available together in an Advanced PDF/HTML template, making it difficult to pull both sets of data into one PDF.

Has anyone faced this?

• What’s the best way to fetch and merge Employee + Project data for PDF generation?
• Is a custom record or SuiteScript (Map/Reduce + render.pdf) approach preferred?
• How can bulk PDF generation be handled efficiently in NetSuite?

Any suggestions or best practices are appreciated!