Skip to main content

Connect Guide | 1. Preparation for connecting Moss with Sage Intacct

This is the first guide that will walk you through the preparation required to connect Moss and Sage Intacct.

Written by Rosanna Howard

Moss connects to Sage Intacct through Web Services. There are two guides you need to complete the integration. This is the first, where you will prepare Sage Intacct (Steps 1 to 3). In the next guide, you will connect and configure Moss (Steps 4 to 8).

Checklist before you connect

Make sure you have the following:

  • A Sage Intacct Web Services subscription. Step 1 shows how to enable it.

  • The Accounts Payable and General Ledger modules.

  • A Web Services user for Moss. You create it in Step 2.

You don't need to install anything. Moss uses no package, Smart Events, Platform Triggers or custom fields, and your Sage Intacct company is not customised.
​

Values you will need

Item

Value

Used in

Sender ID

NufinMPP

Client ID (REST API only)

9dc8569415bf3e1585a5.app.sage.com

Web Services user ID

moss_integration

Role name (role-based security only)

Moss Integration

Moss production IP address

34.89.228.228

Step 3, only if your company enforces IP address filters

Setup at a glance

Step

Task

Where

Required

1

Subscribe to Web Services

Sage Intacct: “Company” > “Admin” > “Subscriptions”

Yes

2

Create the Web Services user and set its permissions

Sage Intacct: “Company” > “Admin” > “Roles” and “Web Services users”

Yes

3

Authorise Moss

Sage Intacct: “Company” > “Setup” > “Company” > “Security” tab

Yes

4

Connect

Moss: “Settings” > “Accounting” > “Integrations”

Yes

5

Select the entity

Moss: accounting setup

Yes

6

Import master data

Moss: accounting setup

Yes

7

Map dimensions

Moss: accounting setup

Optional

8

Set a default supplier

Moss: accounting setup

Optional


How to prepare Sage Intacct

Step 1: Subscribe to Web Services

  1. In Sage Intacct, go to “Company” > “Admin” > “Subscriptions”.

  2. Find “Web Services” and click it to subscribe.

  3. Sage Intacct may show a warning about additional charges. You can ignore it.

Step 2: Create the Web Services user

Follow the option that matches how your company manages security in Sage Intacct: role-based or user-based. Both options end with the same user, moss_integration, with the permissions listed in the table below.

User details

Field

Value

User ID

moss_integration. You must use this exact value.

Account email address

Your choice

Contact name

Your choice

User type

Business User

Admin privileges

Off

Note: Use a dedicated user for Moss. Never use an administrator account.

Option A: Role-based security

Create the role:

  1. Go to “Company” > “Admin” > “Roles”.

  2. Click “Add”.

  3. Enter the name “Moss Integration”.

Click “Save”.
​

Set the role permissions:

  1. After you save the role, select the permissions for each module, as listed in Permissions for moss_integration below.

  2. Click “Save”.

Create the user:

  1. Go to “Company” > “Admin” > “Web Services users”.

  2. Click “New”.

  3. Fill in the user details from the table above.

  4. Open the “Roles information” tab and select the “Moss Integration” role.

  5. Click “Save”.

Note: Sage Intacct may show a warning that creating the user will incur a charge. You can ignore it.

Option B: User-based security

Create the user:

  1. Go to “Company” > “Admin” > “Web Services users”.

  2. Click “New”.

  3. Fill in the user details from the table above.

  4. Click “Save”.

Note: Sage Intacct may show a warning that creating the user will incur a charge. You can ignore it.

Add permissions to the user:

  1. Sage Intacct returns to the list of Web Services users. Find moss_integration and click “Subscriptions”.

  2. Select the permissions for each module, as listed in Permissions for moss_integration below.

  3. Click “Save”.

Permissions for moss_integration (applies to both options)

Give the user exactly the permissions as shown in the table below. The integration doesn't use anything beyond this list.

  • Rows marked * are only needed if the matching approval workflow is enabled in Sage Intacct. See Approval workflows below.

  • Rows marked “Optional” don't appear for every company. Whether you see them depends on the modules you subscribe to and on other permissions in your Sage Intacct. If you don't see an optional row, skip it.

Module

Resource

Permissions to select

Notes

Company

Departments

List, View

Company

Entities

List, View

Company

Locations

List, View

Company

Class

List, View

Company

Attachment folders

List, View, Add, Edit

Company

Attachments

List, View, Edit

Cash Management

Credit card accounts

List, View

Cash Management

Checking/Current accounts

List, View

Cash Management

Savings accounts

List, View

Cash Management

Funds transfers

List, View, Add

General Ledger

Journal entries

List, View, Add

General Ledger

Accounts

List, View

General Ledger

Journals

View

Accounts Payable

Pay bills*

Run

Optional

Accounts Payable

Approve bills*

List

“Accounts Payable” > “Setup” > “Configuration” > “Bill approval settings”

Accounts Payable

Approve vendors*

List

“Accounts Payable” > “Setup” > “Configuration” > “Vendor approval settings”

Accounts Payable

Manual payment

List, View, Add

Accounts Payable

Vendors/Suppliers

List, View, Add, Edit

Accounts Payable

Bills/AP Purchase Invoices

List, View, Add, Edit, Post

Accounts Payable

Adjustments

List, View, Add, Edit, Post

Accounts Payable

AP terms

List, View

Accounts Payable

Posted payments

List, View, Void

Accounts Payable

Tax detail

List, View

Accounts Payable

Amortization template

List, View, Add, Edit

Optional

Project

Projects

List, View

Optional

Project

Project types

List, View

Optional

Project

Project status

List, View

Optional

Project

Tasks

List, View

Optional

Project

Items

List, View

Optional

Taxes

Tax solutions

List, View

Approval workflows (applies to both options)

If bill, vendor or payment approvals are enabled in Sage Intacct, make sure moss_integration has the permissions and approval rules each of those workflows requires.

Bill approvals

Choose one of these two options:

  • Unrestricted approver. Make moss_integration the unrestricted approver under “Accounts Payable” > “Setup” > “Configuration” > “Bill approval settings” > “Unrestricted”. Bills this user submits are then approved automatically.

  • Approval policy. Set up the approval policy and give the user the approval permissions it needs at each approval level.

Note: A bill that requires approval must be approved before it can be paid. If moss_integration approves bills, its approval permissions must cover every bill the integration needs to pay, at every approval level.

Vendor and payment approvals

Set these up separately. Include the approval permissions they need and, where they apply, the approval levels.

Step 3: Authorise Moss

All three parts of this step are on the same Security tab:

  1. Go to “Company” > “Setup” > “Company”.

  2. Click “Edit” and open the “Security” tab.

  3. Complete the parts below that apply to you.

  4. Click “Save”.

3a. Add the Moss Sender ID

  1. In the section “Web Services authorizations”, click “Add”.

  2. Enter the Sender ID: NufinMPP

3b. Authorise the client application (REST API only)

  1. In the section “Authorized client applications”, click “Add”.

  2. Enter the Moss Client ID: 9dc8569415bf3e1585a5.app.sage.com

  3. Enter the Web Services user ID: moss_integration

Note: This field is case-sensitive. Enter the user ID exactly as you created it in Step 2.

3c. Add the Moss IP address (if applicable)

Skip this part if your Sage Intacct company doesn't enforce IP address filters.

  1. Find the field “Enforce IP address filters” and click the edit icon.

  2. Add the Moss production IP address: 34.89.228.228

  3. Click “Save”.


Moss needs no other configuration in your Sage Intacct modules and no package to install. It uses no Smart Events, Platform Triggers, outbound webhooks or custom fields, and your Sage Intacct company is not customised.


You have finished the preparation, and you are ready to start connecting Moss and Sage Intacct.

Did this answer your question?