<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>- How to have the quantity of a recurring invoice calculate based on subscription count </strong></p><p><strong>- Update Price/cost of items on recurring invoices from within the product</strong></p><p><br></p><p><br></p><p><strong><span style="font-size: 14pt;">How to have the quantity of a recurring invoice calculate based on subscription count <br></span></strong></p><p>In order to manage recurring invoice lines linked to subscriptions being synced from distribution integrations, the following setting can be enabled in Halo (Found in Configuration > Billing > Recurring Invoices):</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjA3YWMzMDEzLTE4M2ItNDcxNi1hYWQ5LWY0Mzg4MzE1MDczNiJ9.uOZshaaRTrxOaHZSy6gIiGb6zuwiOYThqdIXAZMrGi8" class="fr-fic fr-fil fr-dib" width="536" height="42"></p><p><strong><span style="font-size: 10pt;">Fig 1. 'Make Recurring Invoice lines inactive when subscription/license becomes inactive' setting</span></strong></p><p><br></p><p>With this setting enabled, any subscriptions cancelled in i.e. Pax8 (or any other distribution integration that pulls through subscription status) will be synced over to be made inactive in Halo. The syncing will occur daily, based on the sync time of the Halo Integrator.</p><p><br></p><p>Quantity changes in distribution integrations will also sync through via the Halo Integrator into Halo, meaning that the quantity updates will happen daily, without a requirement for any setting changes. The only required setting for this functionality is:<br><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFiMjdlNzhmLTI5YjYtNGZmNi1hNjMzLTNjOTU2MjMwYTE0MCJ9.VOdc78rf8rivrIsg3ToXa7bdbw8rguUiuNQZ7i4fAYk" class="fr-fic fr-fil fr-dib" width="651" height="72"></p><p><strong><span style="font-size: 10pt;">Fig 2. 'Allow recurring invoice line quantities to be calculated using Licence, User and Asset counts' setting</span></strong></p><p><br></p><p>The above setting will perform a lookup on the subscriptions, licences, user and asset counts stored under each customer in Halo, allowing you to accurately bill the correct quantity (Including Pro Rata) each month. For example if the quantity count under a subscription changes within a customer:</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImQxODMwMTU0LWUxZmQtNGZkOC1hOTBlLTM5YzI1OTNmM2FlMiJ9.VjHR6Vvwx6CXFj1DRRHz6CCa36cjbWc06Wb7insJAoE" class="fr-fic fr-fil fr-dib" width="1267" style="width: 1269px; height: 387.956px;" height="388"></p><p><strong><span style="font-size: 10pt;">Fig 3. Licence count of a customer</span></strong></p><p><br></p><p>This would be reflected on a recurring invoice line by firstly, adding a product to a recurring invoice:</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjI3Nzc1NWUwLTYzNDEtNDFmOS1iZTYxLTQ0NTExNDE4NTYwZiJ9.jg5tE1fpNUB98LjybB3bPD6ZLsldPwdC9J4Lipw98AA" class="fr-fic fr-fil fr-dib" width="1276" style="width: 1278px; height: 233.169px;" height="233"></p><p><strong><span style="font-size: 10pt;">Fig 4. Adding product to recurring invoice</span></strong></p><p><br></p><p>Then editing the line via the pencil icon, and setting the quantity field to "Subscription count on creation":</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImNkMjFjNzMxLTI2ZmItNDZjMi05ODYwLWRjNmNkMjQyODgyYSJ9.416vEEp7W2_rnmf-_ClKAx8UdoQvlJWjJEQT6Elh0kA" class="fr-fic fr-fil fr-dib" width="1264" style="width: 1266px; height: 280.526px;" height="281"></p><p><strong><span style="font-size: 10pt;">Fig 5. Edit invoice line, set quantity of line to be calculated based on subscription count</span></strong></p><p><br></p><p>Within the table add your subscription that you would like to do a lookup on the quantity of (This lookup will be done on a daily basis):</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImIwMmVkODA5LWYzY2UtNDQ1MS04NDYyLTM5NDM5Nzc0ZTlmOCJ9.1PEDvV99-ne-_LUKcXdQhisVakyW9TIpyfytbJhZz6E" class="fr-fic fr-fil fr-dib" width="526" style="width: 528px; height: 508.353px;" height="508"></p><p><strong><span style="font-size: 10pt;">Fig 6. Set which subscription you would like quantity to be based on</span></strong></p><p><br></p><p>You can free up a number of the subscriptions, this value will always be deducted from the calculated quantity. You can also set a minimum number of licences that should always be billed for. Automatic adjustments will never take the invoice quantity below this amount</p><p><br></p><p>To add this functionality onto an invoice line for assets, licences, users etc... Check out this guide on <a href="https://usehalo.com/halopsa/guides/1970/" target="_blank" rel="noopener noreferrer"><strong>Automating Quantities in Recurring Invoices</strong></a></p><p><br></p><p>The pricing and cost data of subscriptions and licenses can be updated based on the price/ cost set on the subscription or licence lines found within the customer, <strong>only</strong><strong> if the distribution integration is syncing price and/ or cost data</strong>. The pricing/ cost updates can be set globally or per recurring invoice line. To set this option globally, navigate to Configuration > Billing > Recurring Invoices:<br><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjZiNTU5MDdkLTc0NDMtNDMzNy1iNDIzLTk4OTBkYjA1NDhhOCJ9.ehfiCYSfXElLnPV-2OExKPWoryR-l1foTScydy12K68" class="fr-fic fr-fil fr-dib" width="752" style="width: 754px; height: 112.55px;" height="113"></p><p><strong><span style="font-size: 10pt;">Fig 7. Global settings to update invoice price/cost when subscription cost/price changes</span></strong></p><p><br></p><p>Alternatively the pricing/ cost update functionality can be set per recurring invoice line, by editing a recurring invoice line and setting the following to options:</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU0ODRiODliLTM1ZGItNGVkMy1hY2ZkLWIzOTZlOTZlZGI5ZiJ9.Q-Qmxf3GYuz378NkwqUtwJAKUI_VsVcBGaRKmG8tGEY" class="fr-fic fr-fil fr-dib" width="685" style="width: 687px; height: 625.561px;" height="626"></p><p id="isPasted"><span style="font-size: 10pt;"><strong>Fig 8. Invoice line level setting to update invoice price/cost when subscription cost/price changes</strong></span></p><p><br><strong><em>Note: If the above global settings have been enabled, the checkboxes within each recurring invoice line will be defaulted to on as well. </em></strong></p><p><br></p><p>If the automated price/ cost updates are not set, the Price and cost will be set on the recurring invoice line here:</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY5N2JiOGYyLTZiNDYtNGIwNS04NjhjLWQzZjhmNTUwNDZjNyJ9.Phea9aIURdbdG-z2Ff4yOjuMbtMKNJim3MTZROx-Zt4" class="fr-fic fr-fil fr-dib" width="1487" height="679"></p><p><strong><span style="font-size: 10pt;">Fig 9. Set price and cost of subscription on invoice line</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Update Price/Cost of an item on recurring invoices from within the product</span></strong><span style="font-size: 14pt;"><br></span></p><p>The Price/ Cost associated to all recurring invoices can also be updated directly from the product screen:<br><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjA1NGE1YzRlLWM4MTEtNDg0Ny04Zjk4LTIxOWQ5OGVjMDgyMyJ9.Pnxq1IO3wRQQ98ZxyF5hz5SQ8ebcxKTML6drVreDFLA" class="fr-fic fr-fil fr-dib" width="1073" style="width: 1075px; height: 473.394px;" height="473"></p><p><strong><span style="font-size: 10pt;">Fig 10. Price/cost of product </span></strong></p><p><br></p><p><strong><em>IMPORTANT: This will only update line items that currently have the same recurring price or recurring cost. After changing the value on the recurring price/ cost input fields, clicking on the checkbox options, and saving the page, the checkboxes will go back to being unset. This is because the price/ cost change on all recurring invoices, happens on a one time basis, after clicking save, this modal screen will pop:</em></strong></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjMwODY2NDE0LWRiNTktNGZmOC1iMzA3LWIyYWNhNjMxNjg1NiJ9.VwOUk7ELiHp1a6xdJlYH87SLIGJNkoGyH6OVtYcIq40" class="fr-fic fr-fil fr-dib" width="1005" style="width: 1007px; height: 322.778px;" height="323"></p><p><strong><span style="font-size: 10pt;">Fig 11. Pop-up following updating item price</span></strong></p><p><br></p><p>After saving, and clicking "ok" on the modal window, the checkboxes will go back to "No":</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImIwMjlmMmViLTUzYzktNDM1OS05NTY5LTJkMzc3Y2MxYzNlMyJ9.vlviiPHMc46SPqQig49kD8SW_YoanpLAsZ5dak8Fz2o" class="fr-fic fr-fil fr-dib" width="1179" style="width: 1181px; height: 418.711px;" height="419"></p><p><strong><span style="font-size: 10pt;">Fig 12. Product price following price update</span></strong></p><p><br></p>
