How to print Bill Credit information on Bill Payment Vouchers?

The Standard Vendor Payment DF/HTML Template doesn’t display Credit sublist by default. You can modify it and add the code below to make transactions on Applied To and Credits Applied sublists also printed on the bill payment voucher.

  1. Navigate to Customization > Forms > Advanced PDF/HTML Templates
  2. Click Edit beside the template used by your Bill Payment Form
  3. Add the code below after Expense table is called
  4. Click Save
<#if record.apply?has_content>
<table style="position: absolute;overflow: hidden;left: 36pt;top: 90pt;width: 436pt;"><#list record.apply as apply>
<thead>
	<tr>
	<th align="center" colspan="3">${apply.applydate@label}</th>
	<th colspan="5">${apply.type@label}</th>
	<th align="right" colspan="3">${apply.refnum@label}</th>
	<th align="right" colspan="6">${apply.appliedto@label}</th>
	<th align="right" colspan="4">${apply.amount@label}</th>
	</tr>
 </thead>
  	<tr>
	<td align="center" colspan="3" line-height="150%">${apply.applydate}</td>
	<td colspan="5">${apply.type}</td>
	<td align="right" colspan="3">${apply.refnum}</td>
	<td align="right" colspan="6">${apply.appliedto}</td>
	<td align="right" colspan="4">${apply.amount}</td>
	</tr>
	</#list></table>
</#if>


<#if record.credit?has_content>
<table style="position: absolute;overflow: hidden;left: 36pt;top: 120pt;width: 436pt;"><#list record.credit as credit>
<thead>
	<tr>
	<th align="center" colspan="3">${credit.creditdate@label}</th>
	<th colspan="5">${credit.type@label}</th>
	<th align="right" colspan="3">${credit.refnum@label}</th>
	<th align="right" colspan="6">${credit.appliedto@label}</th>
	<th align="right" colspan="4">${credit.amount@label}</th>
	</tr>
</thead>
  	<tr>
	<td align="center" colspan="3" line-height="150%">${credit.creditdate}</td>
	<td colspan="5">${credit.type}</td>
	<td align="right" colspan="3">${credit.refnum}</td>
	<td align="right" colspan="6">${credit.appliedto}</td>
	<td align="right" colspan="4">${credit.amount}</td>
	</tr>
	</#list><!-- end apply--></table>
</#if>

Leave a comment

Your email address will not be published. Required fields are marked *