Hello Experts! How to Reference Custom Fields in Grouped Invoices Using Advanced PDF/HTML Templates?
We have created a template for group invoices but unable to get “Description” field in print. Is there anyway to get that field?
Hi Haris,
We created a custom invoice form, so when they require only to show a description on the invoice, they can fill out a custom field, “Summary Description” we then matched this field on a custom Adv. PDF template, so the customer facing form only show the summary description instead of an item list.
(obviously this only work if you are showing one description line)
You can add data to an Advanced PDF template in SuiteScript using the ‘addCustomDataSource’ method on the report object:
var invoiceGroupInvoiceReportRows = { groupedinvoices_summary: [<your data>] }; var invoiceDetailReportRows = { invoice_details: [<your data>] }; xmlReport.addCustomDataSource({ format: render.DataSource.OBJECT, alias: 'results', data: invoiceGroupInvoiceReportRows })
Then reference that data in the report XML like this:
results.groupedinvoices_summary
For example:
<#list results.groupedinvoices_summary as invoice> ... </#list>
Here’s a link to the Adobe FreeMarker docs: https://freemarker.apache.org/docs/index.html
To clarify, you would add the first section of code to your PDF source code? Can you please show how this would work to expose specific fields from the invoice to the invoice group pdf, like line description, and createdfrom? These are seeded fields that are not available in the invoice group PDF, and will assume that any custom fields would work similarly.