1. Add Compleat to Web Services Authorizations in Sage Intacct
2. Create a Web Services user in Sage Intacct
Compleat can fully integrate with Sage Intacct to share your accounts payable & 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
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)
iCompleat receives from Sage Intacct:
- Payment terms
- Currency codes
- Account codes
- Departments
- Projects
- Delivery sites
- Journal reference of posted invoice
- Invoice payment status
- Tax codes (depending on Sage Intacct customer territory)
- Simple user-defined fields
- Locations
- Custom fields
- Class
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 & 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 & 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 & is essential if you want to enjoy two-way integration between Compleat & Sage Intacct.
To do this, log into Sage Intacct, & go to Company > Setup > Company.
Add CompleatMPP to your list of Web Services Authorizations, & 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.
Once you've created the user, you'll get an email from Sage Intacct confirming the username & password, & 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, & 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, & click Edit beside it.
Click View Subscriptions, & 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 & protects all the information that's passed between Sage Intacct & iCompleat. Any information shared is secure & encrypted.
To connect to Sage Intacct, follow these steps.
- On the homepage, click Configuration.
- Click Company management.
- 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.
- Ensure Sage Intacct is the selected from the drop-down, & click Search.
- 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.
- Select which types of Sage Intacct suppliers you'd like to cache into iCompleat.
Any supplier types that you don't select won't be available to use in iCompleat for ordering & coding invoices.
- In the Attachment folder dropdown, select AP Bills.
This tells iCompleat where to collect data from Sage Intacct.
- Click Connect.
- Select the features you use in Sage Intacct for your company from the drop-downs, & 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 in Company Management.
5. Customization
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 & 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 management > Connection, & set the Posting toggle to Draft.
Created & 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 & edit these by going to Configuration > Company management > Connection, & selecting Configure next to Custom fields.
To view a custom field or 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, & 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 & 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.
Comments
0 comments
Please sign in to leave a comment.