Hello,
I have noticed currently quote calculation on Quote level. I can apply to calculation tax on quote line item level. Because I have different type categories and product, so each product apply different type of VAT.
I have attached below screen shot.
1) First product line item apply "20% (Vat on Income)"
2) Second product line item apply "5% (Vat on Income)"
3) Third product line item apply "0% (No Vat)"
Thanks
Asif
Francesca Shiekh André Lopes Ramana Raju Santhana Alex Nassi
Hello Francesca Shiekh,
Thanks for Francesca Shiekh and Aravind Kumar.
Line item level tax is working for me.
How can I calculate Group level total tax add in Group total ?
How can I calculate total tax add in Quote Grand total ?
I have created custom field "line_tax_percent_c" and "custom_toggle" in "Quote Line Item(Product)". When I have edited quote line item but it's db store value not come.
I have set field in "custom/modules/Products/clients/base/views/quote-data-group-list/quote-data-group-list.php".
<?php
/*
* Your installation or use of this SugarCRM file is subject to the applicable
* terms available at
* http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
* If you do not agree to all of the applicable terms or do not have the
* authority to bind the entity as an authorized representative, then do not
* install or use this SugarCRM file.
*
* Copyright (C) SugarCRM Inc. All rights reserved.
*/
$viewdefs['Products']['base']['view']['quote-data-group-list'] = array(
'panels' => array(
array(
'name' => 'products_quote_data_group_list',
'label' => 'LBL_PRODUCTS_QUOTE_DATA_LIST',
'fields' => array(
array(
'name' => 'line_num',
'label' => null,
'widthClass' => 'cell-xsmall',
'css_class' => 'line_num tcenter',
'type' => 'line-num',
'readonly' => true,
),
array(
'name' => 'quantity',
'label' => 'LBL_QUANTITY',
'widthClass' => 'cell-small',
'css_class' => 'quantity',
'type' => 'float',
),
array(
'name' => 'product_template_name',
'label' => 'LBL_ITEM_NAME',
'widthClass' => 'cell-large',
'type' => 'quote-data-relate',
'required' => true,
),
array(
'name' => 'mft_part_num',
'label' => 'LBL_MFT_PART_NUM',
'type' => 'base',
),
array(
'name' => 'discount_price',
'label' => 'LBL_DISCOUNT_PRICE',
'type' => 'currency',
'convertToBase' => true,
'showTransactionalAmount' => true,
'related_fields' => array(
'discount_price',
'currency_id',
'base_rate',
),
),
array(
'name' => 'discount',
'type' => 'fieldset',
'css_class' => 'quote-discount-percent',
'label' => 'LBL_DISCOUNT_AMOUNT',
'fields' => array(
array(
'name' => 'discount_amount',
'label' => 'LBL_DISCOUNT_AMOUNT',
'type' => 'discount',
'convertToBase' => true,
'showTransactionalAmount' => true,
),
array(
'type' => 'discount-select',
'name' => 'discount_select',
'no_default_action' => true,
'buttons' => array(
array(
'type' => 'rowaction',
'name' => 'select_discount_amount_button',
'label' => 'LBL_DISCOUNT_AMOUNT',
'event' => 'button:discount_select_change:click',
),
array(
'type' => 'rowaction',
'name' => 'select_discount_percent_button',
'label' => 'LBL_DISCOUNT_PERCENT',
'event' => 'button:discount_select_change:click',
),
),
),
),
),
array(
'name'=>'customrow_toggle_c',
'widthClass' => 'cell-small',
'label'=>'LBL_CUSTOMROW_TOGGLE',
'type' => 'varchar',
),
array(
'name'=>'line_tax_percent_c',
'widthClass' => 'cell-small',
'label'=>'LBL_LINE_TAX_PERCENT_C',
'type' => 'float',
),
array(
'name'=>'line_tax_amount_c',
'label'=>'LBL_LINE_TAX_AMOUNT_C',
'type' => 'currency',
'widthClass' => 'cell-small',
'showTransactionalAmount' => true,
'related_fields' => array(
'total_amount',
'currency_id',
'base_rate',
),
),
array(
'name' => 'total_amount',
'label' => 'LBL_LINE_ITEM_TOTAL',
'type' => 'currency',
'widthClass' => 'cell-medium',
'showTransactionalAmount' => true,
'related_fields' => array(
'total_amount',
'currency_id',
'base_rate',
),
),
),
),
),
);
Francesca Shiekh Aravind Kumar
Thanks
Asif
Hi Aravind Kumar,
It is not displaying value in detail or edit record page. I have set same as Francesca Shiekh code.
1) line_tax_percent_c - It is float type field but it is not displaying value.
2) line_tax_amount_c - It is currency formula field but it is displaying value.
3) customrow_toggle_c - it is varchar type field but it is not displaying value.
