Hello, I am looking for an integration solution th...
# integrations
m
Hello, I am looking for an integration solution that allows me to recieve purchase orders from Coupa and import them into Netsuite. We would also need to transmit our invoices back into the customers Coupa account. Everywhere I look the solutions seem to be customers requesting orders from Coupa vendors and we need a solution that does the opposite. I currently use Celigo for a majority of our business and I am reaching out to them to see if this is something they can support but any other option suggestions would be greatly appreciated.
w
I have yet to find one. I had to roll my own for both Coupa and Ariba.
c
You can do this with Celigo's integrator.io product, this will be considered a 'custom' integration though and will require building and testing.
you can also build a custom integration directly in NetSuite but you'll need a SuiteScript developer. At least with this option there is no recurring fee as once its built in NetSuite, it's yours forever. @manderegg
m
@Craig I figured I would have to deal with this, I am in touch with my rep and a technical consultant over there to go over this.
c
If you choose Celigo, you'll just need to configure the webhook or batchjob and then the record import into NetSuite, it probably won't be too complex but will require functional knowledge of Celigo Integrator.
Doing it with SuiteScript (direct integration) will take a bit longer but should work out to have a lower total cost of ownership as long as it's done well.
m
@Craig I am very familiar with Celigo and Integrator.io (Been using it forever)
👍 1
c
Looks like you’ll be using it some more for a Coupa integration :-)
m
At least it gives me a break from dealing with X12 all day haha.
m
We have inhouse edi and celigo and actually suitescript'd our coupa integration.
If you are familiar with Celigo, prob your best bet.
t
@manderegg - If I understood it correctly, you have a customer that uses Coupa. They will send you POs that need to be imported as sales orders into your NetSuite account. When you invoice the POs, you need to send the invoice back to the customer’s Coupa account. Is it correct? If this is correct, the POs will be transmitted to you in CXML format via POST requests. You will have to process this CXML file and create the sales order in NetSuite. Then when the SO is invoices, you will have to convert the invoice into the CXML format and submit it to the customer’s account. CXML is the only option to receive POs or create invoices in customer’s Coupa account. We have done this integration before with a custom Nodejs server and NetSuite scripts. 1. Coupa sends POs to the Node sever > the server translates CXML to JSON > the server sends the PO to a restlet script in NetSuite > the restlet script creates the Sales Order 2. Invoice is created in NetSuite > Script deployed to the invoice sends it to the node server > node server creates the CXML and submits it to Coupa