Please can someone help me as I'm trying to added information that is found in a column under the details subtab to the Invoice Group Advanced PDF/HTML Template so that it pulls through the information so the Customer can see which Candidates the invoices transaction lines relate to.
The column which I'm trying to get to show is called Candidate Names and is a custom column. I have tried record.invoice_details.custcolbcs_candidate_names however nothing pulls through even though information shows on the Group Invoice under the details subtab. I have included below a screen print of the subtab showing the column.
The below is a portion of the coding for the template which I'm trying to add the field to so that it pulls through the information.
</#if> <#if groupedinvoices_detailed?has_content>
<table style="break-inside: avoid; margin-top: 10px; width: 647px;"><tr style="">
<td align="left"><strong>Invoice Group Detail</strong></td>
</tr></table>
<table style="width=100%; margin-top: 10px;margin-bottom: 0px; "><#list groupedinvoices_detailed as invoice_details><#if invoice_details_index==0>
<thead>
<tr style="background-color: #d3d3d3; ">
<th align="center" style="font-weight: bold; border-left: 1px solid; border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid" width="175pt">${invoice_details.invoicenum@label}</th>
<th align="center" style="font-weight: bold; border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid; width: 64px;" width="105pt">Seq Num</th>
<th align="center" style="font-weight: bold; border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid; width: 64px;" width="205pt">Candidate Names</th>
<th align="center" style=" font-weight: bold; border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid" width="205pt">${invoice_details.item@label}</th>
<th align="center" style="font-weight: bold; border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid; " width="140pt">${invoice_details.fxrate@label}</th>
<th align="center" style="font-weight: bold; border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid; " width="140pt">${invoice_details.quantity@label}</th>
<th align="center" style=" font-weight: bold;border-top: 1px solid; border-bottom: 1px solid; border-right: 1px solid" width="175pt">${invoice_details.fxgrossamount@label}</th>
</tr>
</thead>
</#if><#if invoice_details.linesequencenumber!=0><#assign istax = (invoice_details.itemtype=="TaxItem")||(invoice_details.itemtype=="TaxGroup")><#assign ispercent = (invoice_details.itemtype=="Discount")||istax><#assign noquantity = (invoice_details.itemtype=="ShipItem")||istax><#assign notsubdesc = (invoice_details.itemtype!="ShipItem")&&(invoice_details.itemtype!="Description")&&(invoice_details.itemtype!="Subtotal")><tr>
<td align="left" style="border-left: 1px solid; border-bottom: 1px solid; border-right: 1px solid">${invoice_details.invoicenum}</td>
<td align="center" style="border-bottom: 1px solid; border-right: 1px solid; width: 64px;">${invoice_details.linesequencenumber}</td>
<td align="center" style="border-bottom: 1px solid; border-right: 1px solid; width: 64px;">${record.invoice_details.custcolbcs_candidate_names}</td>
<td align="left" style="border-bottom: 1px solid; border-right: 1px solid">${invoice_details.item}</td>
<td align="right" style="border-bottom: 1px solid; border-right: 1px solid;">${invoice_details.fxrate}</td>
<td align="center" style="border-bottom: 1px solid; border-right: 1px solid; "><#if !noquantity>${invoice_details.quantity}</#if></td>
<td align="right" style="border-bottom: 1px solid; border-right: 1px solid">${invoice_details.fxgrossamount}</td>
Please can someone advise me how I can add the column to the above so that I can get the Candidate name to pull through?