ANS-0591 · CSV IMPORT & DATA MIGRATION
Why Does NetSuite Customer Payment Import Fail to Match Invoices?
This issue typically arises when the Accounts Receivable account specified in a customer payment differs from the A/R account on the invoices it attempts to apply.
Short answer
The NetSuite customer payment import fails to match invoices when the Accounts Receivable (A/R) account designated for the payment does not align with the A/R account associated with the target invoices. This discrepancy prevents the system from identifying available invoices for application, leading to the 'Unable to find a matching line' error.
Scenario
Users importing customer payments into NetSuite may encounter an error message stating, 'Unable to find a matching line for sublist apply with key: [doc,line].' This error indicates that the system cannot locate or apply the payment to the intended invoices. The import process is halted because the payment lines cannot be reconciled with any available open invoices.
Solution
The root cause of this import failure is a mismatch between the Accounts Receivable (A/R) account specified for the customer payment being imported and the A/R account associated with the invoices intended for application. NetSuite filters available invoices based on the A/R account linked to the payment. If these accounts do not correspond, the system will not present the relevant invoices for application, resulting in the reported error. To resolve this, ensure that the A/R account used in the customer payment import data exactly matches the A/R account on the invoices to which the payment should be applied.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support