Add field in QLI within Quote detail/edit view

Hi All,

I followed the instructions from this bug SugarCRM and now I able add oob/custom field.

But question is how to add validation for each QLI for example, user can increase Unit Price but cannot decrease like if Unit Price is 500 than user cannot update to 449 and it must be 500 or greater than 500.

Any help will be highly appreciable.

Regards

Hi Muhammad Shaji Uddin 

I believe the minimum value "500" for Unit Price refers to the automatically loaded List Price field. Is that right or 500 should be the minimum value disregarding the selected Product from Catalog?

Adding validation to GRID is not an easy task once you need to consider creating a Quote and also editing a single Item. Both scenarios have independent implementation which requires good knowledge on architecture of Quotes sidecar classes.

But if are happy with overridding the value of Unit Price if it is lower than List Price then it is a piece of cake and it can be done through Studio.

Let us know your decision.

Regards

Hi Andre,

Thank you for reply. I have achieved it by customizing "modules\Products\clients\base\fields\quote-data-editablelistbutton\quote-data-editablelistbutton.js"

If you need more information I will happy to guide you

Regards

Can some one help me to understand how can we extend "modules\Products\clients\base\fields\quote-data-editablelistbutton\quote-data-editablelistbutton.js" \? because when i do.. it removed the core functionality. I just want to addd few validations to the line items when its saved from edit view.

I was struggling to figure out how to extend it as well. Finally figured it out. Probably too late for you but if anyone else has the same question, this is how I did it:

Create a new custom/modules/Products/clients/base/fields/quote-data-editablelistbutton/quote-data-editablelistbutton.js file with the following contents:

({
    extendsFrom: 'ProductsQuoteDataEditablelistbuttonField',
    
    initialize: function(options) 
    {
        this._super("initialize", [options]);
    }
})

This will extend the Products quote-data-editablelistbutton field and allow you to add custom functionality.