Sage 50 UK Integration

In this guide we will cover: – What is the Sage 50 UK Integration? – Downloading the Application – Setting up the Integration What is the Sage 50 UK Integration? The Sage 50 integration allows UK-based Sage accounts to connect to Halo and sync Customers, Products and Invoices.  Downloading the Application The Sage 50 UK […]

Halo Accounts Integrator Setup

In this guide we will cover: – Setting up the API Application The Halo Accounts Integrator is required to integrate with the following Accounting Software/Tools: Sage 50 UK – The Account Integrator has been updated to be compatible with Sage UK v32 (2026). Sage 50 Canada QuickBooks Desktop (All regions) The Halo Accounts Integrator must […]

Invoicing Explained

In this article we will cover: – Enabling Billing from Halo – Adding a Recurring Invoice – Contacts and Automation – Creating Invoices manually – Deleting and Editing invoices  – Third Party Accounts Systems This guide assumes you have configured the required billing entities already (e.g. for the case of labour billing, you have set […]

Calculating Asset Quantities from SQL Query

Example below select count(did) as [Quantity] from device left join  xtype on ttypenum = dtype where dsite in (select ssitenum from site where sarea= (select ihaarea from invoiceheader where ihid=$INVOICEID))and (tdesc like '%Workstation%' OR tdesc like '%IPSec Tunnel%') and tdesc NOT like '%Switch%'

Meter Billing

In this guide we will cover: – What is Meter billing and when is it used – How to configure an invoice to bill using meter readings  – Logging and Viewing Meter readings – Importing invoice lines as meters  What is Meter Billing and when is it used? Meter Billing in Halo allows you to […]

Contract/Agreement Rules

In this guide we will cover: – Creating Contract Rules Admin Guides: Agreements (Contracts) Related Guides: Creating an Agreement/Recurring Invoice for a customer Note: In Halo the terms 'contract' and 'agreement' are used interchangeably.  Contract rules are used to automatically assign a new user to an existing contract based on set criteria. Making new user […]

Creation Periods in Recurring Invoices

In this guide we will cover: – What is a Recurring Invoice? – Creation Periods in Recurring Invoices – Example: Using Creation Period Variables on a Recurring Invoice – Advanced Example: Invoicing Licences in Arrears but Support in Advance Admin Guides: Recurring Invoices Creation Periods allow you to create Recurring Invoices for different type of […]

Managing a Recurring Invoice’s Lines Quantity, Price and Cost for Subscriptions

In this guide we will cover: – How to have the quantity of a recurring invoice calculate based on subscription count  – Update Price/cost of items on recurring invoices from within the product How to have the quantity of a recurring invoice calculate based on subscription count  In order to manage recurring invoice lines linked […]

Custom SQL Query for Licence/Subscription Count on Recurring Invoice Lines

In this guide we will cover: – How to use a custom SQL query to calculate the Licence/Subscription Count on Recurring Invoice Lines  Custom SQL queries can be used to calculate the quantity of invoice lines based on information from your database. This provides many more options and flexibility to how your invoice line quantities […]

Set which Agents can adjust the Billing Time and Recalculation of Billing on Tickets

In this guide we will cover: – How to give agents the permission to edit billable time and recalculate billing on an action Admin Guides: Agents There are two new permissions in Halo to dictate agents ticket and action level billing capabilities. The first option decides whether or not agents can recalculate billing on tickets […]