ExtendInsights Data Management lets you use a Customer Payment template to apply payments, existing credit memos, or unapplied payments to open NetSuite invoices.

For example, when a customer has an open invoice and an available credit memo, you can apply the credit memo to reduce the outstanding invoice balance.

This article covers the standard workflow for applying a payment or credit to an invoice using one Customer Payment record.

Watch the video below, or follow the written instructions.

Before You Begin

Before building the Customer Payment template:

Identify the customer and open invoice.
Locate the invoice internal ID.
Locate the internal ID of the credit memo or unapplied payment.
Determine whether you are also applying a cash payment.
Identify the Accounts Receivable account and applicable bank account, if needed.

In the NetSuite Classic interface, you can review the Customer Payment form by going to:

Transactions → Customers → Accept Customer Payments

Tip: Review the NetSuite form before building the template. Identify the required header and sublist fields for your account and custom form.

Template Layout

Header-Level Fields

Field	Instructions
Tran Date	Enter the transaction date.
Tran ID	Enter the transaction ID when applicable.
Customer	Select the customer associated with the invoice, payment, or credit.
Payment	Enter the cash payment amount. Set this to `0` when applying only a credit memo or unapplied payment.
Undep Funds	Set to `True` or `False` based on whether the payment should be held in Undeposited Funds.
AR Acct	Enter the Accounts Receivable account when required.
Account	Enter the bank account when the payment has already been deposited.
Memo	Enter an optional description for the transaction.

Apply List Fields

Use the Apply List fields to identify the invoice.

Field	Instructions
Apply List: Apply	Set to `True` to apply the payment or credit to the invoice.
Apply List: Doc	Enter the internal ID of the invoice.
Apply List: Amount	Optional. Enter the amount to apply. If left blank, NetSuite applies the available amount based on the transaction.
Apply List: Replace All	Optional. Set to `True` or `False` based on the applicable payment scenario.

Credit List Fields

Use the Credit List fields to identify the existing credit memo or unapplied payment.

Field	Instructions
Credit List: Apply	Set to `True` to apply the credit memo or unapplied payment.
Credit List: Doc	Enter the internal ID of the credit memo or unapplied payment.
Credit List: Amount	Optional. Enter the amount to apply. If left blank, NetSuite applies the available amount.
Credit List: Replace All	Optional. Set to `True` or `False` based on the applicable payment scenario.

Apply a Payment or Credit Memo to an Invoice

Knowing the Internal ID of the invoices and credit memo/ unapplied payment is essential when applying for customer payments.

We recommend you load your original Invoice and Credit memo/unapplied payment into ExtendInsights for easy reference and load the customer payment template in a separate tab.

Step 1: Create and Load the Invoice and Customer Payment Template

Load the invoice and credit memo or unapplied payment into Excel for reference.

Include the fields needed to identify the records, such as:

Internal ID
Subsidiary
Entity
Transaction Date
Transaction ID
Total

💡Tip! You can retrieve the invoices you want to apply for payment using a data filter, saved search, or reload action. Read the articles below:

Different Ways to Retrieve Data from NetSuite
Working with Analytics and Data Management

We recommend loading the source records on one worksheet and the Customer Payment template on a separate worksheet.

Step 2: Create the Customer Payment template based on the template layout

Create a template for the Customer Payment record and add the required header, Apply List, and Credit List fields.

At a minimum, the template should include:

Customer
Payment
Undep Funds
Account, when applicable
Apply List: Apply
Apply List: Doc
Credit List: Apply
Credit List: Doc

Step 3: Enter the Header and Invoice Details

Populate the Customer Payment and Apply List fields.

For example:

Field	Example value
Customer	Customer associated with the invoice
Payment	Payment amount, or `0` when applying only a credit
Undep Funds	`False`
Account	Bank account where the payment was deposited
Apply List: Apply	`True`
Apply List: Doc	Invoice internal ID
Apply List: Amount	Amount to apply, or blank when applying the available amount

Step 4: Enter the Credit Details

Move to the Credit List fields and enter:

Field	Value
Credit List: Apply	`True`
Credit List: Doc	Credit memo or unapplied payment internal ID
Credit List: Amount	Amount to apply, or blank when applying the available amount

Review the customer, invoice, credit, and amount before uploading.

Applying multiple credit memos to one invoice?

Enter Apply List: Doc and Apply List: Line only on the first row. Enter each credit memo on a separate row using the Credit List fields.

Repeating the same Apply List values on every row can cause NetSuite to return a duplicate invoice entry error.

See Troubleshooting: Duplicate Invoice Entry When Applying Multiple Credit Memos for the required template structure.

Step 5: Upload the Customer Payment Record

In ExtendInsights, click Upload to NetSuite.
Review the selected rows.
Click Upload Records.
Review the upload results.
Correct and retry any rows that return an error.

Verify the Results in NetSuite

After the upload completes:

Open the affected invoice in NetSuite.
Go to History → Payments.
Confirm that the Customer Payment record appears.
Verify that the intended payment, credit memo, or unapplied payment was applied.
Confirm that the remaining invoice balance is correct.

Possible scenarios include:

A full payment and credit memo applied to an invoice.
A partial credit memo applied to an invoice.

Best Practices

Always use internal IDs for invoices, credit memos, and unapplied payments.
Download the source records before building the Customer Payment upload.
Test with one Customer Payment record before uploading a larger batch.
Set Payment to 0 when applying only credits.
Confirm that all records belong to the same customer.
Review the applied amounts before uploading.
Validate the invoice balance in NetSuite after the upload.
Use the separate troubleshooting instructions when applying multiple credit memos to one invoice.

Need Help?

If the upload fails or the payment is not applied as expected, contact CloudExtend Support at cloudextend-support@celigo.com.

Include:

The complete NetSuite error message
The Customer Payment template
The invoice internal ID
The credit memo or unapplied payment internal ID
A screenshot of the upload results

How to Apply Customer Payments and Credit Memos to NetSuite Invoices