Netsuite Integration
NetSuite, a product of Oracle Corporation, is a comprehensive and cloud-based suite of business management applications. Designed to streamline and integrate key business processes, NetSuite offers a unified platform encompassing ERP (Enterprise Resource Planning), CRM (Customer Relationship Management), e-commerce, and financial management.
Prerequisites
- A Patriot Billing License with the AccountingNetsuite module
- Read External Billing Integration
Netsuite Setup
Netsuite facilitates OAuth 2.0 Machine-to-Machine authentication, necessitating the generation of key pairs for authorisation.
-
Setup-> Company -> Enable Features -> SuiteCloud
- SuiteTalk (Web Services): enable REST WEB SERVICE
- Manage Authentication: enable OAUTH 2.0
-
Setup -> Integration -> Manage Integrations -> New
- Enable CLIENT CREDENTIALS (MACHINE TO MACHINE) GRANT and REST WEB SERVICES.
- After creating the Integration, you need to write down CONSUMER KEY / CLIENT ID and CONSUMER SECRET / CLIENT SECRET
-
Creating a self-sign Certificate. This certificate needs to be created at the machine that running Patriot Billing Utility Program(It usually runs with the Task Service).
-
New-SelfSignedCertificate -Subject Patriot-NetSuite-Integration -CertStoreLocation 'Cert:\LocalMachine\My' -KeyLength 4096
Export the certificate and then encode with the command:
-
certutil.exe -encode .\Patriot-NetSuite-Integration.cer .\Patriot-NetSuite-Integration.pem
-
-
In Netsuite, Setup->Integration->OAuth 2.0 Client Credentials(M2M) Setup
- Import the pem file
- Write down the CERTIFICATE ID
-
Modify ApplicationSettings.config under the Patriot Billing Utility Program.
- NetsuiteCertificateId = CERTIFICATE ID
- NetsuiteConsumerKey = CONSUMER KEY / CLIENT ID
- CertThumbprint= The Thumb Print of the self-sign certificate
- TimeOffset = Specify this only if the Netsuite Server time varies from that of your machine