Browse Guides

BACK TO TOP
Automating Prices in Recurring Invoices
Reading mode
Copy Link
Link Copied!
Print
Feedback
This guide is part of a collection:
<style> .chartjs-size-monitor { display: none !important; height: 0 !important; overflow: hidden !important; }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><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 data-pasted="true"><strong>- Scheduled Automatic Percentage Increases (v2.248+)</strong></p><p><strong>-Tracking Recurring Invoices with Increases</strong></p><p><br></p><p><br></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 &gt; 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><span style="font-size: 10pt;">Fig 1. The main setting to update recurring invoice lines when product values change</span></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 &quot;Always Ask&quot; 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><span style="font-size: 10pt;">Fig 2. The setting to ignore value matching when updating recurring invoices</span></strong></p><p><br></p><p>Now when updating i.e. the recurring price, if the setting shown in figure 1 is set to &quot;Always Ask&quot; 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><span style="font-size: 10pt;">Fig 3. The Option to update all lines, or only non-bundle lines when updating the product record</span></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.&nbsp;</p><p><br></p><p>Head to products &gt; select a product &gt; 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.&nbsp;</p><p><br></p><p>To change the price and cost of this item on your existing recurring invoices, change the values in the &#39;Recurring price&#39; and &#39;Recurring Cost&#39; fields (respectively). Changing these prices will change the prices for all future recurring invoices, to change them for existing invoices enable the settings to &#39;Update Prices/Costs on Recurring invoices&#39;.</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 4. 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.&nbsp;</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.&nbsp;</em></strong></p><p>&nbsp;</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.&nbsp;</p><p><br></p><p>To do this head to configuration &gt; quotations, here you will see the setting shown in figure 2.&nbsp;</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 5. 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 &#39;always&#39; costs and prices that are changed on a bundle will automatically change on the recurring invoices they are on.&nbsp;</p><p><br></p><p>When set to &#39;Display an option in the Product Bundles setting tab&#39;, 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.&nbsp;</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 6. 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.&nbsp;</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.&nbsp;</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 recurring invoice lines to allow the invoice to account for inflation.&nbsp;</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 &gt; billing &gt; recurring invoices, see the setting &#39;Retail Prices Index (RPI) Percent Increase&#39;.</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 7. RPI percent increase&nbsp;</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.&nbsp;</p><p><br></p><p>The increase period can be set per recurring invoice or per line, but by default the increase period will be the repeat period of the recurring invoice.&nbsp;</p><p><br></p><p>Now you have set the default you will need to set the increase per recurring invoice or line.&nbsp;</p><p><br></p><p>To set the increase for all the lines on a recurring invoice, navigate to the recurring invoice and scroll to the &quot;Automatic Increase&quot; section.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjUxOTAxNGRiLWZhNTctNDJhZC1hYzI4LWVhYjQ4YzNiNzZiNSJ9.yR1tJPDPu9yOjt-Vvcv5VFSaPs3zt3Er-togaadbErg" class="fr-fic fr-fil fr-dib" width="750" style="width: 752px; height: 596.671px;" height="597"></p><p><strong><span style="font-size: 10pt;">Fig 8. Automatic Increase for Recurring Invoice</span></strong></p><p><br></p><p><strong>Percent Increase Period -&nbsp;</strong>Choose the interval at which the invoice&#39;s price will increase.&nbsp;</p><p><strong>Percent Increase -</strong> Choose the percentage you would like the price of the lines to increase by. This overrides your RPI. If you would like to use your RPI rate this will need to be entered here, otherwise you will need to set each of the lines to &#39;Use RPI Percent Increase&#39;.&nbsp;</p><p><br></p><p>To set the increase for specific lines on a recurring invoice, edit a line and scroll to the &#39;Automatic increase&#39; section, expand this. Any increase configured on the line will override increase configured on the recurring invoice.&nbsp;</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 9. Automatic increase against invoice</span></strong></p><p><br></p><p><span style="font-size: 11pt;"><strong>Exclude from percentage increase -&nbsp;</strong>Only applicable if you have setup automatic increase for the whole recurring invoice. When enabled this line will not have it&#39;s price increased used for products/services excluded from the affects of inflation, or that has it&#39;s price updated otherwise.&nbsp;</span></p><p data-pasted="true"><strong>Percent Increase Period -</strong> Choose the interval at which this line&#39;s price will increase.&nbsp;</p><p><strong>Percent Increase -&nbsp;</strong>Choose the percentage you would like the price of the lines to increase by. If you would like to use your RPI rate check &#39;Use RPI Percent Increase&#39;.&nbsp;</p><p><strong>Date of last automatic increase -</strong> Enter the date this line&#39;s price last increase. This will be considered when calculating when to apply the next increase to this line&#39;s price. Increases will not apply until the date exceeds this date plus one percent increase period.</p><p><br></p><p>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.&nbsp;</p><p><br></p><p>If you are working in an instance of Halo on version 2.230.1 or higher, you can enable the setting to &quot;Apply automatic price increases to Recurring Invoices before creating the next Invoice&quot; to eliminate the risk of your Recurring Invoices generating before the date of next increase.</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 10. The setting to apply automatic increases to Recurring Invoice lines before their next creation date</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Scheduled Automatic Percentage Increases (v2.248+)</span></strong></p><p>From v2.248+ automatic percentage increases can be configured for your recurring invoice lines on a custom schedule. Rather than a set increase being configured to apply every period indefinitely you can create a custom schedule for the increase. Allowing you to choose how long this percentage increase should apply for, and the periods in which it should be applied (yearly, monthly, weekly etc).&nbsp;</p><p><br></p><p>This could be utilised to automatically apply a one off increase, such as after an introductory price ends, or schedule increases for later in the year, for example.&nbsp;</p><p><br></p><p>Increases can be configured at the following levels:</p><ul><li>Recurring Invoice</li><li>Recurring Invoice line group</li><li>Recurring Invoice line&nbsp;</li></ul><p><br></p><p>Increases are configured the same way but in different locations for each of these levels.&nbsp;</p><p><br></p><p><strong><span style="font-size: 12pt;">Enable Schedule Based Increases</span></strong></p><p>To make schedule based increases available on recurring invoices these must first be enabled under Configuration &gt; Billing &gt; Recurring Invoices &gt; &quot;Use schedule based automatic increases&quot;.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY5YWYwYWIyLWZhNjktNDZlYS1hZDJiLWFmOTRlYmZjM2ZlOCJ9.wIXKcbL9vsXJJ8Ixw_sevsdVuKAOMd5Pb1XRBVfZKtk" class="fr-fic fr-fil fr-dib" style="width: 609px; height: 272.106px;" width="607" height="272"></p><p><strong><span style="font-size: 10pt;">Fig 11. Setting to enable schedule based automatic increases</span></strong></p><p><br></p><p><strong><span style="font-size: 12pt;">Levels at which a Scheduled Price Increase can be Configured</span></strong></p><p><strong><span style="font-size: 12pt;">Recurring Invoice&nbsp;</span></strong></p><p>To configure a price increase that applies to all the lines in the recurring invoice at the same time, head to the recurring invoice &gt; scroll to the &quot;Automatic Increase&quot; section &gt; set &quot;Auto Increase Type&quot; to &#39;Scheduled&#39;.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQ3OGU5MmM4LTc1ZGQtNDVjZi05MGYyLWEyM2RhNDg2MGNjYyJ9.E0FZ3erd5Nze2s-sdn0x0BwFcK1crtvYQ9c2CpoJgwk" class="fr-fic fr-fil fr-dib" width="1485" style="width: 1487px; height: 769.968px;" height="770"></p><p><strong><span style="font-size: 10pt;">Fig 12. Scheduled Auto increase type for recurring invoice</span></strong></p><p><br></p><p>Then the schedule will need to be configured, we will cover this in a later section.&nbsp;</p><p><br></p><p data-pasted="true"><strong><span style="font-size: 12pt;">Recurring Invoice Line</span></strong></p><p data-pasted="true">To configure a price increase that applies to a single line on the recurring invoice, head to the recurring invoice &gt; edit the line &gt; Automatic Increase section &gt; set &quot;Auto Increase Type&quot; to &#39;Scheduled&#39;.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg1YmVhNmY0LTBmOTEtNDJjZi1hYTA0LWY2MDkxZTk0MTUzZSJ9.AA_AbRXtia2eD7kpw6qe49104dgZMHStF641ws8cUsk" class="fr-fic fr-fil fr-dib" width="1834" style="width: 1836px; height: 465.496px;" height="465"></p><p data-pasted="true"><strong><span style="font-size: 10pt;">Fig 13. Scheduled Auto increase type for recurring invoice Line</span></strong></p><p><br></p><p data-pasted="true">Then the schedule will need to be configured, we will cover this in a later section.&nbsp;</p><p><br></p><p data-pasted="true"><strong><span style="font-size: 11pt;">&nbsp;Line Group</span></strong></p><p>To configure a price increase that applies to all lines within the same group on the recurring invoice, head to the recurring invoice &gt; edit the group &gt; the automatic increase is configured here in the &quot;Automatic Increase&quot; table.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg0OTU4Y2Q0LTdmMmEtNGQyOC1hMzIxLTZjY2FiNWMzNDYwMSJ9.YO8qk0rHbfMbrPcoYeYDqgwMloC6g7ZnCioYq6nx9aI" class="fr-fic fr-fil fr-dib" width="539" style="width: 541px; height: 792.557px;" height="793"></p><p><strong><span style="font-size: 10pt;">Fig 14. Automatic increase for recurring invoice line group</span></strong></p><p><br></p><p data-pasted="true">Then the schedule will need to be configured, we will cover this in a later section.&nbsp;</p><p><br></p><p><strong><span style="font-size: 12pt;">Configure the Schedule for Automatic Increase</span></strong></p><p>When configuring the schedule, you will be presented with a table, in which you can add multiple entries. Mutliple entries can be added here to have various automatic increases apply at different times.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImU4ODUwZDVlLWM4OGYtNDFlOC1hYTZmLWFkYjljOGQwYWY1YSJ9.1OcsuvHBCOixAa246F0bebr0gwQ3cizYqGYoBLr9v0Q" class="fr-fic fr-fil fr-dib" width="979" style="width: 981px; height: 276.713px;" height="277"></p><p><strong><span style="font-size: 10pt;">Fig 15. Automatic Increase Schedule Setup</span></strong></p><p><br></p><p>When setting up you will be presented with the options shown in Figure 16.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImNkN2Q1MTk3LTFjODctNGQ3Ny04NzFiLWY5NDE4MDRkNjBmYSJ9.xs87DdCQfZdW1hFbwiv9h8qoF47k8q_cqvaeweVljvQ" class="fr-fic fr-fil fr-dib" width="541" style="width: 543px; height: 539.171px;" height="539"></p><p><strong><span style="font-size: 10pt;">Fig 16. Automatic Increase Schedule Options</span></strong></p><p><br></p><p data-pasted="true"><strong>Percent Increase Period -&nbsp;</strong>The interval in which the increase will apply.&nbsp;</p><p><strong>Start Date -</strong> The date the increase will apply from. To schedule an increase for the future, choose the future date you would like it to apply here.&nbsp;</p><p><strong>End date -</strong> The date the increase will stop applying from. For a one-off increase choo<span style="color: rgb(0, 0, 0);">se the same day th</span>e increase was applied.&nbsp;</p><p><strong>Sequence -&nbsp;</strong>Only applicable when multiple increases are configured for the invoice, and multiple increases are due to apply to the same line on the same day. This will control the order in which increases will apply. Increases with a lower sequence take precedence.&nbsp;</p><p><strong>Note -&nbsp;</strong>Add any notes about the increase here for your reference.&nbsp;</p><p><strong>Use RPI Percent Increase -&nbsp;</strong>Enable this if you want to apply your configure RPI percentage increase instead of a custom percentage.</p><p><strong>Percent Increase -</strong> Choose the percentage you would like the lines price to increase by.&nbsp;</p><p><br></p><p>Using the Figure 16 example the price will increase by 10% from the 01/08. The price will increase by another 10% on 01/09, any invoices created after this will not have their price increased any further.</p><p><br></p><p><strong>Which Invoice will the Increase apply in?&nbsp;</strong></p><p>The invoice in which the increase will apply will depend on whether you have &quot;Apply automatic price increases to Recurring Invoices before creating the next Invoice&quot; enabled. Found under Configuration &gt; Billing &gt; Recurring Invoices.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFlNzI3ODZlLTgwOTEtNDBhNS1iOWNiLWQxOTY3NGRhMzAwNCJ9.rKr8UBzED_6C05odlO3WLTM5B3sR-ksbGNbHHYi9IdE" class="fr-fic fr-fil fr-dib" width="910" style="width: 912px; height: 354.228px;" height="354"></p><p><strong><span style="font-size: 10pt;">Fig 17. Apply automatic price increases to Recurring Invoices before creating the next Invoice</span></strong></p><p><br></p><p><strong>When Enabled -&nbsp;</strong>Increases will be applied on the invoice for the same period the increase starts in.&nbsp;</p><ul><li>For example, my recurring invoice is billed monthly for the period 1st-last day of the month. If an increase is scheduled for the 1st October this will be added to the invoice that bills for the period 01/10 - 31/10.</li></ul><p><strong>When Disabled -</strong> Increases will be applied on the invoice for the period after the period the increase starts in.&nbsp;</p><ul><li data-pasted="true">For example, my recurring invoice is billed monthly for the period 1st-last day of the month. If an increase is scheduled for the 1st October this will be added to the invoice that bills for the period 01/11 - 30/11.</li></ul><p><br></p><p><strong><span style="font-size: 12pt;">Identifying Increases</span></strong></p><p data-pasted="true">When an increase is due to be applied to a line for the next invoice creation, an icon will display next to the price denoting this. You can then hover on the icon / edit the line to view what the new price will be.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFkZTRlZDIyLTU1ZWQtNDRhMS05NzM5LWM1ZWU4MTVlODdiNCJ9.ejtLi7LaseYSqfpc1c__0dt6uwJZXhtkTtfA858UHSg" class="fr-fic fr-fil fr-dib" width="1361" style="width: 1363px; height: 735.961px;" height="736"></p><p><strong><span style="font-size: 10pt;">Fig 18. Icon to indicate price will increase&nbsp;</span></strong></p><p><br></p><p data-pasted="true">This icon will only appear on the recurring invoice when the next invoice that is generated will have a price increase.&nbsp;</p><p><br></p><p><strong><span style="font-size: 14pt;">Tracking Recurring Invoices with Increases</span></strong></p><p>The following columns can be used when reporting on recurring invoices (and lines) to help track increases:</p><p>Columns found in the table &#39;invoiceheader&#39;</p><ul><li>ihautoincreasetype - Indicates the type of increase the recurring invoice is using (recurring =0, scheduled=1)</li><li>ihautoincreaseperiod - (Recurring increases only) Indicates the period in which the recurring invoice is due to increase (1=weekly, 2=monthly, 11=2-monthly, 4=Quarterly, 5=6-monthly, 3=Yearly, 8=2-Yearly, 7=3-Yearly, 9=4-Yearly, 6=5-Yearly, 10=10-Yearly).</li><li>ihpercentincrease - <span style="color: rgb(0, 0, 0);">(Recurring increases only)&nbsp;</span>Indicates the percentage in which lines on this invoice are going to increase by.</li></ul><p>Columns found in invoicedetail</p><ul><li>idautoincreasetype - Indicates the type of increase the recurring invoice is using (recurring =0, scheduled=1)</li><li>idpercentincrease - <span style="color: rgb(0, 0, 0);" data-pasted="true">(Recurring increases only)</span>&nbsp; Indicates the percentage in which this line is going to increase by.&nbsp;</li><li>idautoincreaseperiod - (Recurring increases only) Indicates the period in which the recurring invoice is due to increase (1=weekly, 2=monthly, 11=2-monthly, 4=Quarterly, 5=6-monthly, 3=Yearly, 8=2-Yearly, 7=3-Yearly, 9=4-Yearly, 6=5-Yearly, 10=10-Yearly).</li><li>idautoincreaselastchangedate - Indicates the date the line last had a price increase.&nbsp;</li><li>idexcludefromautoincrease - Indicates if the line is excluded from automatic increases or not.</li></ul><p><br></p><p><br></p><p><br></p><p><br></p>
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.