Unable to find a matching line for sublist apply with key:

Question

We are seeing failure to Netsuite while updating payments via the netsuite API,

the error message we see is as below Unable to find a matching line for sublist apply with key: [doc,line] and value: [123344,null] where 123344 is the external id of the bill. Any ideas what might be the cause of this?

score 6 · Answer 1 · answered Aug 02 '17 at 16:57

Note that SuiteTalk will give you this cryptic little message when you try to create a payment for an invoice that already has an Invoice:Paid In Full transaction status.

Don't get me wrong—it's good that NetSuite has this sanity check. I just wish the error was more helpful.

score 1 · Answer 2 · answered Sep 26 '14 at 01:15

1

"Unable to find a matching line for sublist apply with key: [doc,line] and value: [123344,null]"

There is your problem, you can't match a line if you are not passing the line number.

answered Sep 26 '14 at 01:15

felipechang

916
6
14

What is the doc number used for – Naveen Raj Jan 23 '15 at 11:36
3

@NaveenRaj The doc is the internal id of the object you're applying to, in this case it should be an invoice or bill. – drewish Oct 28 '15 at 17:41
1

@drewish Thank you .. I got to know it little earlier but your post should help others people. Voted up for the comment – Naveen Raj Oct 28 '15 at 18:37
What is the line used for? – kriznaraj Nov 06 '17 at 09:11

Maureen Perednia · Answer 3 · 2015-06-25T16:29:22.533

1

We had the same problem inserting new payments, but it worked using the Internal ID for the Invoice column.

Note that the mapping specification is not clear on how to identify the Invoice when adding/updating payments for it. The API requires an invoice, and it works when you provide the Internal ID for the invoice.

edited Jun 25 '15 at 16:29

answered Jun 23 '15 at 21:47

Maureen Perednia

21
2

My recollection is that if the document you're referencing has only one line item you don't need to specify it (might default to 0?), but if there are multiple line items you'll need to provide a line number. – drewish Oct 28 '15 at 17:43

score 1 · Answer 4 · answered Nov 04 '19 at 05:02

I get this error when creating a customer payment. Below is my code. Make sure invoiceId is invoice's internal id and amount is less than or equal to invoice amount.

CustomerPaymentApply paymentApply = new CustomerPaymentApply();
paymentApply.setAmount(amount);
paymentApply.setApply(true);
paymentApply.setDoc(Long.valueOf(invoiceId));

score 0 · Answer 5 · edited Jun 30 '22 at 02:07

We were getting this error with the Chargebee-Netsuite integration. The solution was to open the corresponding Accounting Period in Netsuite and rerun the sync.

The first number [123344,null] is the Netsuite internal ID of the affected document. If you navigate to the document in Netsuite and it has a padlock this could be the reason:

Locked document

Open the Accounting Period for the affected document and rerun the sync. Setup/accounting/manage accounting periods:

Manage accounting periods

Unable to find a matching line for sublist apply with key:

5 Answers5