Browse Guides

Exact Online Integration
Reading mode
Copy Link
Link Copied!
Print
Feedback
This guide has multiple versions available:
<div><div><div><div><style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><div><div><div><div><div><div><style> p { margin: 0; } span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left: 0; padding-left: 5px; } blockquote blockquote { border-color: #00bcd4; color: #00bcd4; } blockquote blockquote blockquote { border-color: #43a047; color: #43a047; } table.grid { border-collapse: collapse; } table.grid td, table.grid th { border: 1px solid #ddd; } .fr-fic.fr-dib { display: block; margin: 5px auto; } .fr-fic.fr-dib.fr-fir { text-align: right; margin: 5px 0 5px auto; } .fr-fic.fr-dib.fr-fil { text-align: left; margin: 5px auto 5px 0; } .fr-fic.fr-dii { float: none; margin: 5px auto; } .fr-fic.fr-dii.fr-fil { float: left; margin: 5px auto; } .fr-fic.fr-dii.fr-fir { float: right; margin: 5px auto; } img.fr-dib.fr-fir { margin-right: 0; text-align: right; } img.fr-dib.fr-fil { margin-left: 0; text-align: left; } img.fr-dib { margin: 5px auto; display: block; float: none; } img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC; } img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc; } img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box; } </style><div><div id="isPasted"><p><span style="font-size: 11pt;"><strong>In this guide we will cover:</strong></span></p><p><span style="font-size: 11pt;"><strong>- Connecting Exact Online</strong></span></p><p data-pasted="true"><span style="font-size: 11pt;"><strong>- Importing and Syncing Entities from Exact Online</strong></span></p><p><span style="font-size: 11pt;"><strong>- Connect Multiple Exact Companies</strong></span></p><p><span style="font-size: 11pt;"><strong>- Set Invoice numbers to be the same across Halo and Exact Online</strong></span></p><p><strong><span style="font-size: 11pt;">- Common Errors</span></strong></p><p><br></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">The Exact Online integration uses a one way sync to push data from Exact online into Halo, allowing you to import data for customers, items and invoices in Exact.</span></p><p><br></p></div><p><strong><span style="font-size: 14pt;">Connecting Exact Online</span></strong></p><p><span style="font-size: 11pt;">First, ensure you have the exact online module enabled, this is found under Configuration &gt; Integrations. Enabled by selecting the + icon on the module.&nbsp;</span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQ3ODJlMjUwLTViZGUtNDg3NC1iNzU3LTBlNmNhMmJkY2U5NCJ9.L24yvXZ7_RkMWgNx45HaiuelaCpuNcKKGISiv1_H210" class="fr-fic fr-fil fr-dib"></p><p><strong><span style="font-size: 10pt;">Fig 1. Enable module</span></strong></p><p><br></p><p><span style="font-size: 11pt;">Now head into your App Centre within Exact Online (you will need to be logged in). Select &#39;manage my apps&#39; and register a new app. Note that the person registering the app must have a partner role in Exact, otherwise they will not have appropriate permissions to create the application.</span></p><p><span style="font-size: 11pt;">&nbsp;</span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImIyMjc5ZDIxLTM5Y2QtNGRjMy04MWI3LWRkYzlkYzk4ZDEzNiJ9.RLt0I-LEbpGuzjq8eE6yOxef9quULpqpvaAhLGISjP8" class="fr-fic fr-fil fr-dib"></p><p><strong><span style="font-size: 10pt;">Fig 2. App centre in Exact Online</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">When registering a new app you will need to enter a name for the app, call this something sensible like &#39;Halo connection&#39;, you will also be prompted for a redirect URI. The redirect URI used will differ depending on the version of Halo you are using.&nbsp;</span></p><p><br></p><p><span style="font-size: 11pt;">On versions prior to v2.200 the following redirect URI will need to be used:</span></p><ul><li><a data-fr-linked="true" href="https://joelydavid.psa.haloqa.co.uk" id="isPasted"><span style="font-size: 11pt; color: rgb(0, 0, 0);">https://</span></a><span style="font-size: 11pt; color: rgb(0, 0, 0);"><a href="//auth.halopsa.com/externalauth">auth.halopsa.com/externalauth</a>&nbsp;</span></li></ul><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">On versions v2.200+ you the following redirect URI will need to be used:</span></p><ul><li id="isPasted"><a data-fr-linked="true" href="https://joelydavid.psa.haloqa.co.uk/authcallback"><span style="font-size: 11pt;">https://YOURHALODOMAIN/authcallback</span></a></li></ul><p><span style="font-size: 11pt;">But the exact redirect URI you need can be found on the setup page for the integration in Halo. To get the URI head back into Halo, open the Exact Online configuration &gt; Exact Online companies &gt; New. On this page you will see the redirect URI needed (see <strong>Fig 3</strong>).</span></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjI3MzQ2NTcyLTBmMWQtNGY0My1hNjc3LWE5NDg2N2UxZWZkZiJ9.qbckHuZC5IGPHtaNEZCX-xOEZCg8OpqRWVjdkaAEfV4" class="fr-fic fr-fil fr-dib" style="width: 1187px; height: 591.131px;" width="1185" height="591"></p><p><strong><span style="font-size: 10pt;">Fig 3. Redirect URI</span></strong></p><p><br></p><p id="isPasted"><strong><em><span style="font-size: 11pt;">Note: If you have disconnected to the integration and are reconnecting, if your Halo instance is on v2.200+ you will need to use the new redirect URI (HTTPS://YOURHALODOMAIN/authcallback).</span></em></strong></p><p><br></p><p><span style="font-size: 11pt;">Copy and paste this into the app registration in Exact, this should look as shown in <strong>Fig 4</strong>.</span></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImEwNjZjMWM1LTMzNzUtNDY3YS04YmI4LTg5OWE3ODcwMGUzOCJ9.Wt13jMpzgJIwSw2sjaAIEjkJVRmArPpG32xPKLVkZdk" class="fr-fic fr-fil fr-dib" style="width: 415px;"></p><p><strong><span style="font-size: 10pt;">Fig 4. Exact Online app registration</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Hit register and you will be given a Client ID and secret. Copy and Paste these fields from Exact into Halo (see <strong>Fig 5 and 6</strong>). If you have multiple Exact companies you would like to connect make a note of this client ID and secret as you will need them later on.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY1MjY3ZDgxLTdkZTUtNDkxNS05N2EyLTI5ZmJkNjFmYjI2MyJ9.BmUXq2nFt2quflTwyT58A-ptGaPYssarqvvU6wAaILI" class="fr-fic fr-fil fr-dib" style="width: 659px;"></p><p><strong><span style="font-size: 10pt;">Fig 5. App details in Exact</span></strong></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImZkZDZkYWY4LTYxNGYtNGNkMi04NjVjLWQzNjJhMjMwOWIxOCJ9.dRqLLOwkkczuEHSRUlHWvvmLIL6LwEDodAque8ae9Xc" class="fr-fic fr-fil fr-dib" style="width: 1321px;"></p><p><strong><span style="font-size: 10pt;">Fig 6. App details in Halo</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Now select your location and hit &#39;Connect Now&#39;.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><em><strong>Note: You can only use the generated client ID and secret for one Halo instance, if you have multiple Halo instance you need to connect to Exact, you will need to register an additional app (one app registration per instance).&nbsp;<br></strong></em></span></p><p><span style="font-size: 11pt;"><br></span></p><p><strong><span style="font-size: 14pt;">Importing and Syncing Entities from Exact Online</span></strong></p><p><span style="font-size: 11pt;">Now you are connected the other tabs of the integration configuration page in Halo will be available.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Under the &#39;Company&#39; tab choose which Exact company you would like to import and sync details from.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><strong><span style="font-size: 12pt;">Tax Rates<br></span></strong></p><p><span style="font-size: 11pt;">Under the &#39;Tax Rates&#39; tab you can import the tax rates you have in Exact online. This will create each tax rate in your Halo, under Configuration &gt; Billing &gt; Tax &gt; Tax Rates. When importing a tax rate for the first time, Halo Service Desk will check to see if a tax rate already exists with the same name or the same Exact Online code. If found, the existing tax rate will be updated. It is important to note importing tax rates from Exact Online will remove any tax rates not in use by an Exact Online Company from Halo Service Desk. If you create any new tax rates in your Halo, these will need to be mapped to a tax rate from Exact Online in order to sync over.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">To map an existing tax rate to one in Exact edit the tax rate settings and choose the Exact company and the associated tax rate. Once set, if this tax rate is used and the invoice synced to Exact the tax settings from the Exact tax rate will be used.</span></p><p><span style="font-size: 11pt;">&nbsp;</span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjMxYzg4OTZmLWJkOTYtNDk5Ni1hMTUwLTkyZDNmMGNmNDQ1MCJ9.jJtDYpF_kW3BlD2guaK5v_P8Nmu_-uX8S_uJyr5FyCQ" class="fr-fic fr-fil fr-dib" style="width: 804px;"></p><p><strong><span style="font-size: 10pt;">Fig 7. Mapping Halo tax rate to Exact tax rate</span></strong></p><p data-pasted="true"><br></p><p><span style="font-size: 11pt;">You can import tax rates from Exact automatically on a daily basis, this will update any existing rates and create new rates. This is enabled using the setting &quot;Import tax rates daily&quot; under the &quot;Tax Rates&quot; tab. When enabled, the latest tax rates will be automatically imported during the daily task scheduler run. This helps to keep your tax rates up to date without having to re-import manually.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 12pt;"><strong>Account codes</strong></span></p><p><span style="font-size: 11pt;">Under the &#39;Accounts&#39; tab you can import your accounts codes from Exact. When importing an account for the first time, Halo will check to see if an account already exists with the same name or code. If found, the existing account will be updated. Once imported you can set these to be the default accounts for income and expense accounts on product groups.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 12pt;"><strong>Customers</strong></span></p><p><span style="font-size: 11pt;">Under the &#39;Customers&#39; tab you can import and/or map customers from Exact. If your customers already exist in Halo, you will need to complete the mapping table to map the Exact customer to the Halo customer. To do this, edit the page, select &#39;add&#39; on the table, choose the Exact customer and Halo customer to map together.&nbsp;</span></p><p><span style="font-size: 11pt;">&nbsp;</span><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQ5NWNlZTY0LTEzMmUtNGM5Yy1iNTAxLWVjNDkzNDZjNTU2ZCJ9.xaXdXibKJuUmEIIQFLG9xQIEWHaKKMxna-HD1pVAIy4" class="fr-fic fr-fil fr-dib" style="width: 584px;"></p><p><strong><span style="font-size: 10pt;">Fig 8. Customer mapping</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">When importing customers from Exact Halo will check to see if a customer already exists with the same name&nbsp;</span><span style="color: rgb(0, 0, 0); font-size: 11pt;">or accounts code, if a match is found this existing customer will be updated rather than a new one created. It is advised to complete the mappings table even if your customers have matching names/account codes as they must be identical to match and completing the mappings prevents any potential mis-matches.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="color: rgb(0, 0, 0); font-size: 11pt;">You can also choose a top level for these customers to be under, using the &#39;Top level for customers&#39; setting.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="color: rgb(0, 0, 0); font-size: 11pt;">Once the mappings are complete you can import your customers, when importing a preview screen will appear, showing all your customers in Exact. Ensure they are all selected and hit &#39;start&#39;. Note that if a customer is imported without a mapping, and they do not have a name/accounts code that matches an existing customer, then a new customer will be created in Halo and the mapping will be automatically added to the table.</span></p><p><span style="color: rgb(0, 0, 0); font-size: 11pt;">&nbsp;</span></p><p><span style="color: rgb(0, 0, 0);"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjdlOGFiNDY4LTRlNTAtNDg2MS1iNjhhLWViNGY3OGY3YzMwOSJ9.1wir4CFX-3isrU7sw1xGJDZtygaD7ozYQxBZ9-igT70" class="fr-fic fr-fil fr-dib" style="width: 1061px;"></span></p><p><strong><span style="font-size: 10pt;">Fig 9. Customer Import</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">If customers are created from the import, a new site for the customer will be created using the address in Exact as the site address. If mapping an Exact customer to a Halo customer then the Halo site&rsquo;s main address will be replaced with the customer&rsquo;s address from Exact online. If the address of the main site in Halo is different to the customer address in Exact, you will need to create a new site under this customer in Halo and set this as the main site for the customer. This site will then take the address of the Exact customer. This is because the main site of the customer will always populate with the Exact customer address, so you need the current main site to have a different address to the Exact customer address, the main site will need to be replaced with a site that can have the Exact customer address.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">If you have a customer that exists in Halo, but does not yet exist in Exact you can create them in Exact from Halo. To do this open up the customer profile in Halo, go to the billing tab set the &#39;Exact Online company&#39; field. You will also need to set the &#39;customer ID for accounting integration&#39; field, this needs to be a unique numerical value for the customer. The customer will be created in Exact upon saving.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFlODQ0NGYxLTUxODUtNGFkYi1hM2I5LTBiOThlMDRmMmY5NSJ9.CGAFKhc0cA7jNH3KzwlDNrgs0LPKIwWV_CE6Gog0Fwc" class="fr-fic fr-fil fr-dib" style="width: 1087px;"></p><p><strong><span style="font-size: 10pt;">Fig 10. Exact Online company against customer</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><strong>Produc</strong><strong>ts&nbsp;</strong></span></p><p><span style="font-size: 11pt;">Under the &#39;Products&#39; tab you can import items from Exact and map the item group to a product group in Halo. To create the item group mappings, edit the page and add a mapping to the table. When creating the mapping select an item group from Exact and the corresponding product group in Halo. This will ensure that when importing items from Exact they are imported under the selected product group in Halo.</span></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc0ZDU3MTRjLTk3ZDEtNDZhZS05Mzc1LTEwOGViOTNjZDkwMCJ9.e27CLJMF2JXb5uPUIKbpDieC7GX6mBgPxCVaIXjq_6U" class="fr-fic fr-fil fr-dib" style="width: 639px;"></p><p><strong><span style="font-size: 10pt;">Fig 11. Product group mappings</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">You will also need to set a default product group for imported items. Any imported items that have an item group that is not mapped to a Halo product group, will be created under this default product group.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjEwZTEyNDFkLWY5NDEtNGQzNC1hMjFlLWM4ZjRlYzNhZjQ2NyJ9.7EdtDnUV6UA4kng5rqg-XZmWrf1F-VF0q6G5T8tJcss" class="fr-fic fr-fil fr-dib" style="width: 1140px;"></p><p><strong><span style="font-size: 10pt;">Fig 12. Default product group field</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Once you have completed your mappings you can hit &#39;Import products&#39; this will bring up an import preview screen. Ensure all your products are selected and hit &#39;start&#39;.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Products imported from Exact will automatically be assigned to the Exact online company they were imported from. If the item in Exact has a revenue (income) and costs (expense) account set against it, this will automatically populate the income and expense account on the product in Halo.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">If you have a product that exists in Halo, but does not yet exist in Exact you can create them in Exact from Halo. To do this head to Products &gt; select the product &gt; billing tab, in here you need to set the &#39;Exact Online&#39; company and the &#39;product ID for accounting integration&#39;. &nbsp;The product ID must be unique otherwise it will not sync correctly, you can make use of the &#39;generate&#39; button here. This will check the existing product IDs in the system and generate a unique one for you. Once save the product will create in Exact.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="color: rgb(0, 0, 0); font-family: sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImJjZGM0YmJlLTFiMGMtNDYyZi04MGI3LTVmZmI2MDdjMWQ2ZiJ9.N1ADCrTINlb24rK2pPFayt3yIHgBJet5L6LhZizn49c" class="fr-fic fr-fil fr-dib" style="width: 645px;"></span></p><p><strong><span style="font-size: 10pt;">Fig 13. Product fields required for Exact sync</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 12pt;"><strong>Entities to sync</strong></span></p><p><span style="font-size: 11pt;">Under the &#39;Syncing to Exact Online&#39; tab, you can set which entities you would like to sync. You can choose from customers, products and invoices.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjRjN2E0ZWRkLWZhY2UtNDc4Mi1hNjI1LTVjMTQzYzA3NTM0NiJ9.2ntEvcEShlqIrU9MDXks61DDSHvGDykhgQ5CQFiBvxw" class="fr-fic fr-fil fr-dib" style="width: 1011px;"></p><p><strong><span style="font-size: 10pt;">Fig 14. Syncing to Exact Online tab</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p id="isPasted"><span style="font-size: 11pt;">You can also enable messages for each successful sync, this is useful to confirm the sync has taken place.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 12pt;"><strong>Outbound requests</strong></span></p><p><span style="font-size: 11pt;">The &#39;Outbound&#39; requests tab allows you to see all the outgoing requests to from halo to Exact Online. A sync will take place each time a customer/product/invoice is created or edited in Halo.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Once this setup is complete, save the page. Head back to Configuration &gt; Integrations &gt; Exact Online, and set the &#39;Settings&#39; for the integration. You can set the default tenant and invoice status here.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImU5MGU1ZjMzLThkODItNGNlOS05MzQyLTcwOTU2ZjRjYzA4NSJ9.lFofqG26zfmkqzfyMJezNrSNzTtOX_lVwmOtLth-sEs" class="fr-fic fr-fil fr-dib" width="979" style="width: 981px; height: 436.199px;" height="436"></p><p><strong><span style="font-size: 10pt;">Fig 15. Additional Settings</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><strong>Default tenant for new customers, products and suppliers:</strong> Here, enter the Exact tenant that these entities will be created in by default. This ensures any new customers/products/suppliers that are created in Halo are assigned to this Exact Online company, but this can still be changed to another company manually on the customers/products/suppliers.&nbsp;</span></p><p id="isPasted"><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><strong>Default status for new Invoices:</strong> Here, you can choose the status that invoices will be created with in Exact when synced from Halo into Exact. This is used to control if invoices are automatically processed when synced to Exact or not.&nbsp;</span></p><p><span style="font-size: 11pt;"><br></span></p><p><strong><span style="font-size: 14pt;">Connect Multiple Exact Companies</span></strong></p><p><span style="font-size: 11pt;">If you have multiple companies within your Exact online account that you would like to sync you will need to head to Configuration &gt; Integrations &gt; Exact Online &gt; Exact Online companies &gt; New, and create a new company connection.</span></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgyZDkwMWM1LTQ1MWItNDZkYi1iODBlLTZkMTE2ZjIyMDkzNCJ9.DuhyB01nab1he8e1c3-jjKgDwiavxxkny5OPoPz7sbc" class="fr-fic fr-fil fr-dib" style="width: 1317px;"></p><p><strong><span style="font-size: 10pt;">Fig 16. New Exact Online Connection</span></strong></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Once you have opened a new connection you can connect to your Exact account using the client ID and secret generated earlier. Once connected, ensure you select the different company you would like to sync with (in the &quot;Company&quot; tab) then repeat the previous steps in this guide to complete the setup for this company. This process is repeated for each company you have in Exact, just ensure for each connection you are selecting the correct Exact company.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><strong><span style="font-size: 14pt;">Set Invoice numbers to be the same across Halo and Exact</span></strong></p><p><span style="font-size: 11pt;">For Invoice Numbers to be set correctly (so the invoice has the same number in Halo and Exact) you must select the below the &quot;Assign - Invoice Number&quot; option in Exact Online to &quot;Entry&quot;.&nbsp;</span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImE5YzczY2MwLThkMDAtNGIwNC1iYjUwLTYzZGFjYTczM2I1ZSJ9.4t53rYGBgjhhhvlG6zla4BinyGBkdqA6efm4Hzi-wa8" class="fr-fic fr-fil fr-dib" width="949" style="width: 951px; height: 322.817px;" height="323"></p><p><strong>Fig 17. Assign- Invoice Number option in Exact</strong></p><p><br></p><p><span style="font-size: 11pt;">The Halo to Exact connection is 1-1 so only one Halo entity can be linked to one exact entity (one Halo customer to one Exact customer for example). If a Halo customer is linked to multiple exact customers in different companies the Halo customer will be updated with data from these Exact customers in sequence so only the data from the Exact customer that was last synced will remain on the Halo customer. For this reason ensure mappings have a 1-1 relationship.</span></p><p><span style="font-size: 11pt;"><br></span></p><p><strong><span style="font-size: 14pt;">Common Errors</span></strong></p><table style="width: 100%;" class="grid"><tbody><tr><td style="width: 50.0000%;"><strong><span style="font-size: 12pt;">Resolution</span></strong></td><td style="width: 50.0000%;"><strong><span style="font-size: 12pt;">Error Message<br></span></strong></td></tr><tr><td style="width: 50.0000%;"><p id="isPasted"><span style="font-size: 11pt;">This indicates the item on the invoice cannot be synced to Exact. Check item has the Exact company set and has a product ID. Also check the product ID against the product is unique.</span></p><span style="font-size: 12pt;"><strong><br></strong></span></td><td style="width: 50.0000%;"><span style="font-size: 12pt;"><strong><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImRjMDZiODdjLTRmOTItNDYxOS1hNDE5LTMyMjhiODg2MjUyOCJ9.7kpx15BHW-ERPU7BNIegTG1BXGQV2OcHpdHZE3_pUxc" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; max-width: none !important; width: 836px;" id="isPasted" class="fr-fil fr-dib"><br><br></strong></span></td></tr><tr><td><span style="font-size: 11pt;">This indicates the authorisation token for the integration has expired. This can be resolved by disconnecting and reconnecting to Exact on the Integration details page in Halo.&nbsp;<br></span></td><td><span style="font-size: 12pt;"><strong><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQyZTc2NWY4LTk0NWYtNDQ0Mi05Y2ViLTE2MWJlZTUwODU3MSJ9.-ZDXs0EMImdbWruPxTjnk7oCoM1Qpau_Gl10FhIiT40" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; width: 839px; max-width: none !important;" id="isPasted" class="fr-fil fr-dib"></strong></span></td></tr></tbody></table><p><span style="font-size: 12pt;"><strong><br></strong></span></p></div></div></div></div></div></div></div></div></div></div></div>
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.