Good morning folks, anyone here use SOAP to apply ...
# suitetalkapia
Ady
04/27/2020, 5:16 PMGood morning folks, anyone here use SOAP to apply customer payments to invoices? I'm trying to process payments that may or may not have the invoice number associated with them, and if they do, the amount may or may not match the invoice amount. my question is regarding the index value in the CustomerPaymentApplyList. Is there a way to apply payment amounts to specific invoices by specifying only the invoice internal ID and the amount and let native netsuite do the rest? or do I have to specify the correct index every time? I'm getting a lot of "Unable to find a matching line for sublist apply with key: [doc,line] and value: [2350,0]" errors
b
battk
04/27/2020, 5:21 PMare you using initialize
a
Ady
04/27/2020, 5:24 PMyep, from customer
b
battk
04/27/2020, 5:26 PMyou are supposed to initialize the customer payment, then go through the CustomerPaymentApplyList and mark the apply checkbox of the payments you want to apply to
a
Ady
04/27/2020, 5:28 PMand set amountSpecified to True? what I've seen so far is that it likes to apply the invoice amount and then total the payment amount to equal all the invoices, regardless of the amounts I specify for either.
b
battk
04/27/2020, 5:30 PMim not sure what amountSpecified is
a
Ady
04/27/2020, 5:31 PMit's a true/false on the applylist. I'm just trying to get it to not ignore my amounts. 🙂
b
battk
04/27/2020, 5:31 PMyou can change the amount of the CustomerPaymentApply
a
Ady
04/27/2020, 5:31 PMI'll give True. BTW, you've been a life saver 🙂
b
battk
04/27/2020, 5:58 PMim still not sure where you are getting amountSpecified, but the way to do this is to set the apply and amount fields on the CustomerPaymentApply
a
Ady
04/27/2020, 11:08 PM4th line from the end https://netsuite.custhelp.com/app/answers/detail/a_id/22520/kw/soap%20payment/related/1
b
battk
04/27/2020, 11:15 PMbeware suiteanswers, neither the schema browser nor the xsd list an amountSpecified
a
Ady
04/27/2020, 11:16 PMI know but it's in the library in VB so might as well give it a try. so far it's been ignoring the amounts I set completely and just uses the invoice total. Haven't tried with the amountspecified just yet
Ady
04/29/2020, 5:25 PM@battk just a quick follow up. it looks like if you want to control how much is applied to each invoice when creating a payment, you have to set .amountSpecified = true on the apply list. similarly, if you want the payment not to default to the invoice totals you have to set paymentSpecified = true on the payment record.