Discussions
NSC | Customer Payment CSV Import Using Journal Entries as Invoices and Credits
Scenario
A user attempted to import Customer Payments through CSV Import in NetSuite Release 2026.1 using both the Invoices and Credits tabs.
The import included Journal Entries used as both invoices and credits, with internal IDs mapped for Accounts, Subsidiaries, and Transactions. During the import process, the user encountered multiple validation errors, including mandatory Invoice field errors on rows related to credits.
The user wanted to determine the correct setup for importing Customer Payments that involve Journal Entries on both the Invoices and Credits tabs.
Solution
A Journal Entry cannot be applied as a payment against another Journal Entry in NetSuite. An actual Invoice transaction must exist for Journal Entries to be applied against it during Customer Payment processing.
Judy Culanding | RPM | New to NetSuite
Learn how to Refer a member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!
