Quote line total without tax/vat

SuiteCRM Forum - English Language
1

Hello all

I’m trying to find a variable which reflects the line total without the tax/vat component on a Quote template.
The $aos_products_quotes_product_total_price variable includes the tax/vat.

How can I get to the line total without tax/vat?

Thanks so much

2

Not sure which one. Here is the list of standard fields for LineITems:

name
date_entered
date_modified
description
deleted
currency_id
part_number
item_description
number
product_qty
product_cost_price
product_cost_price_usdollar
product_list_price
product_list_price_usdollar
product_discount
product_discount_usdollar
product_discount_amount
product_discount_amount_usdollar
product_unit_price
product_unit_price_usdollar
vat_amt
vat_amt_usdollar
product_total_price
product_total_price_usdollar

Thanks,

BrozTechnologies

3

Thanks @BrozTechnologies

However I’ve been through all of the existing fields in the related modules such as Quotes, and Line Items : Groups, Line Items : Product and none of them has the total excluding the tax/vat.

I’m thinking (hoping) :
1 maybe I can use a formula to deduct the tax from $aos_products_quotes_product_total_price, but how and where?
2 maybe I can create a custom field, and again how and where?

Thanks

4

The where and when depends on where you want do display the field. Now, if for line items, you need to copy file modules/AOS_Product_Quotes/line_items.js to custom/modules/AOS_Product_Quotes/line_items.js and modify it according to your needs.

Check here for more info:

Thanks,

BrozTechnologies

5

I found a setting in Admin > AOS Settings > Add Tax to line total.
Simply do not add tax to the line item total.

However it would be interesting to know whether either of the 2 workarounds I thought of is possible?

Thanks