Show only open invoices on a NetSuite statement

Use Generate Statements and enable Show Only Open Transactions when a customer asks which invoices still need attention. Review the output against the agreed cutoff before printing or emailing it.
Upload a case

Key facts

The Balance column shows what remains due on a partially paid invoice.

Generate a statement for the right customer

Open Customers › Accounts Receivable › Generate Statements. Select the intended customer. For a current list of all open transactions, set Statement Date to today, leave Start Date blank and select Show Only Open Transactions. Use Print to review the output. For a past cutoff, check the Open Transactions on Statements accounting preference and reconcile the output before you share it.

Verify what the customer will see

Check the customer name, subsidiary or hierarchy where relevant, currency and open invoice references. Compare any amount the customer questions with its invoice and applied transactions. An unapplied payment may require separate investigation before a new request for payment. Use Balance for the amount due. Charge and Payment show transaction totals, while Balance reflects what remains after partial payment.

Send the document that answers the question

Use the statement when the customer wants an account view. If they only need proof for a single invoice, share the invoice and the relevant payment or credit references as appropriate. Save the date and version supplied so the next analyst can reproduce the figures.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.