NetSuite always trowing an error even if the bill is created successfully

[Alix]

I’m facing an issue with the netsuite create snap. The flow is creating a new bill in netsuite, however the job always returns the below error saying that the reference number is a duplicate even if the bill gets created. I have tried many times adding different references and every time the bill gets created but the response from the netsuite snap is the same:

Have you seen this error?

{

“error”:

“An error occurred while executing the SOAP request”

“stacktrace”:

“com.snaplogic.snap.api.SnapDataException: An error occurred while executing the SOAP request\n\tat com.snaplogic.snaps.netsuite.NetSuiteCommon$3.call(NetSuiteCommon.java:482)\n\tat com.snaplogic.snaps.netsuite.NetSuiteCommon$3.call(NetSuiteCommon.java:429)\n\tat com.snaplogic.snaps.netsuite.NetSuiteCommon.doWithRetry(NetSuiteCommon.java:560)\n\tat com.snaplogic.snaps.netsuite.NetSuiteCommon.postRequest(NetSuiteCommon.java:429)\n\tat com.snaplogic.snaps.netsuite.NetSuiteCommon.makeRequestWithDocument(NetSuiteCommon.java:403)\n\tat com.snaplogic.snaps.netsuite.Create.process(Create.java:115)\n\tat com.snaplogic.snap.api.ExecutionUtil.process(ExecutionUtil.java:106)\n\tat com.snaplogic.snap.api.ExecutionUtil.executeForDocument(ExecutionUtil.java:118)\n\tat com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:81)\n\tat com.snaplogic.snap.api.SimpleSnap.execute(SimpleSnap.java:70)\n\tat com.snaplogic.snaps.netsuite.NetSuiteCommon.executeForSuggest(NetSuiteCommon.java:321)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:798)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.executeForSuggest(SnapRunnableImpl.java:647)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:856)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:435)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:117)\n\tat java.base/java.util.concurrent.FutureTask.run(Unknown Source)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)\n\tat java.base/java.util.concurrent.FutureTask.run(Unknown Source)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)\n\tat java.base/java.lang.Thread.run(Unknown Source)\n”

“reason”:

“{soapenv:Body={@xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/, @xmlns:xsd=XML Schema, @xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance, addResponse={@xmlns=urn:messages_2020_1.platform.webservices.netsuite.com, writeResponse={platformCore:status={@xmlns:platformCore=urn:core_2020_1.platform.webservices.netsuite.com, @isSuccess=false, platformCore:statusDetail=[{@type=ERROR, platformCore:code=USER_ERROR, platformCore:message=Duplicate [Reference No. - Vendor] Combination found, saving is not allowed}, {@type=WARN, platformCore:code=WARNING, platformCore:message=Reference No. 123456test6 is a duplicate for this vendor. Click OK to save duplicate or click Cancel and change Reference No.}]}}}}}”

“resolution”:

“Please verify that the incoming data is valid and sufficient for the request”

“status_code”:

“error”

[mbowen]

Hi @Alix :

This might require a bit more investigation. The stack trace is helpful, but the error message is from Netsuite. The message indicates a duplicate reference number for the vendor, but you recognize this and it appears you have tried many such numbers.

I’m less familiar with Netsuite setup, so not sure if this can be fixed there.

I would suggest logging a support ticket. We have many folks who are well versed in Netsuite. You can copy and paste this message into the ticket.

SnapLogic

Getting Help

Automate employee workflows from talent management to employee on and offboarding, all in one platform.

[Alix]

mbowen:

stigation. The stack trace is helpful, but the error message is from Netsuite. The message indicates a duplicate reference number for the vendor, but you recognize this and it appears you have tried many such numbers.

I’m less familiar with Netsuite setup, so not sure if this can be fixed there.

I would suggest logging a support ticket. We have many fol

Thank you @mbowen , actually it was an error from NetSuite. There is an script within NetSuite causing this behavior. Thanks for your help.