<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><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><p><strong>In this guide we will cover:</strong></p><p><strong>- What is the Sage Business Cloud Integration?</strong></p><p><strong>- Enabling Sage Business Cloud</strong></p><p><strong>- Connecting to Sage Business Cloud</strong></p><p><strong>- Tax Rates</strong></p><p><strong>- Accounts</strong></p><p><strong>- Customers</strong></p><p><strong>- Products</strong></p><p><strong>- Syncing to Sage Business Cloud</strong></p><p><br></p><p><br></p><p><strong><span style="font-size: 14pt;">What is the Sage Business Cloud Integration?</span></strong></p><p>The Sage Business Cloud integration can be used to import tax rates, accounts, customers and products into Halo, and sync customers, products and invoices to Sage when updated in Halo.</p><p><br></p><p><strong><span style="font-size: 14pt;">Enabling Sage Business Cloud</span></strong></p><p>In Configuration > Integrations > Accounts and Payments, hover over the module to enable the integration by clicking the "plus" (+) icon that appears.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImYyNzEwNWNiLWM1ODItNDQ0ZC1iMjI2LTY2NmQxZWM1NmRlYSJ9.kP-KdioCdqIx-LJ_pCbrPg8qPu4JXnzwnnRAbYBtRko" class="fr-fic fr-fil fr-dib" width="93" height="132"></p><p><strong><span style="font-size: 10pt;">Fig 1. Enabling the integration.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Connecting to Sage Business Cloud</span></strong></p><p>Clicking into the module will take you to this screen. Click into "Sage Business Cloud Tenants" to create your tenant. This is a multi-tenancy integration, so multiple can be made and shown in a list view format. Create a new tenant using the 'new' button in the top right. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjJlZjNhNjRhLWE3N2EtNGYzMi05Njc0LTFiOWQ1ZDYyNDIwYSJ9.cFSpYO2e308TaXwyuyzRJ_m0EgtM1FlWXPn3Sr5HfOw" class="fr-fic fr-fil fr-dib" width="1216" style="width: 1218px; height: 372.124px;" height="372"></p><p><strong><span style="font-size: 10pt;">Fig 2. Entering the tenancy area.</span></strong></p><p><br></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><strong>Choosing an Authentication Type</strong></span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;">You will have an option to choose an authentication type for the integration. </span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><strong><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM0OWQ3YTQzLTUwNGQtNGJlOC1hMjM5LTk2YTE5YTZkZGQxNiJ9.5sMS6OIfa2Q_aNvvFRvBk-sauGhERIqXjD6XQ2g3rAs" class="fr-fic fr-fil fr-dib" width="306" style="width: 308px; height: 129.486px;" height="129"></strong><br></span></p><p style="margin-left: 20px;"><span style="font-size: 10pt;"><strong>Fig 3. Authentication Type</strong></span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><strong><br></strong></span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><strong>Use the Halo app (recommended)</strong> - This is the recommended option and should be selected by all hosted customers. When this option is selected you will need to authenticate the integration by logging into your Sage account. </span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><br></span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><strong>Use a custom developer app </strong>- This option should only be selected if you are unable to authenticate successfully using the Halo app method. As this option does not support webhooks. <span style="font-size: 11pt;" data-pasted="true">On-Prem</span> customers that do not allow their Halo instance to communicate with our API will need to use this authentication method. When this option is selected you will need to authenticate the integration using a client ID and secret. </span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><br></span></p><p style="margin-left: 20px;"><span style="font-size: 11pt;"><strong><em>Note: The 'Halo app' method will be selected by default. </em></strong></span></p><p style="margin-left: 20px;"><br></p><p><br></p><p>At this point, only the "Details" tab is available until you have connected. Here you can name your tenant and save. Edit again to connect to Sage Business Cloud by clicking the "Connect Now" button underneath.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImMxNWRlY2VmLTdkMmItNDg2Yy04NDg4LTJmYTQyNTEzOTkxNiJ9.7IR-zsuBhXayYQHCUN5L3DgoAFGW33WZvVZIj1phQlM" class="fr-fic fr-fil fr-dib" width="1215" style="width: 1217px; height: 476.716px;" height="477"></p><p><strong><span style="font-size: 10pt;">Fig 4. Connect Now button on a Sage Business Cloud tenant.</span></strong></p><p><br></p><p>You will then be redirected to the Sage login screen and upon logging in, you will be redirected back to Halo. The button will then disappear and instead show a message that the connection was successful. The remaining tabs on the screen can now be clicked on and configured.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjNmNjlkN2NkLWM3MjEtNGRiZS05MGRkLTY5YmEzMzVmNWM3NiJ9.ofTUy8Zz-agm_yVFzn4DOG-BBsHQPdqH9Nt3qbRt8xI" class="fr-fic fr-fil fr-dib" width="1218" style="width: 1220px; height: 354.366px;" height="354"><strong><span style="font-size: 10pt;">Fig 5. Successful connection message.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Tax Rates</span></strong></p><p>The first configurable tab is "Tax Rates". This is where you can import your tax rates from Sage into Halo, and map them to your existing ones. Any tax rate that is not mapped to a Sage tax rate will be removed upon import.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjBlZDgzYzliLTE2NzMtNDM4ZC1iZTkyLTQ2N2UwMmM2ZDU1NSJ9.FtnT76N9-he4HuQFFgZntBy2eZjplD13zuzDD1r5S40" class="fr-fic fr-fil fr-dib" width="1216" style="width: 1218px; height: 326.277px;" height="326"></p><p><strong><span style="font-size: 10pt;">Fig 6. Tax Rates tab.</span></strong></p><p><br></p><p>Upon clicking the "Import Tax Rates" button, the following popup will show after completion.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjZiOGE0YjEyLTUwODgtNDFmOC1hNDFiLWM5ZGMyYzEzOTcxNiJ9.HaRn1Y-tqbeCWyH31P1R6PWtxEpTlH5veunDh5CaWD4" class="fr-fic fr-fil fr-dib" width="220" height="138"></p><p><strong><span style="font-size: 10pt;">Fig 7. Popup showing that tax rates have imported.</span></strong></p><p><br></p><p>Clicking into the "Edit Tax Rates" button will bring up the list of tax rates.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijk5NjQzMTljLTFiYmQtNDFmOS1hOTZjLWQ5MWNkNjJlMDYwZiJ9.nWk_YqUSuYuEuVenkCJoDbWwkOWJuvLr2kxtX7zcs7U" class="fr-fic fr-fil fr-dib" width="893" height="459"></p><p><strong><span style="font-size: 10pt;">Fig 8. List of imported tax rates.</span></strong></p><p><br></p><p>Clicking into one will now show the "Sage Business Cloud Tax Rate" and "Sage Business Account" fields showing which tenant and tax rate it is linked to.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY3MGM2MzlmLTA5NDUtNGExYi1hMDFiLTc5ZTViNDVlMTA4ZCJ9.05pBXfMlqIyWHub6R2tPzqErU9zj2nudNtZAB1CySX0" class="fr-fic fr-fil fr-dib" width="319" height="628"></p><p><strong><span style="font-size: 10pt;">Fig 9. Sage Business Cloud fields on an imported tax rate.</span></strong></p><p data-pasted="true"><br></p><p>You can import tax rates from Sage Business Cloud automatically on a daily basis, this will update any existing rates and create new rates. This is enabled using the setting "Import tax rates daily" under the "Tax Rates" 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. </p><p><br></p><p><strong><span style="font-size: 14pt;">Accounts</span></strong></p><p>In the "Accounts" tab, you can then import accounts codes.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImVhNjNlNjJjLTRiMzYtNGYxZi04MGMwLWU2ZTQ5NTczZjUyYyJ9.MBkAQWlo-xHLbPyMJOXHVSv61tLXYiY5UvQ_gO11JZw" class="fr-fic fr-fil fr-dib" width="1221" style="width: 1223px; height: 258.564px;" height="259"></p><p><strong><span style="font-size: 10pt;">Fig 10. Accounts tab.</span></strong></p><p><br></p><p>Clicking the "Import Accounts Codes" button will import and show the popup, and the codes can be then viewed by clicking the "View Accounts" button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjY4NzBlYTk4LTFiOGItNDAyNy1hYTI3LWE5MjIzNjIwZDVlYyJ9.H1xjuvsnWhK6gykAKcZbNocwZ8dc-ci89iBRNEkw_yk" class="fr-fic fr-fil fr-dib" width="220" height="124"></p><p><strong><span style="font-size: 10pt;">Fig 11. Imported accounts popup.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Customers</span></strong></p><p>The "Customers" tab can be used to map and import customers. After mapping, click the "Import Customers" button to bring up the import screen. If customers have the exact same name, the matching can be done automatically as well.</p><p><br></p><p>Customer's "Invoice Address" in Sage will be imported as the site address.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImUwYjVlMzUzLTJiMjUtNGYxYy05ZDk4LWZkNDhkMmQ0M2Q5NCJ9.nFDmME_wxlmgiraNUi8ehhcj6hXbgorirNIgN-shjjE" class="fr-fic fr-fil fr-dib" width="1223" style="width: 1225px; height: 557.448px;" height="557"></p><p><strong><span style="font-size: 10pt;">Fig 12. Customers tab.</span></strong></p><p><br></p><p>Mappings can be added by clicking the "Add" button, and the following popup will show to map customers.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjEyMmVlNDM5LWQ4ZDItNGExMi1hM2NiLWI4Yjg2YzAyMDI0YyJ9.c_6npjnkbIplSxdNcsshLvnjZYERCB2p7LU6T6vY-tM" class="fr-fic fr-fil fr-dib" width="711" height="340"></p><p><strong><span style="font-size: 10pt;">Fig 13. Customer Mappings popup.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Products</span></strong></p><p>The "Products" tab maps Sage product categories to Halo product groups, and sets the default product group if none is mapped. After mapping the groups, you can use the "Import Products" and "Import Services" buttons at the bottom to bring up their relative import screens.</p><p><br></p><p id="isPasted">These mappings are needed to ensure products are created in Halo correctly, and both products and services are imported into Halo as products/items.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjM2ZWViOWM0LTZlNDMtNGU1OC05YzkzLWQ1OWNkYzc0ZjlkZCJ9.VAdAnC93usUQa_O4TzW8oFN3gdAkEE0vAV_GAvpTS9c" class="fr-fic fr-fil fr-dib" width="1212" style="width: 1214px; height: 472.62px;" height="473"></p><p><strong><span style="font-size: 10pt;">Fig 14. Products tab.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Syncing to Sage Business Cloud</span></strong></p><p>This tab is how syncing is configured from Halo to Sage. </p><p><br></p><p><strong><em>Note: Ensure the module is enabled as per the start of this guide.</em></strong></p><p><br></p><p>Here the entities to sync are selected from a multi-select field containing Customers, Invoices, and/or Products, and these will be synced when created or updated in Halo. You can then select the default Sage Business Cloud Item Code for if an invoice line does not have a code associated with it.</p><p><br></p><p><em><strong>Note: Updates to customers or products in Sage will not sync back to Halo. Updates to entities can only be imported manually.</strong></em></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjcxYjhiOTVlLWYxYmEtNGVhZS1hY2VkLTllNzYzM2E5OWFjNyJ9.f54kNOjlNQ0irIyLS_DpiGMVlOPz2PLG8jdjPkGcwzo" class="fr-fic fr-fil fr-dib" width="1215" style="width: 1217px; height: 513.184px;" height="513"></p><p><strong><span style="font-size: 10pt;">Fig 15. Syncing to Sage Business Cloud tab.</span></strong></p><p><br></p><p><strong><em>Note: Syncing entities to Sage Business Cloud uses webhooks therefore this functionality will not be supported if you are using the 'custom developer app' authentication method.</em></strong></p><p><br></p><p>Once this is configured, you can also now set a default tenant back on the main module page.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImI4NTY0NGFlLTNiYmQtNDc3Mi1iZWY3LTdhNjk0ODRhNzMyZCJ9.AwuRv4uKmFQo3arWe29avM71Hv3jwK8xf6VEX4bO6bI" class="fr-fic fr-fil fr-dib" width="1217" style="width: 1219px; height: 372.43px;" height="372"></p><p><strong><span style="font-size: 10pt;">Fig 16. Setting a Default Tenant for new Customers, Products and Suppliers.</span></strong></p><p><br></p>
