We have a Boomi integration that applies Journal Entries to customer invoices using a zero-dollar CustomerPayment UPSERT via SOAP. The process works like the manual NetSuite workflow: open the invoice → Accept Payment → Credits tab → select the Journal → save. The result on the invoice is an "Journal" (Journal Entry) shown as the payment source, not a traditional CustomerPayment.
Because the payment amount is zero, no CustomerPayment record is created (or it's not retrievable), so we cannot do a GET on the CustomerPayment to read its applyList.
When we try to unapply a single invoice line by sending an Update on the customer payment with an applyList payload:
<actg:applyList replaceAll="false">
<actg:apply>
<actg:doc internalId="120389"/>
<actg:line>1</actg:line>
<actg:apply>false</actg:apply>
<actg:amount>0</actg:amount>
</actg:apply>
</actg:applyList>
NetSuite returns:
Unable to find a matching line for sublist apply with key: [doc,line] and value: [120389,null]
The line here is NOT the journal body line number, and NOT the invoice line number. It appears to be an auto-incrementing key within the apply sublist itself, which increments every time a new application is created.
Questions:
- What is the correct record type and operation to unapply a single invoice from a Journal Entry applied as a zero-dollar credit?
- Where/how can we retrieve the actual applyList
line value for this kind of journal-to-invoice link? - Is there a SuiteQL table or SOAP operation that exposes this line ID without requiring a GET on a CustomerPayment that doesn't exist?
Environment: NetSuite Sandbox, SOAP API 2024.2, Boomi AtomSphere