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 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