Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Customer Statement - Partially Applied Deposit
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>
0