Use the Sage Intacct integration to connect Ordway with Sage Intacct and configure how supported records and transaction data are mapped and synchronized between the systems. You can configure default integration settings, map customer and product data, map the chart of accounts, and configure invoice and journal entry mappings.
After connecting the integration, configure the settings and field mappings for each data type you want to synchronize.
For Ordway clients handling transactions in multiple currencies, be sure to read the following article before proceeding.
Contents
- About the Sage Intacct Integration
- Connect Sage Intacct to Ordway
- Configure Default Settings
- Configure Data Synchronization
- Map Customer Data
- Map the Chart of Account
- Configure Journal Entry Mapping
- Map Product Data
- Map Invoice Data
- Map Credit Data
- Map Payment Data
- Check Integration Status
- Disconnect the Integration
About the Sage Intacct Integration
The Sage Intacct integration connects Ordway with Sage Intacct to support the exchange of customer and financial data between the systems.
The integration provides configuration options for supported data types, including:
You can configure field mappings to identify the corresponding records and fields in each system. You can also enable or disable synchronization for supported data types.
The integration settings determine how data is mapped and synchronized. Review these settings before enabling synchronization.
Prerequisites
Before connecting Sage Intacct to Ordway, make sure that:
- You have an active Sage Intacct account with administrator permissions.
- You have the appropriate role and permissions in Ordway.
- You have the Sage Intacct company ID and the credentials for the Web Services user required for the connection.
Connect Sage Intacct to Ordway
To establish the connection, configure the Sage Intacct account details in Ordway.
- In Ordway, go to Setup > Integrations > Integration Settings.
- Locate Sage Intacct.
- Click CONNECT. The Connect to Sage Intacct dialog box is displayed.
-
Enter the following information.
Field Description Company ID The company ID for your Sage Intacct account. Find this ID under Company > General information in Sage Intacct. User ID The user ID associated with the Sage Intacct Web Services user. Password The password for the Sage Intacct Web Services user. - Select SAVE to establish the connection.
- After the connection is established, the Sage Intacct integration page is displayed. The CONNECT option changes to SETTINGS.
Configure Default Settings
Configure the default settings to determine how Ordway uses Sage Intacct entities and other integration options.
- Open the Intacct integration page.
- Locate Sage Intacct, then click SETTINGS. The Intacct - Integration Settings page is displayed.
- Click DEFAULT SETTINGS. The Setup Intacct page is displayed.
- Configure the settings described in the following table. Once logged in, the main Intacct integration page displays.
- Define the following General Settings:
| Field | Description |
|---|---|
| Default Entity ID | Selects the default Intacct entity used by the integration. |
| Use Transaction-Level Entity ID | Enables the use of an entity ID associated with individual transactions. |
| Transaction Entity ID Field | Specifies the field used to determine the entity ID for a transaction. This field is available when Use Transaction-Level Entity ID is enabled. |
| Target Entity for Customers | Specifies the Intacct entity where customer records are created or synchronized. |
| Target Entity for Products | Specifies the Intacct entity where product records are created or synchronized. |
| Target Entity for Chart of Accounts | Specifies the Intacct entity where chart of accounts records are created or synchronized. |
| Tax Item | Specifies the tax item used for the Intacct integration. |
| Enable Bulk API Calls | Enables bulk API calls for the Intacct integration. |
Configure Tax Settings
Configure the tax settings according to your invoice and credit synchronization requirements.
Tax Item
Select the product to use as the tax item when sending sales tax to Sage Intacct on invoices or credits.
The selected tax item should contain the general ledger accounts where sales tax is posted in Sage Intacct.
Invoice Tax Line Settings
Configure these settings after invoices are enabled and mapped.
Default Custom Field Values specifies the custom field values to use on invoice lines for sales tax. The available fields depend on the custom fields mapped under Invoice Line Field Mapping.
Credit Tax Line Settings
Configure these settings after credits are enabled and mapped.
Credit Tax Account specifies the debit account for sales tax lines on a credit transaction. The credit side of the credit transaction always uses the default Accounts Receivable account defined in Finance Setup.
- After configuring the applicable settings, select Save.
Configure Data Synchronization
After connecting Sage Intacct, configure the data types you want to synchronize.
- Open the Intacct - Integration Settings page.
- Locate the data type you want to configure.
- Enable its synchronization toggle.
- Select the corresponding mapping option, such as Map and Sync Customers or Map and Sync Products.
- Configure the record and field mappings for that data type.
- Click SAVE after completing the mappings. The "Intact Settings saved" confirmation message appears.
- Repeat these steps for each supported data type you want to configure.
Note: You can disable a data type using its synchronization toggle on the Intacct - Integration Settings page. When synchronization is disabled, data is no longer synchronized for that data type.
Map Customer Data
Use customer mapping to associate Ordway customer records and fields with the corresponding Sage Intacct records and fields.
Configure Customer Record Mapping
- Open the Intacct - Integration settings page.
- Click Map and Sync Customers. The Customer Data mapping page is displayed.
- Open the CUSTOMER RECORD MAPPING tab.
- For each Ordway Customer Name field, select the corresponding Intacct Object Name in the right column.
-
Use the Customer FILTER option to isolate specific Ordway Objects.
- Review the mappings.
Configure Customer Field Mapping
- Open the Customer Field Mapping tab, in the Customer Data mapping page.
- For each Ordway customer field name, select the corresponding Intacct Customer Field Name in the right column.
- To remove an existing mapping, select the X next to its dropdown.
- Select a replacement field when required.
- Select SAVE. The "Intacct - Integration Settings successfully updated" confirmation message appears.
Manage Customer Synchronization
Use the Sync Customers toggle to enable or disable customer synchronization. When synchronization is disabled, customer data is no longer synchronized between Ordway and Sage Intacct.
Map Chart of Accounts
Use the chart of accounts mapping settings to associate Ordway chart of accounts records, account types, and fields with their Sage Intacct counterparts.
- Open the Intacct - Integration Settings page.
- Click Map and Sync Chart of Accounts. The Chart of Account Data mapping page is displayed.
- Configure the mapping tabs described in the following sections.
Chart of Account Record Mapping
- Open the CHART OF ACCOUNT RECORD MAPPING tab.
- For each Ordway chart of accounts record, select the corresponding Intacct Account Name.
- Use the Chart of Accounts FILTER option to narrow the Ordway records displayed.
- To add another filter, select +ADD FILTER.
Chart of Account Type Mapping
- Open the CHART OF ACCOUNT TYPE MAPPING tab.
- For each Ordway Chart of Accounts Sub-Type, select the corresponding Intacct Account Type.
Chart of Account Field Mapping
- Open the CHART OF ACCOUNT FIELD MAPPING tab.
- For each Ordway Chart of Accounts field name, select the corresponding Intacct Account Field Name.
- To remove a mapping, select the X next to the dropdown.
- To add a field mapping, select +Add.
- Click SAVE.
Import or Export Chart of Accounts Mappings
Use the import and export options when you need to manage mappings for many chart of accounts records.
- Open the Chart of Account Data mapping page.
- Select the three-dot menu.
- Select the export or import mapping option, as appropriate.
- To prepare an import, use the exported Chart of Accounts Mappings file to review active chart of accounts records and existing mappings.
- Populate the Import Chart of Accounts Mappings template as required.
- Complete the import using the available interface.
Configure Journal Entry Mapping
Use journal entry mapping to configure which transaction types and journal entry fields are synchronized with Sage Intacct.
Understand Journal Entry Synchronization
When invoices, credits, payments, and refunds are synchronized with Sage Intacct, Sage Intacct automatically generates the corresponding journal entries.
Revenue schedule journal entries generated in Ordway are synchronized to Sage Intacct as manual journal entries. Customer information and additional details are included in the journal entry and its lines.
Important: When invoices are synchronized, the general ledger account selected on the credit side of the invoice posting transaction overrides the default account configured in Sage Intacct. Consider this behavior when configuring deferred revenue transactions.
Journal Entry data is collected through the following tabs:
Select Transaction Types
- Open the Intacct - Integration Settings page.
- Click Map and Sync Journal Entries. The Journal Entry Data mapping page is displayed.
- Open the TRANSACTION TYPES tab.
- Select all transaction types you want to synchronize or select individual transaction types.
- Review the selection.
Map Journal Entry Fields
- Open the JOURNAL ENTRY MAPPING tab.
- For each Ordway Journal Entry Field Name, select the corresponding Intacct Journal Entry Field Name.
- To remove a mapping, select the X next to the dropdown.
- To add a field mapping, select +Add.
Map Journal Entry Line Fields
- Open the Journal Entry Line Field Mapping tab.
- For each Ordway journal entry line field, select the corresponding Sage Intacct journal entry line field name.
- Click +Add to add field mappings as required.
- Select SAVE.
Manage Journal Entry Synchronization
Use the Sync Journal Entries toggle to enable or disable journal entry synchronization.
When synchronization is disabled, journal entry data is no longer synchronized between Ordway and Sage Intacct.
Map Product Data
Use product mapping to associate Ordway product records and fields with their Sage Intacct counterparts.
Configure Product Record Mapping
- Open the Intacct - Integration Settings page is displayed.
- Click Map and Sync Products. The Product Data page is displayed.
- Open the PRODUCT RECORD MAPPING tab.
- For each Ordway Product Name, select the corresponding Intacct Object Name.
- Use Products FILTER to narrow the Ordway records displayed.
Configure Product Field Mapping
- Open the PRODUCT FIELD MAPPING tab.
- For each Ordway product field, select the corresponding Sage Intacct product field name.
- Select +Add to add field mappings as required.
- Select SAVE.
Manage Product Synchronization
Use the Sync Products toggle to enable or disable product synchronization.
When synchronization is disabled, product data is no longer synchronized between Ordway and Sage Intacct.
Map Invoice Data
Use invoice mapping to configure the invoice and invoice line fields used by the Sage Intacct integration.
Configure Invoice Field Mapping
- Open the Intacct - Integration Settings page.
- Click Map and Sync Invoices. The Invoice Data page is displayed.
- Open the INVOICE FIELD MAPPING tab.
- For each Ordway Invoice Field Name, select the corresponding Intacct Invoice Field Name in the right column.
- Review the mappings and required fields.
- Enable Sync Invoices to send invoice data from Ordway to Intacct.
The available fields and mappings may depend on your integration configuration. Required fields are marked with an asterisk in the interface.
Configure Invoice Line Field Mapping
- Open the INVOICE LINE FIELD MAPPING tab.
- For each Ordway Invoice Line Field Name, select the corresponding Intacct Invoice Line Field Name.
- Review the mappings.
- Select +Add to add field mappings as required.
- Select SAVE.
Note: These are examples of mappings shown in the interface, not a requirement to use identical mappings for every account.
Map Credit Data
Use credit mapping to associate Ordway credit records and credit line fields with their corresponding Sage Intacct fields.
Configure Credit Field Mapping
- Open the Intacct - Integration Settings page is displayed.
- Click Map and Sync Credits. The Credit Data page is displayed.
- Open the CREDIT FIELD MAPPING tab.
- For each Ordway Credit Field Name, select the corresponding Intacct Credit Field Name in the right column.
- Review the required fields, which are marked with an asterisk.
Configure Credit Line Field Mapping
- Open the CREDIT LINE FIELD MAPPING tab.
- For each Ordway credit line field, select the corresponding Sage Intacct credit line field.
- Review the mappings.
- Select +Add to add field mappings as required.
- Click SAVE.
Map Payment Data
Use payment mapping to associate Ordway payment fields and payment methods with their corresponding Sage Intacct fields and payment methods.
Configure Payment Field Mapping
- Open the Intacct - Integration Settings page is displayed.
- Enable the Sync Payments toggle if payment synchronization is not already enabled.
- Click Map and Sync Payments. The Payment Data page is displayed.
- Open the PAYMENT FIELD MAPPING tab.
- For each Ordway Payment Field Name, select the corresponding Intacct Payment Field Name in the right column.
- Review the required fields, which are marked with an asterisk.
Configure Payment Method Mapping
- Open the PAYMENT METHOD MAPPING tab.
- For each Ordway Payment Method, select the corresponding Intacct Payment Method.
- Review the mappings and make changes as required.
- Click SAVE.
Note: These values illustrate one integration configuration. The available Sage Intacct payment methods may differ for your account.
Use the Sync Payments toggle to enable or disable payment synchronization. When disabled, payment data is no longer synchronized.
Integration Status
You can identify the integration status from the status indicator displayed on supported records and lists.
For additional details about interpreting integration status, refer to the Integration Status. Help Center article.
Disconnect the Integration
Disconnect the Sage Intacct integration when you no longer want Ordway to synchronize data with Sage Intacct.
- Open the main Intacct - Integration Settings page in Ordway.
- Go to the bottom of the page.
- Click Disconnect.
- Confirm the action if prompted.
Warning: Disconnecting the integration stops synchronization for the configured data types. Existing integration configurations are retained, so you can reconnect later without recreating them.
Comments
0 comments
Please sign in to leave a comment.