RE: 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?

Haris Beginner Asked on January 27, 2021 in How To's.
Add Comment
2 Answers

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

 

 

 

 

 

 

Rookie Answered on March 26, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.