In this article
Pento has been working closely with NetSuite to develop an integration that allows you to push your payroll information directly from Pento into NetSuite.
allows you to:
- Manually map and populate your NetSuite account codes to the departments/pay items in Pento.
- Manually push your payroll information into NetSuite.
- Map departments and locations from Pento to NetSuite using a 1-to-1 relationship based on an exact match of values.
Before you connect Pento to NetSuite, you will need to make sure the Organisational Structures and journal template are correctly configured in Pento.
a. Configuring Organisational Structures in Pento
Departments and Locations can be pushed from Pento to NetSuite. The integration works by matching the organisational structure values in Pento with the classifications in NetSuite.
You can check the setup of your organisational structure by going to Settings > Organisational structure.
To push the Departments information, you'll need an organisational structure named Departments, and each of the values should match those listed as departments in NetSuite.
To push the Location information, you'll need an organisational structure named Locations, and each of the values should match those listed as locations in NetSuite.
b. Configuring your Payroll Journal Template
The payroll journal template structures the information pushed through to NetSuite. You can follow our guide to configure your journal to your preferences.
2. Configuring NetSuite
You will need to configure NetSuite in a particular way where specific tokens are generated to connect Pento to NetSuite. A NetSuite administrator will need to follow the steps defined in our NetSuite Authentication article.
3. Connecting Pento to NetSuite
- In Pento, go to your Settings.
- Select Overview in the Integrations section. Find NetSuite and click on Integrate.
- Add the requested information from NetSuite:
Account ID: Located in NetSuite > Setup > Setup Manager > Company Information
Token ID and Token Secret: See step 3 in the NetSuite Authentication article.
I know my consumer key and secret toggle: In most cases, you won't need to fill this out if you're connecting to NetSuite for the first time via the NetSuite SuiteApp. If, for some reason, you have generated a new key and secret in NetSuite, you will need to populate this. You can toggle on I know my consumer key and secret and enter your details.
- Click Integrate. Pento will use the credentials provided to develop a connection with NetSuite. You will see a success message to confirm the status of the connection.
4. Configuring your NetSuite integration
You can configure your journal preferences once you have connected Pento and NetSuite.
Select a subsidiary: Select the relevant subsidiary from NetSuite. Journals will be posted against this subsidiary.
Customise payroll journal: Using the standard payroll journal setup, you can configure how the information from Pento should be passed to NetSuite. Select Edit Template to review/amend the configuration.
Save your changes to the template – it will be used to post information to NetSuite.
5. Sending your Journal to NetSuite
You can send your journal to NetSuite for any draft and submitted payrolls. Click on the menu option next to the required payroll and select Send to NetSuite. If you manually send the journal to NetSuite before payday, Pento won't send it again on payday.
You'll see a message to confirm whether the journal can be posted successfully. The journal will be published in the Journals area in NetSuite with the status Pending Approval.
Why can't I post my Journal to NetSuite?
In some situations, Pento won't be able to post your Journal to NetSuite. When there's an issue, an error message will be displayed to help you identify it. Here are the examples of messages you might see:
- Journal already exists in NetSuite
If the journal for a payroll already exists in NetSuite, the sending will fail. To resend the journal, you will need to delete the original entry in NetSuite.
- Unbalanced Journal
If you split your journal by Departments and/or Locations, all employees on the specified payroll need to be allocated to a Department and/or Location. If not, your journal will be unbalanced. Pento will highlight the employees who are not assigned so you can update them.
- A subsidiary was not selected.
Before you can send your journal to NetSuite, you will need to select the relevant subsidiary in the Integration Settings (see Step 4).
Why aren't my departments and/or locations pushing to NetSuite?
If your departments and/or location are not pushing to NetSuite, you should double-check your setup:
- An organisational structure called departments or locations exists in Pento, and the values match NetSuite exactly. If the exact wording is not used in the field name or the values do not match precisely, they will not map over.
- Your journal template is configured to split by Departments and locations.
I need help with my credentials.
If you have set up NetSuite without installing the SuiteApp, you will need to provide your own client credentials. If you don't have this information stored, you can go to Setup > Integration > Manage Integrations. On the following screen, select the integration you want to connect to, then click on Edit > Reset Credentials: