Compleat 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 & line data
- Invoices posted as "Draft"
- Invoices posted as "Posted"
- New suppliers (configurable option within Compleat)
- Invoice PDF
- URL link to invoice
- General Ledger posting date
- Credit note header & line date (USA Only)
- New! Fixed Assets codes
- New! Prepaid Expense codes
iCompleat receives from Sage Intacct:
- Payment terms
- Currency codes
- Account codes
- 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
- Custom fields
- Item names & ID dimensions in inventory control
- New! Prepaid Expenses codes
- New! Fixed Assets codes
You can choose to connect Compleat to Sage Intacct at either company or top level.
Connecting at company level lets you integrate a single Sage Intacct entity with Compleat. Connecting at top level integrates all of your Sage Intacct entities with Compleat, meaning you can code orders and invoices to different Sage Intacct entities when you need to.
This guide shows you how to connect your Compleat company to Sage Intacct. The setup process involves a few quick steps to get your Sage Intacct entity ready to connect with Compleat, followed by connecting to Sage Intacct from within your Compleat company.
It's quick and easy - we promise!
1. Add Compleat to Web Services Authorizations in Sage Intacct
The first step is to add Compleat 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 Compleat 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 Compleat.
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 Compleat 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.
- Prepaid Expense Class - View
- Prepaid Expense Schedule - View
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.
- On the homepage, click Configuration.
- Click Manage company.
- Select Connection.
- Next to Connect to a new finance system, click Connect.
- Click Sage Intacct.
- Enter the Sage Intacct login details for the web services user you created in step 2.
- When the connection is confirmed, click Test Connection.
- Select whether to integrate with Sage Intacct at top level, or to a specific entity, and click Connect.
- Ensure Sage Intacct is the selected from the drop-down, and click the search button.
- 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.
- In the Attachment folder drop-down, select AP Bills.This tells iCompleat where to collect data from Sage Intacct.
- 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.
- From the Base Currency drop-down, select a currency.
- Click Connect.
- 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.
- Job done!
When the connection is complete, Sage Intacct is listed as your connector.
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 > Manage 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 > Manage 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 behavior 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.