Integrate iCompleat with Sage Intacct for real-time AP automation

iCompleat can integrate with Sage Intacct to share your accounts payable and purchasing data in real-time.

• Supports top-level or entity level integration
• Supports dimensions that have been renamed in Intacct
• Supports 'Vendor Type' categorisation filter in Intacct
• Supports simple UDDs, does not support UDDs with formulae or one-to-many relationships
• New! Integrates with Fixed Assets module
• New! Integrates with Prepaid Expenses module

Compleat posts to Sage Intacct:

• Invoice header and line data
• Invoices posted as "Draft"
• Invoices posted as "Posted"
• New suppliers (configurable option within iCompleat)
• Invoice PDF
• URL link to invoice
• General Ledger posting date
• Credit note header and line date (USA Only)
• New! Fixed Assets codes
• New! Prepaid Expense codes

iCompleat receives from Sage Intacct:

• Payment terms
• Currency codes
• Account codes
• Departments
• Projects
• Delivery sites
• Bank details
• Journal reference of posted invoice
• Invoice payment status
• Tax codes (depending on Sage Intacct customer territory)
• Simple user-defined fields
• Simple employee dimensions
• Locations
• Custom fields
• Class
• Item names and ID dimensions in inventory control
• New! Prepaid Expenses codes
• New! Fixed Assets codes

You can choose to connect iCompleat to Sage Intacct at either company or top level.

Connecting at company level lets you integrate a single Sage Intacct entity with iCompleat. Connecting at top level integrates all of your Sage Intacct entities with iCompleat, meaning you can code orders and invoices to different Sage Intacct entities when you need to.

This guide shows you how to connect your iCompleat company to Sage Intacct. The setup process involves a few quick steps to get your Sage Intacct entity ready to connect with iCompleat, followed by connecting to Sage Intacct from within your iCompleat company.

It's quick and easy - we promise!

 

1. Add iCompleat to Web Services Authorizations in Sage Intacct

The first step is to add iCompleat to the Web Services Authorizations list in your Sage Intacct account. This lets the two systems share information with one another and is essential if you want to enjoy two-way integration between iCompleat and Sage Intacct.

To do this, log into Sage Intacct, and go to Company > Setup > Company.

Add CompleatMPP to your list of Web Services Authorizations, and make it active.

 

2. Create a Web Services user in Sage Intacct

Next you need to create a Web Services user. This is a user within Sage Intacct that you'll use to perform the integration with iCompleat.

Make sure the user you create has full admin privileges. 

Once you've created the user, you'll get an email from Sage Intacct confirming the username and password, and the company within Sage Intacct that it's associated with.

To create the user in Sage Intacct, go to Company > Admin > Web Services Users.

 

3. Create a role with the correct permissions

The final step within Sage Intacct is to give your new Web Services user a role that has the correct permissions in place so that iCompleat can access the information it needs.

With your Web Services user still on screen, go to Roles Information, and click a cross (+) icon in the grid to add a new role.

We recommend calling the role CompleatWebServicesUser.

Then, go to Company > Roles, find your new role in the list, and click Edit beside it.

Click View Subscriptions, and then configure the permissions for each of the modules in the drop-downs below.

If there are modules listed that you don't use, you don't need to configure their permissions. We've only listed the permissions that you should enable; you can leave all other permissions unticked.

 

 

4. Connect to Sage Intacct

Our connector manages and protects all the information that's passed between Sage Intacct and iCompleat. Any information shared is secure and encrypted.

To connect to Sage Intacct, follow these steps.

 

1. On the homepage, click Configuration.
2. Click Company.
3. Select Connection.
4. Next to Connect to a new finance system, click Connect.
5. Click Sage Intacct.
6. Enter the Sage Intacct login details for the web services user you created in step 2.
7. When the connection is confirmed, click Test Connection.
8. Select whether to integrate with Sage Intacct at top level, or to a specific entity, and click Connect.
9. Ensure Sage Intacct is the selected from the drop-down, and click the search button.
10. If you're connecting Sage Intacct at company level, select the entity you want to connect to iCompleat.

    If you're connecting at top-level, ensure Top Level is selected from the available companies drop-down.

    
11. In the supplier email drop-down, select whether you'd like iCompleat to cache primary or secondary supplier email addresses for sending approved orders.
12. In the Attachment folder drop-down, select AP Bills.This tells iCompleat where to collect data from Sage Intacct.
13. Select which types of Sage Intacct suppliers you'd like to cache into iCompleat.

    All supplier types are selected by default, but you can click the black X to remove this option and manually select supplier types individually.

    Any supplier types that you don't select won't be available to use in iCompleat for ordering and coding invoices.

    
14. From the Base Currency drop-down, select a currency.
15. Click Connect.
16. Select the features you use in Sage Intacct for your company from the drop-downs, and then click Save.

    Our recommended settings are already selected by default.

    
17. Job done!

    When the connection is complete, Sage Intacct is listed as your connector.

 

5. Customisation

Once iCompleat is connected to your Sage Intacct company, there are a couple of extra customization steps you can take.

 

Choose how invoices are posted to Sage Intacct

By default, fully approved invoices in iCompleat are posted to your Sage Intacct company as Submitted invoices. If you'd like to carry out work on invoices in Sage Intacct after they are posted and use an approval process outside iCompleat, you can choose to instead have invoices posted to Sage Intacct as Drafts.

To do this, go to Configuration > Company > Connection, and turn off the Posting toggle.

 

 

 

Created and edit Sage Intacct custom fields

iCompleat extracts your user-defined custom fields from Sage Intacct so that you can use them to code transactions.

You can view and edit these by going to Configuration > Company > Connection, and selecting Configure next to Custom fields.

 

If you use the Prepaid Expenses and Fixed Assets modules in Sage Intacct, you can configure the relevant custom fields for those modules here.

 

 

To view a custom field and edit its behaviour in iCompleat, select it from the list.

Depending on the type of custom field (Date, Predefined, Number, Simple text, etc.) your options for editing may vary.

Here's a custom date field, with the options to allow past dates, future dates, and make it a mandatory field on invoices to be posted to Sage Intacct:

 

 

Select Add a new custom field at the top of your list of custom fields to create a field that iCompleat can use to code transactions and post to Sage Intacct.

 

 

Here's an example of a predefined custom field created in iCompleat. To find out about the different types of custom fields available to you, check out Custom field types.

 

 

 Still got questions? Comment below and let us know how we can improve this article.