<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>- Update recurring invoice lines when Products are updated</strong></p><p><strong>- How to have prices/costs on recurring invoices update automatically when the price/cost of an item is changed</strong></p><p><strong>- How to update item and recurring invoice prices using product bundles</strong></p><p><strong>- Set automatic percentage increases for invoice lines</strong></p><p><br></p><p id="isPasted"><strong><span style="font-size: 14pt;">Update recurring invoice lines with Product changes</span></strong></p><p>This setting can be found in Configuration > Items and Stock Control:</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImRhNGFjMWVmLWMxZTMtNGI5Yi04OTU5LTViYjcwM2U1OGM2NSJ9.YqZMKOwuCInzNlq_tPswVleSWnvdFVoVD_cItXPzmMw" class="fr-fic fr-fil fr-dib" width="1123" height="138"></p><p><strong>Fig 1. The main setting to update recurring invoice lines when product values change</strong></p><p><br></p><p>As the setting explains, the product updates on the recurring invoice lines, will include: Name, Sales Description, Recurring Price, Recurring Cost, Tax code, Quickbooks Product ID, Tax code (Sales). If the setting displayed in figure 1 is set to "Always Ask" there will be an additional setting that can be turned on:<br><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY3YmM1MGQ1LTY4ZTktNDhjZC1iNGJhLTJkZDhlYmI5MGM1MCJ9.mLMCfnCTMmfdy2jcNkYU9BZXU_0lV-wzXsx2y_LGp2g" class="fr-fic fr-fil fr-dib" width="836" height="59"></p><p><strong>Fig 2. The setting to ignore value matching when updating recurring invoices</strong></p><p><br></p><p>Now when updating i.e. the recurring price, if the setting shown in figure 1 is set to "Always Ask" a warning will appear and the following dropdown must be set:</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgyNzA1MWEwLTNlODAtNDczMS1hYTI2LTY3MDQ2ZmNiMzNhNCJ9.QlcEvlFs6aK9_qWmv2uw3efsIps9QPh3lBRFfbfcLNc" class="fr-fic fr-fil fr-dib" width="867" height="491"></p><p><strong>Fig 3. The Option to update all lines, or only non-bundle lines when updating the product record</strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Update item costs/prices</span></strong></p><p>When the price/cost of a recurring item is changed this can also update the recurring invoices this item appears on. </p><p><br></p><p>Head to products > select a product > costing and pricing, here you can change the costs/prices of this item. It is important to note there are two types of cost/price. Fixed, this is the price that will be charged when the item is ordered as a one off. Recurring, this is the price that will be charged when the item is on a recurring invoice. </p><p><br></p><p>To change the price and cost of this item on your existing recurring invoices, change the values in the 'Recurring price' and 'Recurring Cost' fields (respectively). Changing these prices will change the prices for all future recurring invoices, to change them for existing invoices enable the settings to 'Update Prices/Costs on Recurring invoices'.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImE2ZTk5ZDU3LTdmZTgtNDBjYi04Y2JkLWY4MDk0ZmZhYTdhNyJ9.TZELNFnk2pUzeWfJLl6B_9FxD-MAr3YosgAth39Z1Ag" class="fr-fic fr-fil fr-dib" width="1384" height="513"></p><p><strong><span style="font-size: 10pt;">Fig 1. Fields to update on recurring product</span></strong></p><p><br></p><p>Once prices are updated this will take a few minutes to take effect, you will receive a pop-up to prompt you about this. </p><p><br></p><p><strong><em>Note: This will change the price on the recurring invoice, if the invoice for the period has already been created you will need to delete the invoice and re-create it. </em></strong></p><p> </p><p><strong><span style="font-size: 14pt;">How to update item prices using product bundles</span></strong></p><p>If you are using product bundles you can change the price for the bundle on recurring invoices rather than changing it on each item. </p><p><br></p><p>To do this head to configuration > quotations, here you will see the setting shown in figure 2. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjAyMTNlZDAzLWZmYjQtNGEzZS1iNWY5LWQ0ZTMzY2EzOWQ1YiJ9.smX-pvLfmyb3uf7i7G10xDpfVWSuwUA7WJ5eecYko1A" class="fr-fic fr-fil fr-dib" width="686" height="412"></p><p><strong><span style="font-size: 10pt;">Fig 2. Update prices for Bundle Products on Recurring Invoices when changed on the Bundle Template setting</span></strong></p><p><br></p><p>When this is set to 'always' costs and prices that are changed on a bundle will automatically change on the recurring invoices they are on. </p><p><br></p><p>When set to 'Display an option in the Product Bundles setting tab', an additional setting will appear against the bundle and you will be able to choose if bundle prices will be updated on a per bundle basis. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgzYWVhOWMwLTAwNmUtNDg4YS04NTU3LWY0MjZmNzIwYzk3NiJ9.O8ofqm5ZcFU-RwcCyemQENewbJ3oVdcpss3T5qrD1LA" class="fr-fic fr-fil fr-dib" width="1256" height="893"><strong><span style="font-size: 10pt;">Fig 3. Setting in Product Bundle</span></strong></p><p><br></p><p>When this setting is enabled the item prices on existing recurring invoices will change when they are changed on the bundle. When disabled new recurring invoices will use the price set on the bundle but existing recurring invoice prices will not change. </p><p><br></p><p><strong><em>Note: Changing the item price on a bundle will not change the price of the linked item, it will only affect the bundle price. </em></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Set automatic percentage increases for invoice lines</span></strong></p><p>An automatic percentage increase can be applied to each of your recurring invoice lines to allow the invoice to account for inflation. </p><p><br></p><p>The line will increase by the set percentage each increase period.</p><p><br></p><p>To set the default percentage increase, head to configuration > billing > recurring invoices, see the setting 'Retail Prices Index (RPI) Percent Increase'.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM3Nzg2YTg1LTE5MzktNDVjNy04ZGIzLTg5YWQyMDNjNmU1YyJ9.USDJPhhbaYEZ5z9OJVL72aVXBTQ0B5zHlouo69h1erY" class="fr-fic fr-fil fr-dib" width="723" style="width: 725px; height: 255.551px;" height="256"></p><p><strong><span style="font-size: 10pt;">Fig 4. RPI percent increase </span></strong></p><p><br></p><p>Here, you can set the default percentage that invoice lines will increase by. They will increase by this percentage each increase period. </p><p><br></p><p>The increase period can be set per line, but by default the increase period will be the repeat period of the recurring invoice. </p><p><br></p><p>Now you have set the default you will need to set the increase per recurring invoice line. Navigate to a recurring invoice and edit a line. When editing the line you will see the section 'Automatic increase' expand this section.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU5ZjU4OTMyLWYxNTctNGNjOS1hMDdjLTA1ZDY1NmEyMzQ3MyJ9.3UVv-8BuAfSv7vxnqe76fZAX9O05-Gsx9ymJ2s05P7I" class="fr-fic fr-fil fr-dib" width="1113" style="width: 1115px; height: 451.257px;" height="451"></p><p><strong><span style="font-size: 10pt;">Fig 5. Automatic increase against invoice</span></strong></p><p><br></p><p>For all lines you will need to ensure the 'Percent Increase Period' is set, as well as the 'Date of last automatic increase'. </p><p><br></p><p>The date set as the 'Date of last automatic increase' will be used to calculate the date of the next automatic increase. Please be aware that if you have set your invoices to generate ahead of schedule, the system will not account for this in the calculations for the date of next increase. As a result the invoices could generate before the date of next increase. </p><p><br></p><p><strong><em>Note: If you are working in an instance of Halo on version 2.230.1 or higher, you can enable the setting to "Apply automatic price increases to Recurring Invoices before creating the next Invoice" to eliminate the risk of your Recurring Invoices generating before the date of next increase.</em></strong></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFjYjI0MzUzLTZmNTMtNDQyZC1hZjYyLWVmNzBmZTE4OGI4OSJ9.0EjASHmuOvNNKTW4wGWnOVQHItRbVfxAws8IL2FNPZs" class="fr-fic fr-fil fr-dib" width="1019" style="width: 1021px; height: 492.17px;" height="492"></p><p><strong><span style="font-size: 10pt;">Fig 6. The setting to apply automatic increases to Recurring Invoice lines before their next creation date</span></strong></p><p><br></p><p>To have the line use the default automatic increase, check the setting 'Use RPI Percent Increase'. </p><p><br></p><p>To have this line increase by a different rate to the default RPI uncheck 'Use RPI Percent Increase' and enter the percentage increase you would like the line to use in the 'Percent Increase' field. </p><p><br></p><p>If you would like the price of this line to not increase automatically check 'Exclude from percentage increase'. However, not setting any automatic increase settings against the line will also cause the line to not increase automatically. </p><p><br></p><p><br></p>
