Hi NetSuite Community, We are currently migrating open Accounts Receivable balances from a legacy ERP system into NetSuite. Some customers have credit balances resulting from overpayments or duplicate payments in the legacy system. We would like to migrate these balances into NetSuite so that they can be applied against future invoices. Our requirements are: * We do not want to create credit memos, since these are not related to sales returns or invoice adjustments. * We would like to preserve the customer overpayment as a customer credit balance. * Ideally, the balance should remain available to be applied to future invoices. * We are migrating historical open AR balances as part of a cutover process. What would be the recommended NetSuite approach for migrating these customer overpayments? For example: * Import a Customer Deposit? * Import a Customer Payment without an invoice? * Use a Journal Entry linked to the customer? * Another best-practice approach? How have others handled customer overpayments during a legacy-to-NetSuite migration? Thanks in advance for your advice. Mary

Thanks for the tag @Clarisa De Torres-Oracle Hello @Mary Rivas I have used Unapplied Customer Payments for this in the past and it worked well. Just create the Customer Payment records and leave the Apply sublist blank. The credit sits on the customer account, shows up in aging as a negative in the CURRENT bucket, and when the next invoice comes in the AR team can apply it through Accept Customer Payments like any normal payment. No special handling needed. For bulk volume you can bring these in via CSV import -- SuiteAnswers Article 31638 that was mentioned above covers this well. Just make sure the offset goes to a migration clearing account rather than your live bank, and your cutover JE takes care of the rest. Hope this helps!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Child Item

Ask A Guru

Child Item

Best Practice for Migrating Customer Overpayments / Double Payments from Legacy System into NetSuite

Mary Rivas

Hi NetSuite Community,

We are currently migrating open Accounts Receivable balances from a legacy ERP system into NetSuite.

Some customers have credit balances resulting from overpayments or duplicate payments in the legacy system. We would like to migrate these balances into NetSuite so that they can be applied against future invoices.

Our requirements are:

We do not want to create credit memos, since these are not related to sales returns or invoice adjustments.
We would like to preserve the customer overpayment as a customer credit balance.
Ideally, the balance should remain available to be applied to future invoices.
We are migrating historical open AR balances as part of a cutover process.

What would be the recommended NetSuite approach for migrating these customer overpayments?

For example:

Import a Customer Deposit?
Import a Customer Payment without an invoice?
Use a Journal Entry linked to the customer?
Another best-practice approach?

How have others handled customer overpayments during a legacy-to-NetSuite migration?

Thanks in advance for your advice.

Mary

Find more posts tagged with

#DataMigration #AccountsReceivable #CustomerPayments #CustomerOverpayments #OpenAR #FinancialDataMig

Component react.asset.answerThread had an error.

You are not allowed to view comments.

Child Item

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
Big ideas. No travel required. SuiteWorld On Air brings the best of SuiteWorld directly to you. Stream keynotes live, access exclusive virtual content, and connect with the NetSuite community from wherever you are. Explore what's next for NetSuite, see AI innovation in action, and discover practical insights designed to…
Learning Lab | DC
Drive better outcomes with AI built into NetSuite Next Capital Hilton,1001 16th St NW, Washington, DC 20036 Join NetSuite experts for a free half-day event where you'll get a tour of NetSuite Next, explore AI-powered capabilities built into the platform, and learn practical ways to optimize NetSuite for your business. At…
Inside the Suite | DC
Take NetSuite Next for a hands-on test drive Capital Hilton, 1001 16th St NW, Washington, DC 20036 What to expect: Inside the Suite is designed for companies exploring modern ERP solutions. This event gives you the opportunity to experience NetSuite Next - the next evolution of NetSuite that brings AI directly into how…
What's Next for Product Companies with NetSuite
WEBINAR What's Next for Product Companies with NetSuite See how NetSuite Next uses AI to improve accuracy and protect margins Ask. Understand. Act. Use Ask Oracle to search, navigate, analyze business data, surface insights, get guidance, and take action using natural language—all through a single conversational…

More events