CODEWITHSUNDEEP
netsuite
Moin Y
Moin Y

Reputation: 61

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

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?

Upvotes: 5

Views: 11974

Answers (5)

Claire
Claire

Reputation: 11

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

Upvotes: 1

Alex
Alex

Reputation: 1771

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));

Upvotes: 1

markplindsay
markplindsay

Reputation: 875

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.

Upvotes: 6

Maureen Perednia
Maureen Perednia

Reputation: 21

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.

Upvotes: 1

felipechang
felipechang

Reputation: 924

"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.

Upvotes: 1

Related Questions