Show including tax amount on Documents

[wdbruwer]

We would like to show the including tax amount on quotes for each line item/product, how do we go about this?

Alternatively is there away to have product unit prices as including VAT amount and have quotes/invoices etc. display as including VAT as default and just a total VAT at the bottom onfo the quote?

[victor]

For example, Quote and Quote Items:

1. In Administration > Entity Manager > Quote Item > Fields, create a field called myTaxAmount with Currency type.



2.In Administration > Entity Manager > Quote Item > Formula > Before Save Custom Script, create the formula:

myTaxAmount = taxRate/100*amount;

3. Add the myTaxAmount field in Administration > Entity Manager > Quote Item > Layouts > List (Item).

- For the formula to work, you must specify the Tax Rate in your Quote Item:


- The value in the myTaxAmount field will be calculated after saving changes to your Quote Item, not in inline editing mode.