How should a partially applied Customer Deposit show on a Customer Statement?
- Sales Order for 2 items, total £100
- Customer Deposit for £100 applied to Sales Order
- 1 item fulfilled, £50
- Sales Order Billed (£50)
- Other Item cancelled / closed
The remaining £50 from the Customer Deposit shows on the Customer record as Deposit Balance, but doesn't appear on the Statement.
I can't find any documentation on the fields available on the statement record. We already have some complex customisation on our Statement template to try and show Applied Transactions clearly:
<#list statement.lines as line>
<#if line_index==0>
<thead>
<tr>
<th style="width: 13%;">${line.datecol@label}</th>
<th style="width: 35%;">${line.description@label}</th>
<th style="width: 13%;" align="right">${line.charge@label}</th>
<th style="width: 13%;" align="right">${line.payment@label}</th>
<th style="width: 13%;" align="right">Applied<br />Transactions</th>
<th style="width: 13%;" align="right">${line.balance@label}</th>
</tr>
</thead>
</#if>
** <#if line.datecol?length !=0 >
<tr>
<td>${line.datecol}</td>
<td>${line.description}</td>
<td align="right">${line.charge}</td>
<td align="right">${line.payment}</td>
<td align="right">
<#assign countLineCharge = line.charge?length>
<#assign countLineRemaining = line.amountremaining?length>
<#if countLineCharge gt 1 && countLineRemaining gt 1>
<#assign apptran = line.charge-line.amountremaining>
<#if apptran = 0>
<#else>
${apptran?string.currency}
</#if>
</#if>
<#assign countLinePayment = line.payment?length>
<#assign countLineRemaining = line.amountremaining?length>
<#if countLinePayment gt 1 && countLineRemaining gt 1>
<#assign apptran = line.payment-line.amountremaining>
<#if apptran = 0>
<#else>
${apptran?string.currency}
</#if>
</#if>
</td>
<td align="right">${line.balance}
</td>
</tr>
** </#if>
</#list>
Other than the fields used:
line.charge
line.payment
line.amountremaining
line.charge-line.amountremaining
line.payment-line.amountremaining
line.balance
What other fields are available to use on the Statement? Is there a way to show the Deposit Balance? Should this show at line level, or should we try and show it at the top/bottom of the statement?
The Customer field is {depositbalance} - adding statement.depositbalance returns nothing on the Statement, and adding customer.depositbalance returns £0.00
Has anyone found a way to show the Customer Deposit Balance on a Customer Statement?