RE: How can I batch invoices into customer payments using the REST API?

Hi all,

Having trouble creating/transforming invoices into customer payments using the REST API. I have no issue transforming an invoice into a customer payment like so:

POST {{REST_SERVICES}}/record/v1/invoice/4960/!transform/customerpayment 

However I’d like to add multiple invoices to a customer payment in one API call, and I’m not sure how to do that. When I structure my request like this;

How can I batch invoices into customer payments using the REST API?

I get the following error:

{
“type”: “https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1”,
“title”: “Error while accessing resource: You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist.”,
“status”: 400,
“o:errorCode”: “USER_ERROR”
}
Ideally I would be able to transform multiple invoices into a customer payment…perhas by using the transformation of customer->customerpayment. But I’m not sure how to include multiple invoices that way.
Thanks!
Jonathan Rookie Asked on August 28, 2020 in SuiteTalk.
Add Comment
7 Answers

Hi Jonathan,

Invoice grouping may well get you to the end result from what I’ve seen but I don’t think it’s included in any of the documentation at the moment.

In case you loop back to some of your original thinking, I believe this is the sort of area you’d need to look at in order to update the apply sublist:
https://netsuite.custhelp.com/app/answers/detail/a_id/87133

The keys in question should be the references to the invoices that you want to pay.

I hope this might help and, equally, I’ve done a little playing around with Invoice Groups so please feel free to give me a shout if you want to discuss anything in that area too.

Thanks,

Chris

Intermediate Answered on August 31, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.