• Home
/
• Working in m3ter - User Guides
/
• Integrations
/
• Setting Up and Managing Native and Notification Integrations

Configuring NetSuite Integrations

ou can define and manage native integrations for sending your end customer Account Bills generated in m3ter outbound into your NetSuite system:

• First, create the integration.

• Second, set up authentication for the integration to connect with NetSuite.

This topic also includes a section designed to help you set up NetSuite in preparation for connecting and authenticating your m3ter integration with your NetSuite instance:

• Setting Up your NetSuite System

Creating the Integration

You can quickly set up a native NetSuite integration from the Configurations page in the Console.

To define a m3ter - NetSuite integration:

1. Select Integrations:

The Configurations page opens in Grid view.

2. Under Netsuite, select Configure new integration>Integrate bills with NetSuite:

The Create page opens and the Entity type - Bill and External system - NetSuite are shown at the top of the page.

3. Use the Global configuration panel to:

• Enter a Name for the Integration. This is required and is useful if you intend to create multiple Integrations for the same External system/Entity Type and need to clearly differentiate them.

• Select the Accounts you want the integration to apply to:

  • Account ids. Select the Accounts you want to include - all selected Accounts are treated as allowed for the integration.

  • Restricted account ids. Select the Accounts you want to exclude - all selected Accounts are treated as not allowed for the integration.

• Select Users for Email notifications if disabled:

  • Integration disabled notification users. Select Organization Users you want to receive an Email notification if the integration is automatically disabled.

4. Use the Entity configuration panel to configure the m3ter entity you will be synchronizing with for the integration. In the case of an outbound Bill integration, this entity will be the Bill generated for a customer Account in m3ter:

• Only send bill on approval. Enable this if you only want Bills to be sent when they have been approved. If disabled, the Bill will be sent every time it is regenerated. Default is disabled. Note that:

  • The frequency of Bills sent will depend on the billing frequency defined for the Account Plan attached to the Account - such as daily/weekly/monthly/annually.

  • If an Account has a Prepayment on it and the billing for Prepayment fees is configured to run on a customized schedule, Bills will be sent when scheduled Bills are generated.

  • If a Bill is manually recalculated the updated Bill will be sent.

  • If you enable this, then the integration will not run for all Bill Jobs.

• Use external mapping account code. Enable this if you want the integration to look in the External Mappings for the Account identifier, which means you can use an external Id. If this is disabled, the m3ter Account Id is used. Default is disabled.

• Excluded line item types. Filter the Bill line items you send to the destination system. For example, only send charges or credits and exclude all other line items.

  • For details of line item types, see Bill Line Item Types.

• Account filter. Optionally, enter an expression that is run on the Account to determine whether or not the integration is run. You can use this setting if you have multiple destinations for sending Bills outbound to your NetSuite system. For example:

  • customFields != null AND customFields.country = = UK

  • In this example, the integration will run for an Account only if you have created a Custom Field for the Account called country and given the field a value of UK.

• Enforce external mappings for config. Optionally enable this if you want the integration to use only those external mappings specified as being for this configuration.

  • Use this setting if you want to set up multiple integrations for the same external system. You can then create separate external mappings for each integration from the details page of each integration, and these external mappings become Linked external mappings for the specific integration. See Creating Linked External Mappings.

5. Use the External system configuration panel to enter the settings specific to the external system. These settings include field mappings as well as other system-specific configurations:

• Split usage line items. Select how you want to split line items in the outgoing Bill. Three options:

  • Item per usage band. Create a line item on your NetSuite invoice for each pricing band.

  • Item per product. Create one NetSuite Item per m3ter Bill Item.

• Netsuite send due date. Whether the calculated due date is sent from m3ter to NetSuite. If this option is disabled, NetSuite will default the due date based on the customer configuration.

• Netsuite commitment item id. Enter the Id of the Commitment item in NetSuite. This field is only required if you are representing Commitments with a specific NetSuite Item. If not configured, the NETSUITE_DEFAULT_ITEM_ID will be used.

• Netsuite minimum spend id. Enter the Id of the Minimum Spend in NetSuite. This field is only required if you are representing Minimum Spends with a specific NetSuite Item. If not configured, the NETSUITE_DEFAULT_ITEM_ID will be used.

• Netsuite default item id. Enter the Id of the Default item in NetSuite. This will be used if there is no External Mapping entity configured in m3ter between m3ter and NetSuite - for example "Other".

• Netsuite item mapping. Enter the details for mapping each Bill line item type to their corresponding items in NetSuite. Optionally map each line item type in m3ter with a specific Item in NetSuite. These values will be used if there is no external mapping for a NetSuite Item. For any of these fields which are not populated, the value in NETSUITE_DEFAULT_ITEM_ID will be used as the default for that line item type.

  • For details of line item types, see Bill Line Item Types.

• Netsuite item custom field mapping. Optionally choose a specific mapping to NetSuite Custom fields. Currently, there are only two fields for a line item available for mapping to NetSuite Custom fields:

  • servicePeriodStart

  • servicePeriodEnd

• Sort line items by. Optionally, select a property to sort line items by before they are sent out to the external system. Three options:

  • None

  • Subtotal

  • Aggregation ID

6. Select Create integration. You are taken to the details page for the integration, where you can immediately complete the configuration by setting up authentication to allow the integration to connect with your NetSuite system - see the following Setting Up Authentication section for details:

• Note that if you are not ready to continue your workflow and set up authentication immediately, you can do this at a later time.

Setting Up Authentication for the Integration

When you have created a NetSuite integration, you can select an Integration Credential you've created for authentication allowing the integration to connect with your NetSuite system:

• Note that if you've followed the workflow given in the earlier section for creating the integration, on creation you'll be taken directly to the Integration Details page to continue and immediately set up authentication. The procedure described in this section assumes you've returned at a later date to set up authentication for the integration - the main steps you need to follow if you're setting up authentication immediately after creation are the same

To set up authentication for your m3ter - NetSuite integration:

1. Select Configurations. The Configurations page opens in Grid view.

2. Select the NAME hotlink text of the NetSuite integration you want to set up authentication for. The Integration details page opens:

• Notes:

  • A warning is shown that the integration is not yet connected to your NetSuite system.

  • The ID of the integration configuration is shown at the bottom of the Details card, and you can copy the ID directly to your clipboard.

3. Select Add credential. A Select one credential modal appears.

4. Select a Credential you created earlier and want to use to authenticate the integration with NetSuite. See Creating NetSuite Integration Credentials.

5. Select Confirm. The modal closes and on Integrations details, the integration now shows as CONNECTED:

• If at any time you want to disconnect the integration, select Disconnect.

• If you want to use a different Credential for connecting the integration, select Update credential. The Select one credential modal appears and you can select a different Credential.

Setting Up your NetSuite System

This section provides guidance on setting up Netsuite in preparation for connecting and authenticating your m3ter integration with your NetSuite instance and to allow m3ter to send out Bills to NetSuite. The set up work is in four stages:

• Prerequisites

• Configuring NetSuite

• Key Pair Generation

• Configuring m3ter

Prerequisites

For your NetSuite instance, you'll first have to complete the following:

1. Go to Setup>Company>Enable Features:

• Select the SuiteCloud tab.

• Select the option for OAuth 2.0.

• Accept the OAuth 2.0 Terms and Conditions.

2. Go to Setup>Users/Role>Manage Roles>New:

• Create a new Role for the m3ter integration. This Role will need read access to Customer/Items and read/write access to Invoices.

• Select the option for Web Services Only Role.

• Select Save.

3. Go to Setup>Users/Roles>Manage Users>New:

• Create a new User for the m3ter integration that uses the m3ter integration Role you’ve just created.

4. Go to the Custom>List, Records & Fields>Transaction Column Fields>New. This opens Transaction Line Field.

5. Enter a LABEL, such as m3ter External ID.

6. Enter the ID as: _m3ter_external_line_item.

• This will create a custom field for transactions called: custom_m3ter_external_line_item.

7. Check that the TYPE setting is Free-Form Text.

8. Under Applies to check SALE ITEM.

9. Select Save and Apply to Forms.

Configuring NetSuite

1. Go to Setup>Integration>Manage Integrations>New:

• Enter a NAME - for example: m3ter Integration - and a DESCRIPTION.

• Unselect the options for TOKEN-BASED AUTHENTICATION, TBA: AUTHORIZATION-FLOW, and AUTHORIZATION CODE GRANT.

• Under OAuth 2.0:

  • Select the option for CLIENT CREDENTIALS (MACHINE TO MACHINE) GRANT.

  • Under SCOPE, select the options for:

    • RESTLETS

    • REST WEB SERVICES

    • SUITEANALYTICS CONNECT

2. Select Save. Under Client Credentials, you'll see your credentials appear:

• CONSUMER KEY / CLIENT ID

• CONSUMER SECRET / CLIENT SECRET

3. Go to Setup>Integration>OAuth 2.0 Client Credentials (M2M) Setup:

4. Select Create New. This opens the Create a New Client Credentials Mapping modal:

• ENTITY is the user you want to grant access for.

• ROLE is Administrator.

• APPLICATION is m3ter Integration for this example.

• Under CERTIFICATE, select Choose a file. A select file dialog opens. Locate and select the m3ter-cert file. The chosen file will then show as selected.

5. Select Save. The Create a New Credentials Mapping modal closes.

6. Back on the OAuth 2.0 Client Credentials (M2M) Setup page, copy and save the CERTIFICATE ID.

7. Copy and save the URL prefix of your NetSuite instance. For example:

• 1234555567-sb1.app.netsuite.com

You can now open your m3ter Organization and perform the required set up work there - see the following section.

Key Pair Generation

This section explains how to generate a new key pair using OpenSSL.

1. Open a command line terminal window on your local machine.

2. Enter and run the following command:

1
openssl req -x509 -newkey rsa:4096 -sha256 -keyout m3ter-key.pem -out m3ter-cert.pem -nodes -days 730
2

3. When the command runs, you'll be asked to enter some details:

• Country name

• Organization

• Email address

Two files are generated in the current directory.

4. Perform a list command to check. Two files should be listed:

• m3ter-cert. This certificate will be uploaded to Netsuite.

• m3ter-key. This private key will be loaded into m3ter.

Configuring m3ter

You can set up authentication for your m3ter NetSuite integration to connect with your NetSuite instance through the m3ter Console as described in the above section and using the Netsuite Connection modal:

On the modal, enter the settings for authentication with your NetSuite system for the integration:

• Account Id. Enter the NetSuite Account Id. You can find this on the Setup>Company>Company Information page in the NetSuite console.

• Client Id. Enter the m3ter Integration Client ID, which was available when the integration was set up in the NetSuite console.

• Certificate Id. The Certificate ID. You can obtain this from the Setup>Integrations>OAuth 2.0 Client Credentials Setup page in the NetSuite console.

• Upload Netsuite Credentials. Allows you to upload a private key - click Browse and select the m3ter-key.pem you created under Key Pair Generation above using OpenSSL.

Configuring m3ter Using Command Line

Alternatively, you can configure the m3ter connection with your NetSuite instance from the command line:

1. Log into your m3ter Organization.

2. Open a command line terminal window and run the following command in the same directory that you created the key pair files in:

1
base64 -i m3ter-key.pem | pbcopy
2

This will encode the file as Base64 and copy it to the clipboard.

3. Send the following POST API call with the relevant substitutions to this endpoint:

/organizations/{orgId}/integrationauth/Netsuite/netsuiteauth

1
{
2
    "type" : "NETSUITE_AUTH",
3
    "accountId" : "{Customer's account ID}",
4
    "certificateId" : "{Certificate ID}",
5
    "clientId" : "{ClientId from Netsuite}"
6
    "privateKey" : "{Base64 encoded m3ter-key.pem file}"
7
}
8

Note that the "accountId" required is the URL prefix of your NetSuite Instance, of the form 1234555567-sb1.

Next: Managing Multiple Third Party Destinations for Integrations

Additional Support