NetSuite Insights & Guides | CuriousRubik

Print NetSuite customer statements by currency

Written by CuriousRubik | Feb 21, 2014, 10:27:00 AM

To print open customer balances by currency, use NetSuite’s statement-generation page and review the date, transaction and form settings before printing. With Multiple Currencies, customer statements use separate pages for each transaction currency. See Oracle’s customer statement overview.

Oracle documentation reviewed: 7 October 2026. This guide covers the standard documented workflow; confirm your account’s role, enabled features and custom forms before a production batch.

Before you start

  • Confirm that your role can access the intended customers and the statement-generation page. If access is missing, ask your administrator to review the Generate Statements permission, identified by Oracle as TRAN_STATEMENT, and the access appropriate to your task. See Oracle’s permission names and IDs.
  • For transactions in several currencies, confirm that Multiple Currencies is enabled and that the relevant currencies are associated with the customer. Older accounts can have a separate Multi-Currency Customers feature. See customers and multiple currencies.
  • If you use advanced printing, ask your administrator to confirm that the selected statement form uses an appropriate multi-currency template. Oracle provides a Standard Multi-currency Statement Template and explains the feature differences for accounts originating before and after 2014.2. See multi-currency statement templates.

Print open balances for several customers

  1. Open Customers > Accounts Receivable > Generate Statements, the route in Oracle’s current statement-generation instructions. The original article’s Transactions > Customers > Generate Statements route also appears in Oracle’s invoice-group statement instructions. If neither route appears, have your administrator confirm the navigation for your role.
  2. Set Statement Date. This date also determines aging.
  3. Select Show Only Open Transactions for open items. Leave Start Date blank to include open transactions from the customer’s full history.
  4. If using Consolidated Payments, select Consolidated Statements only when you want the customer and subcustomer hierarchy’s combined balance. Leave it clear for individual customer balances.
  5. Select the intended statement form and customers. Use Customize or the available group filter to narrow the list before selecting a batch.
  6. Click Print. Submit each page of selected customers separately before moving to another page.

These steps follow Oracle’s bulk-printing guidance and statement-generation guidance.

Check the result

The printed output should contain separate statement pages for currencies in which the customer has a balance. With Consolidated Payments, the consolidated statement has a separate page for each currency used in the customer hierarchy. Before distributing the batch, review a sample for the intended customers, currencies, date and balances. See Oracle’s explanation of balances in multiple currencies.

Important limits and troubleshooting

  • Historical dates: Oracle warns that combining Show Only Open Transactions with a date other than today can produce balance discrepancies. Review the date and filters before relying on a historical statement.
  • Part-paid invoices: With open-only output, the Charge and Payment columns show transaction totals; the Balance column carries the remaining amount.
  • Zero-balance customers: Include Zero Balances applies to customers with a zero balance at the statement date and receivables activity in the selected date range. Enable it only when that is the intended batch.

These date and balance behaviors are documented in Generating Statements. If currencies are missing from a customized advanced template, have the administrator check its multi-currency structure against Oracle’s advanced-template requirements; changing filters alone may not correct the form.