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
Extend the power of your Sage Business Management Solution right across your business, giving end-to-end visibility, so you can make better informed business decisions across your business teams, whenever and wherever they work together. Help your business flow. Our range of sales, marketing and service modules help meet the needs of agile businesses. • Create targeted marketing campaigns Help marketing teams reach the right people, at the right time. • Accelerate and focus sales activities - work on the most profitable activities to grow a business, provide an excellent customer experience, delight customers and outperform the competition. • Harness the power of an integrated CRM solution. • Automate processes within any business and do more for less.
1. Intuitive CRM your teams will want to use At ERBS, we believe software shouldn’t be difficult to learn, hard to update or challenging to use. This is the approach we took when we created Sage CRM. It’s an intuitive CRM solution and one which you and your team can get started with and experience within minutes.
Here are ERBS we pride ourselves on keeping up with the latest software upgrades, new features and the innovation of SageCRM in general, and then forwarding on this knowledge and opportunities to you, our customers. So in this tradition, this blog is bringing you, our community, all you need to know about the SageCRM refreshed mobile interface. With the release of Sage CRM 2024 R2, Sage has introduced a refreshed UI that enhances the visual appeal and puts user needs at the centre of the design. Find out more