Calculate CST, VAT and BED Taxes on Sage CRM’s Quote-Items screen

By | July 22, 2015

Hi folks! This article is in continuation of my previous blog where I have explained the logic of calculating CST for Quotes. Below is the URL for the same.  Now through this blog I will be explaining you one of the complex requirement which we recently came across. One our Client had business over many states and since every state has its own tax parameters calculations (i.e. VAT, CST and BED). We had to accommodate these tax values on the Quote items maintained in CRM.
Related Stuff: Calculate CST for Quotes through Sage CRM
Before I move forward with my explanation please have a look at below “New Line Item” images.
blogimg1
blogimg2
If you compare above two images only state is different and related tax parameters defined above changes. We used “AJAX” technology to auto calculate tax parameters value based on selected product family and its respective State.
Now on saving above two line item details, “Quote Item” grid looks as shown below.
blogimg3
As you can see in above image respective tax parameter’s values gets calculated individual Item wise. Total tax amount collected is shown in “Total Tax Amount” field and final amount with added tax value is shown in “Final Amount” field.
To build this functionality we have created Triggers on Quote and Quote Items entities which calculate the CST,VAT ,BED values and stored the same.
Happy Scripting 🙂
Also Read:
1)  Default quote expiration/Delivery date setting in Sage CRM
2) Effective use of CPQ (Configure Price Quote) in Sage CRM
3) Quote Summary Screen Enhancements in Sage CRM 7.3
4) Create Quotes in Sage ERP X3 from Sage CRM
5) Clone Quotes and Orders in Sage CRM