SageCRM insights - Line Item VAT & Discount module
Nick Rainbird • June 17, 2020
Welcome to this weeks SageCRM-Insights article where we are going to share with you one of our highly requested custom modules for managing Quote and Order Line Item level Discounts and VAT
calculations. SageCRM out of box does not currently include the functionality to manage VAT application and line item level discounts but does let you set a discount percentage or amount that can be applied across the full quote or order record. So following requests from our customers and new prospects we have developed both a Line Item level VAT and Discount module for SageCRM.
Applying a line item level discount %
If you need to be able to provide a quote or order discount at the line item level for one or many products we have provided a "Discount %" field where a percentage value can be entered and will be applied to the specific line item product only. In the example below 10%
discount will be applied to the cost of dinning chair.
The "Discount%, Line Item Discount, Discount Total" fields are automatically populated for the line item entry and the order summary screen.
This feature can also be extended so validation rules can be put in place so only discounts up to a specific threshold percentage can be applied. e.g. no more than 25% can be applied as a discount.
Applying VAT to a Line Item
If you need to be able to provide VAT costs on your quotes and orders we have developed a VAT module which picks up the VAT rate from the VAT% selection field at the line item level. (The selection list means you can have multiple VAT rates to select from which can be changed easily to 0% and 20% as shown in the below example).
The "VAT Line Item" and "Total Inc VAT" custom fields have been created and are populated automatically with the correct calculation at the line item level. At the quote or order summary record level the "Total VAT" and "Total Including VAT" values are also calculated.
This also means the new custom discount and VAT fields can be added to any quote or order templates you have in place.
To demonstrate these features we have put together the following short video so you can see both the discount and VAT modules in action:
If you are interested in adding one or both of these module to your existing or new SageCRM system please feel free to get in touch on
01494 490409
or email the me at
nick@rainbirdbusiness-solutions.com
to discuss these further.
Until the next SageCRM Insights instalment keep safe and we will continue to help you unlock your success with SageCRM!
Nick
Rainbird Business Solutions
Stay Connected with ERBS
Read our latest updates
Enquire now
Get in touch
What’s changing in Sage CRM?
AI CRM pricing in 2026: what you're really paying for The price on an AI CRM’s website is a starting point, but it may not reflect the full cost for your business. Two systems with similar monthly fees can work out quite differently once you include AI add-ons, plan upgrades and usage charges. In this guide, we’ll explain the three main layers of AI CRM pricing and how they affect your budget. Knowing what to look for makes it easier to compare providers, ask the right questions and understand what you’ll be paying before you commit.
The 9:57am Problem