Skip to main content
Version: 6.12

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​

Netsuite Setup​

Netsuite facilitates OAuth 2.0 Machine-to-Machine authentication, necessitating the generation of key pairs for authorisation.

  1. Setup-> Company -> Enable Features -> SuiteCloud

    • SuiteTalk (Web Services): enable REST WEB SERVICE
    • Manage Authentication: enable OAUTH 2.0

  2. 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

  3. 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 -KeyExportPolicy Exportable -NotAfter (Get-Date).AddYears(5)

    Export the certificate and then encode with the command:

    • certutil.exe -encode .\Patriot-NetSuite-Integration.cer .\Patriot-NetSuite-Integration.pem
note

Please note that the certificate generated using the above command will expire in 5 years. You may adjust the expiration date if necessary.

  1. In Netsuite, Setup->Integration->OAuth 2.0 Client Credentials(M2M) Setup

    • Import the pem file
    • Write down the CERTIFICATE ID

  2. 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 Patriot server machine

Netsuite Customer​

In the billing section of System Wide Settings make sure the standard billing mode explicitly is set so that billing customers can be assigned for charges. A billing customer is simply any user that has the "Enable Billing" checkbox set. When this check box is set the customer tab will appear on the user's record. Customers in Patriot should be reflected in the in Netsuite as a customer.

Create Customer Arguments Example(Task):

customerUpdate --a create --customerId {customerId} --plugin "C:\PATH\PatriotNetsuiteBilling.YourCompany.dll"

Batch Generation​

Batch Generation Arguments Example (Task):

generate --batchDefinitionId {batchDefinitionId} --startDate {startDate:o} --endDate {endDate:o} --plugin "C:\PATH\PatriotNetsuiteBilling.YourCompany.dll"

Customise plugin arguments as needed. Reach out to Patriot Support for assistance tailored to your requirements.

Netsuite Batch Commit​

Batch Commit Arguments Example (Task):

commit --batchId {batchId} --plugin "C:\PATH\PatriotNetsuiteBilling.YourCompany.dll"

External Billing Integration