This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi All, does anyone using coupa? Actually I want to source the PO# from coupa link and display in the FAM records. Can someone help me on this integration?

not sure that you can customize a FAM record, but i can provide general integration advice

Please advice me. I am not familiar with coupa

usually you start with choosing a netsuite record to integrate with a coupa

looks like you want a FAM related custom record (which one)

what coupa related object do you want to integrate it with

I want to populate coupa PO# and REQ# number into NetSuite

you probably want to start at the object level

are you integrating with coupa purchase orders? requisitions? The lines for either of those objects?

that personally sounds strange to me but thats your choice

you have 2 integration methods available from coupa

their restful api: <https://success.coupa.com/Integrate/Technical_Documentation/API>

or their csv via SFTP: <https://success.coupa.com/Integrate/Technical_Documentation/CSV>

for the RESTful api, you would want to use their purchase order api (<https://success.coupa.com/Integrate/Technical_Documentation/API/Resources/Transactional/purchase_orders>) to get the purchase order related to your asset

im not sure what criteria you would use to get the purchase order, but you will probably need to add some sort of search query: <https://success.coupa.com/Integrate/Technical_Documentation/API/Get_Started/Querying_Options>

If you are using their flat csv file, you would need code to download the file and parse it, and then have logic to map the csv rows into your Assets

I personally expect that you will have to build an integration that links Coupa Purchase orders to NetSuite purchase orders

hopefully there is already an existing process that allows you to determine which coupa purchase order matches a netsuite purchase order

set fields on the netsuite purchase order to match the coupa purchase order and then use a Fixed Assests mapping to set fields on your Assets

<https://systen.na0.netsuite.com/app/help/helpcenter.nl?fid=section_1501725267.html>

you might also want to look at Coupa's integration with NetSuite, which I did not know was a thing

<https://success.coupa.com/Integrate/ERP_Playbooks/NetSuite>