Additional Quantity field for Quoted Line Items

It has been a long time since I customized my Quotes but I think the discount_amount is the percentage or currency amount of the discount, while the discount_price might be what you are after.

What I would suggest is manipulating the formula for the total_amount on the quoted line via studio or code ( custom/Extension/modules/Products/Ext/Vardefs/sugarfield_total_amount.php ) to include the multiplication for the newly added term, although

I suppose you could try to manipulate the discount_price to reflect the term quantity, but I think you might need to disable the readonly on that field (see: https://sugarclub.sugarcrm.com/dev-club/f/questions-answers/1179/new-quotes-modules-how-to-update-the-current-qli-based-on-field-change/4778#4778 )

Also be sure to add your new field to the related_fields of the Quote's record view metadata:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.3/Architecture/Quotes/#Adding_Custom_Related_Fields_to_Model

Sorry for the somewhat vague response, I hope this gives you some ideas though.

Good luck,

FrancescaS

Hi Francesca, 

Thanks again for your help with this issue, and all the issues over the years. You are a true wealth of knowledge. 

There were two VarDef files I need to modify, 

custom/Extension/modules/Products/Ext/Vardefs/sugarfield_subtotal.php

and 

custom/Extension/modules/Products/Ext/Vardefs/sugarfield_total_amount.php

I basically added my new "term" field to the multiplication function of the $discount_price and $quantity i.e. 

The formula for both fields needed to be overridden as the "total_amount" references the "subtotal" in its formula.

The strange thing is, I could not edit the formula via studio as  I would receive this error when trying to save the formula.

Unknown field: discount_amount

As mentioned above, the discount_amount is a valid field. As you can see in Studio.

However I can not use it in the Formula Builder, 

It is some how hidden from the Formula Builder. However I can add it via the Vardef file. 

Any clues?

Hi Francesca, 

Thanks again for your help with this issue, and all the issues over the years. You are a true wealth of knowledge. 

There were two VarDef files I need to modify, 

custom/Extension/modules/Products/Ext/Vardefs/sugarfield_subtotal.php

and 

custom/Extension/modules/Products/Ext/Vardefs/sugarfield_total_amount.php

I basically added my new "term" field to the multiplication function of the $discount_price and $quantity i.e. 

The formula for both fields needed to be overridden as the "total_amount" references the "subtotal" in its formula.

The strange thing is, I could not edit the formula via studio as  I would receive this error when trying to save the formula.

Unknown field: discount_amount

As mentioned above, the discount_amount is a valid field. As you can see in Studio.

However I can not use it in the Formula Builder, 

It is some how hidden from the Formula Builder. However I can add it via the Vardef file. 

Any clues?

This rings a bell as something I reported in the past... but I can't seem to find the case in question in my portal. You may want to open a case with Support, they should be able to dig it up...

I don't have discount_amount in studio either, yet I am using it in the formula.
I think in the end I edited the vardef php file instead of going through Studio.

This is a screenshot from Studio, as you can see the field is not there, yet I'm clearly using it in the formula

This is my custom/Extension/modules/Products/Ext/Vardefs/sugarfield_total_amount.php

<?php
$dictionary['Product']['fields']['total_amount']['formula'] =
'ifElse(and(isNumeric(toString($quantity)), isNumeric(toString($discount_price))),
  currencyMultiply(
    round(
      subtract(
        $discount_price,
        ifElse(equal($discount_select, "1"),
          multiply($discount_price, divide($discount_amount, 100)),
          ifElse(isNumeric(toString($discount_amount)), $discount_amount, 0)
        )
      ),
    2),
    $quantity
 ),
 ""
)';