โ01-03-2022 02:39 PM
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โ
โ01-03-2022 04:01 PM
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.
โ01-05-2022 08:37 AM
Thank you @mbowen , actually it was an error from NetSuite. There is an script within NetSuite causing this behavior. Thanks for your help.