Quotes Module and Shipping Tax calculation

[david.strejc]

In Quote module there is logic for calculation of Tax amount but Shipping is exluded from this logic.

We are pushing data from WooCommerce to Quotes and there needs to be option or logic for Shipping * Tax amount to be included in total tax.

[Vadym]

Hi david.strejc

To implement this logic, put the code below to Administration -> Entity Manager -> Quote -> Formula
or
create a Workflow rule with the Quote target entity and After record saved (created or updated) trigger and Execute Formula Script Action.

$taxRate = tax.rate / 100;
taxAmount = taxAmount + (shippingCost * $taxRate);
grandTotalAmount = amount + taxAmount + shippingCost;

Note, that the "tax" field must be filled.

https://docs.espocrm.com/user-guide/quotes/#default-tax

More information about Workflows and Formula:
https://docs.espocrm.com/administrat...ows/#workflows
https://docs.espocrm.com/administrat...culated-fields