Yes You Can: Generate a NetSuite Customer Statement on an Invoice with Customer Deposit Accounting

This article is relevant if you are seeking to produce a NetSuite invoice and include an accompanying customer statement of open transactions.


Ever since we created the Content Renderer Engine (CRE), we have now been able to solve important client concerns that were simply too challenging (read, possible but was rigid due to scripting and basically cost prohibitive) to previously implement.  In the most recent case, we have a number of clients that have wished to produce a customer statement of outstanding amounts due on each and every invoice they distribute.   Because the Content Renderer Engine allows us to link multiple NetSuite Saved Searches and provide the results to an array of Advanced PDF templating tools (e.g., FreeMarker, Big Faceless Organization BFO, Trimpath and Handlebars), we can produce amazing branded PDF / HTML outputs.

Getting A Customer Statement to an Invoice

The first challenge for generating a consolidated customer statement is to understand how to craft the saved search to find the open transactions.  Here, we can solve the frequently heard complaint which is to include NetSuite Customer Deposits in an AR aging analysis.  We spent discovery effort by crafting a saved search that brings back all the related transactional data that can affect the amounts outstanding. Indeed, it gets tricky to reference partially applied credit memos, journal entries, unapplied payments into the entire mix.

Once we solved for the saved search, we were able to link together related elements in a CRE Profile record; this allows us to supply an invoice as a starting point for the action. ¬†Using the invoice, we can link out to the customer to grab more data. ¬†From the customer, we can then find all the open transactions representing the accounts receivable and customer deposit information. ¬†Some clients have wished to see an entire tree of sub customer transactions — no problem. ¬†It’s just another linked search.

Use CRE to Develop the Multi-Faceted Invoice

In the downloadable sample draft invoice with customer statement, done in one of our development environments, we illustrate how we can craft the CRE Profile definition.  With the interactive test and development toolset, we can see the data that comes back starting with a specific invoice.  The CRE tool helps us see the actual data generated interactively and thus provide us the exact template syntax we need which helps us prevent surprises and increase our productivity.

Solve your Invoice and Customer Statement Advanced PDF Challenge with CRE

The CRE tool is available for us by all of our clients without charge. ¬†The tool though is meant to be used by a NetSuite Administrator who is strong with Saved Search and Advanced PDF template work. ¬†As such, we help by offering services to solve specific client concerns that serve as an opportunity to train on the tool use. ¬†If you feel your organization would benefit from a customer statement embedded in an invoice, or you see another application for CRE, let’s have a conversation.

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is Southern California's NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 25 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - Google Plus - YouTube

| Tags: , | Category: Accounting, NetSuite, Reporting | 4 Comments


  1. Posted August 17, 2017 at 6:50 am | Permalink

    Is there a way to use the SuiteTalk API to download Invoice PDF files? I’m finding that the physical PDF file doesn’t actually exist in NetSuite but can be generated on the Invoice Communications subtab & sublists. I need to find a way to integrate the Invoice PDFs into Salesforce. Any insight is greatly appreciated. Thanks.

  2. Posted August 26, 2017 at 11:28 am | Permalink

    Hi Steven,

    With our CRE Tool, it would be easy to expose a NetSuite REST endpoint for you to consume your Invoice PDF to Salesforce. The Content Renderer Engine bundle is available to our NetSuite customers. Feel free to contact me if you need an implementation.


2 Trackbacks

  1. […] Yes You Can: Generate a NetSuite Customer Statement on an Invoice with Customer Deposit Accounting […]

  2. […] Unique Link: each invoice has a unique link to pay just that invoice. ¬†A token key is used to prevent url tampering. ¬†The link is available on the transaction and can be used in invoice PDF operations (see our Content Renderer for full invoice presentation control). […]

Post a Comment

Your email is never published nor shared. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>