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!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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